BIM Access 2 Review Practice Study
Guide Test.
Access is a relational database program you can use to create tables that are ________ within the same
database. - CORRECT ANSWER related or connected
What are the two general categories of database management systems? - CORRECT ANSWER file
management system and relational database management system
Which of the following features is found in a relational database management system but not in a file
management system? - CORRECT ANSWER the ability to define relationships between tables
A relational database management system eliminates the need for - CORRECT ANSWER data
redundancy. (Redundancy is repeating the same task over and over multiple times.)
Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider -
CORRECT ANSWER what each table is "about".
The ability to relate, or ________, tables is part of what makes Access a relational database system. -
CORRECT ANSWER join
A database table can contain these two different types of keys. - CORRECT ANSWER primary and foreign
A table should be about ________ subject(s). - CORRECT ANSWER one
If a value is not entered in a field, Access actually enters a - CORRECT ANSWER null value.
When a table is opened, it is sorted by - CORRECT ANSWER the primary key field.
, A primary key field ________ contain the same value for different records. - CORRECT ANSWER cannot
For primary key fields, Access enforces entity integrity, meaning that - CORRECT ANSWER it expects a
value in the primary key field(s) for each record in the table.
What happens if you try to leave a primary key field blank? - CORRECT ANSWER Access will not let you
close the database until a value is filled in.
In which group will you find the Primary Key button? - CORRECT ANSWER Tools group on the TABLE
TOOLS DESIGN tab
In defining a primary key, which quick step do you complete just before you click the Primary key
button? - CORRECT ANSWER Click the desired field.
When a relationship is established between two tables, the primary key in one table is joined to the
________ key in the other table. - CORRECT ANSWER foreign
Data in a foreign key field ________ match data in the primary key field of the related table. - CORRECT
ANSWER must
Typically, a primary key field in one table becomes ________ in a related table. - CORRECT ANSWER the
foreign key field
The Show Table dialog box is used for - CORRECT ANSWER adding tables to the Relationships window to
create a relationship.
When you perform a join, you are - CORRECT ANSWER relating one table to another.
How does joining tables help ensure data integrity? - CORRECT ANSWER by forcing a record to be in the
primary table before it can be entered into a related table
Guide Test.
Access is a relational database program you can use to create tables that are ________ within the same
database. - CORRECT ANSWER related or connected
What are the two general categories of database management systems? - CORRECT ANSWER file
management system and relational database management system
Which of the following features is found in a relational database management system but not in a file
management system? - CORRECT ANSWER the ability to define relationships between tables
A relational database management system eliminates the need for - CORRECT ANSWER data
redundancy. (Redundancy is repeating the same task over and over multiple times.)
Chapter 2 emphasizes that in planning your database and its related tables, it is important to consider -
CORRECT ANSWER what each table is "about".
The ability to relate, or ________, tables is part of what makes Access a relational database system. -
CORRECT ANSWER join
A database table can contain these two different types of keys. - CORRECT ANSWER primary and foreign
A table should be about ________ subject(s). - CORRECT ANSWER one
If a value is not entered in a field, Access actually enters a - CORRECT ANSWER null value.
When a table is opened, it is sorted by - CORRECT ANSWER the primary key field.
, A primary key field ________ contain the same value for different records. - CORRECT ANSWER cannot
For primary key fields, Access enforces entity integrity, meaning that - CORRECT ANSWER it expects a
value in the primary key field(s) for each record in the table.
What happens if you try to leave a primary key field blank? - CORRECT ANSWER Access will not let you
close the database until a value is filled in.
In which group will you find the Primary Key button? - CORRECT ANSWER Tools group on the TABLE
TOOLS DESIGN tab
In defining a primary key, which quick step do you complete just before you click the Primary key
button? - CORRECT ANSWER Click the desired field.
When a relationship is established between two tables, the primary key in one table is joined to the
________ key in the other table. - CORRECT ANSWER foreign
Data in a foreign key field ________ match data in the primary key field of the related table. - CORRECT
ANSWER must
Typically, a primary key field in one table becomes ________ in a related table. - CORRECT ANSWER the
foreign key field
The Show Table dialog box is used for - CORRECT ANSWER adding tables to the Relationships window to
create a relationship.
When you perform a join, you are - CORRECT ANSWER relating one table to another.
How does joining tables help ensure data integrity? - CORRECT ANSWER by forcing a record to be in the
primary table before it can be entered into a related table
