Exam 2: Building a Database and Defining Table Relationships

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

 A field used to connect one table logically with another table is called a ____ field. 

 A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut._________________________

 All fields in a database should be contained in one table. _________________________ 

 A database system determines how to store,display,and process field values based on which of the following? 

 Which symbols would be used to create a custom date format that would display July 4,2016 as 7/04/16? 

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

Identify the letter of the choice that best matches the phrase or definition. - The Access option that permits a change in the value of the primary key in a table and changes the appropriate foreign key values in the related table.

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

Identify the letter of the choice that best matches the phrase or definition. - The Access database view that allows users to define or modify a table structure or field properties in a table.

 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.

 One rule of ____________________ is that Access prevents the primary key from being changed in the primary table of a relationship if a matching record exists in a related table.

 Access automatically assigns the Number data type to all new fields. _________________________ 

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

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

Identify the letter of the choice that best matches the phrase or definition. - A set of rules that Access uses to maintain consistency between related tables when data is updated in a database. A)Cascade Update Related Fields Option B)Cascade Delete Related Records Option C)Composite key D)data redundancy E)Data Type gallery F)Design G)orphaned record H)propagate I)Quick Start selection J)referential integrity

 When text is used as the Default Value for a field property,it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message. _________________________ 

 A relationship between Access tables that is a relationship between one record in the first table and zero,one,or many records in the second table,and at least one record in the second table matches at most one record in the first table,is defined as a ____ relationship. 

 In a single table,all ____________________ must be unique within that table.

 Which data type would be the best logical data type for a field named PaidDate?