Exam 6: Microsoft Access 2010,workshop 2: Gathering Data Into a Database

When referential integrity is enforced,you CANNOT ________ a record from the one side table if matching records exist in the many side table.

When a database is ________,the result is several smaller tables,each representing a different thing.

The two methods of entering data directly into Access are typing the data into the table or ________.

Design changes are not saved until you save,but data changes are automatically saved.

Record changes are saved automatically,but ________ changes are not saved until you save.

Data types define the kinds of data that can be entered into a field.

If you need to use a ________ data type,you do NOT have to select it,since it is the default data type.

________ occurs when data is repeated several times in a database.

The two most common data types are ________.

A(n)________ allows you to work with two or more tables in the same query,report,or form.

Access has a wizard that creates automatic masks for items such as zip codes,passwords,dates,and times.

When you create a junction table to form a many-to-many relationship,the junction table is on the ________ side of the two relationships.

When you import an existing table into Access,Access creates a table using the ________ headings for field names.

A ________ key is used when two fields are needed to uniquely identify a record.

The relationships in a relational database are created by joining the tables together and relating fields.

When you ________ the tables in a database,there will be no redundancy in the tables.

A person,place,item,or event that you want to preserve data about is called a(n)________.

Cardinality represents the relationship between two tables when one record in the first tables corresponds to many records in the second table.

The first field in a table is the ________,which must be a unique entry.

When you add relationships to tables,you can work with two or more ________ in the same query,report,or form.