Exam 2: Building a Database and Defining Table Relationships

Which data type allows the designer to define the Field Size property?

Field names in a table may only be changed in Design view. _________________________

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane. _________________________

Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated._________________________

Changing the order of fields in a database table is an example of changing a table's ____.

Access does not require a field description for every field included in a table. _________________________

Identify the letter of the choice that best matches the phrase or definition. -A group of fields added all at once using the Data Type gallery.

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

The field name displayed in database objects,including forms and reports,is determined by the Caption property._________________________

The Address Quick Start selection adds a group of relationships related to an address including Address,City,State,etc._________________________

By choosing the Definition Only option in the Import Objects dialog box,the ____ of a table is imported,but not the ____.

Access does not require a table to have a(n)primary key._________________________

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

Field value maximum storage size is defined by the Field Size property for the data types including Short Text,Number,and ____________________ only.

____________________ view allows the database designer to enter both the field names and define the field properties.

Field name display in database objects such as datasheets,forms,and reports is determined by the ____________________ property.

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

In the Database Design grid,press the Enter key to move from one property to the next property._________________________

A primary key field from one table that is also a field in another table and is used to create a relationship between the two tables is a(n)____________________ in the second table.

List six guidelines for designing databases.