Info. Man.: Terminologies, Data Names, and definition Classification of Attributes

StudentDatabase.mdb (Access 2003) or StudentDatabase.accdb (Access 2007).

Example of Database File

Names

Example of atomic attribute

Address, Birthday

Example of composite attribute

age can be derived from birth date of student.

Example of derived attribute

every student has unique student no

Example of key attribute

Phone numbers

Example of multi-valued attribute

there may be chance when a student has no phone no.

Example of null valued attribute

Age, Birth date

Example of single-valued attribute

birth date cannot derive from age of student.

Example of stored attribute

tables, queries, forms, and reports.

Examples of database objects

Datasheet view. Pivot Table view. Pivot Chart view. Design view.

Four Views of Table: - _________ view used to create a table, edit data, or view data. - _______________ view used to create a pivot table. - ________________ view used to create a pivot chart. - _________ view used to create a table or modify an existing table.

Modules

Like macros, these give you the ability to automate tasks and add functionality to a form, report, or control.

list of macro actions, Visual Basic for Applications

Macros are created by choosing from a ______________________________, whereas modules are written in ___________________.

Relational Databases

Many tables that are linked through common fields and can ensure greater accuracy and less input of data. These increase flexibility of data and allow ease of collecting and maintaining historical data.

Relationships

Relational databases are databases in which common fields of information join tables. They are classified as one-to-one and one-to-many.

Database

Tables comprise the __________.

Relate to business, not technical characteristics. Meaningful, must be to the point. Unique. Readable. Composed of words taken from an approved list. Repeatable meaning that different people or the same person at different times should develop exactly or almost the same name.

What are the general guidelines about naming any data object?

tables, queries, forms, reports, macros, and modules.

What does an Access database consists of?

Use an existing database.

You may use recently opened or created databases on your computer to work with.

Use a blank database.

You must save an Access database before you start working with it.

Fields

__________ comprise the records.

Records

__________ comprise the tables.

Atomic Attribute

An attribute that cannot be divided into smaller independent attribute.

Single-Valued Attribute

An attribute that has only single value for an entity.

Key Attribute

An attribute that has unique value of each entity

Null Valued Attribute

An attribute which has not any value for an entity

attributes

An entity may have many ____________.

named, defined

Data objects must be ______ and _________ before they can be used unmistakably in a model of organizational data.

single category of data.

- Each value in a field represents a ______________________.

Text /ShortText., 255. Memo/Long text, 64,000. Number. Date/Time. Currency. AutoNumber. Yes/No. Hyperlink. Attachment. OLE Object.

10 Data Types o _______________________________________- Alphanumeric data. Use for text and for numbers that are not used in mathematical calculations. Use for names, addresses, and other relatively short pieces of text. It can store up to ______ characters. o ________________________________. Use for long pieces of text, such as notes and long descriptions. It can store up to ________characters. o _________- Numeric data. Use for numbers you want to use in mathematical calculations. If you are working with currency, use the currency type. o __________- is use for dates and times. o __________- is use for currency. It prevents rounding during calculation. o _______________- unique sequential numbers or random numbers automatically inserted when you create a record. Use to create a primary key. o ________ - logical data. It is use when only one of two values are valid. o _________- is used to store hyperlinks. o __________- is used to store attachments. o ______________ - is

Use one of the templates provided.

Access automatically creates forms, reports, and other objects that you can use. You can modify these objects to suit your needs.

subject

All of the data in a table should refer to the same _______.

Derived Attribute

An attribute that can be derived from another attribute

Composite Attribute

An attribute that can be divided into smaller independent attribute.

Multi-Valued Attribute

An attribute that can have multiple values for an entity.

Stored Attribute

An attribute that cannot be derived from another attribute

255

Default field size for the text type

same

Each field must be given a name and no two fields can have the _________ name.

tables, queries, forms, reports

In Access, _________ are used to store data, __________ to retrieve data, ________ to enter data, and __________ to display data.

One-to-Many relationships

It allows one record in one table and many records in another table.

Database

It can be one, stand-alone table that can contain many fields of information. This is the simplest, yet least powerful type of database and is often referred to as a *"flat"* database.

Table (Entity Type)

It contains or holds the data. It limits the types of data in fields and can assist in integrity and accuracy of data. Generally, they do not perform calculations and are simply data collectors for input or other means of acquiring data.

Input masks

It controls the value of a record and sets it in a specific format.

Datasheet

It displays the information stored in a table in columns and rows

Title Bar

It displays the name of the database on which you are currently working.

one-to-one relationship

It ensures that one record in one table has a (and only one) matching record in another table.

Macros

It gives you the ability to automate tasks. You can use it to add functionality to a form, report, or control.

Forms

It gives you the ability to choose the format and arrangement of fields. You can use it to enter, edit, and display data.

Record (values)

It is a ROW on a datasheet and is a set of values defined by fields.

Record

It is a collection of fields for an item you are tracking. For example, a __________ consists of all the fields for a person if you are tracking associates in a company. In addition, it is a single row which consists of multiple fields.

Table

It is a collection of related data about a specific topic (entity) that are organized in fields (column) and records (rows) on a datasheet.

Primary key

It is a field or combination of fields that uniquely identify each record in a table.

Microsoft Access

It is a powerful database software package or program that can be used to create and manage databases.

Tables

It is a set of columns and rows, with each column referred to as a field.

Field

It is the lowest level of data in a database. It consist of information about the item you are tracking.

Database File

It is the main file that encompasses the entire database.

Microsoft Office Button

It is used to create a new database, open and save a database, and many other tasks.

Ribbon

It is used to issue commands

Reports

It is used to organize or summarize your data so you can print it or view it onscreen. You often use these when you want to analyze your data or present your data to others.

Queries

It is used to to retrieve specific data from your database and to answer questions about your data.

Quick Access Toolbar

It provides access to commands you frequently use. By default, Save, Undo, and Redo appear on the ____________________________________.

Data Domain

It refers to all the valid values which a data element (column) may contain.

Views

These are different ways of looking at the same object.

Fields

These are the different characteristics (attributes) within a Table. Tables usually contain multiple of these. It is a COLUMN on a datasheet and defines the data type for a set of values in a table.

Attributes

They are characteristics of an entity

Entities

They are represented by means of their properties, called ATTRIBUTES.

Attribute (Fields)

They are the different characteristics within a Table.

Data types

They are the properties of each field. A field only has *ONE data type.*

Database Objects

They provide functionality and power to your database information. However, access is not appropriate for large databases, but is terrific for small and medium size databases with limited users.

ID

This column name is by default the primary key field

Double-click. Right click. tabs.

·_____________ an object to open the object. · ______________ an object to view a menu of options that you can use to open, rename or delete the object. · Objects that are open appear on _______. Right-click a tab to view a menu of options that you can use to save the object, close the object, or change the view.