Access Chapter 1/2 SNAP PRACTICE
CONCEPTS
File management systems are sometimes referred to as - answerflat file databases
If a field is one piece of information about a person, place, or item, then all the fields for
one unit make up a - answerRecord
The Primary Key button is located in the Tools group in the _____ tab - answerTable
Tools Design
If a value is not entered in a field, Access actually enters a - answernull value
Can more that one object be open in the work area at one time? If so, how are the
objects displayed? - answerYes; each object is displayed in its own tab
The process of defining a table's structure involves - answerassigning a data type to the
table's fields, designating a primary key, and determining the fields to be included
To insert a new field in a table, open the table in Datasheet view and then click -
answerin the first field below the Click to Add heading
How are joins represented visually in the Relationships window? - answerA black line
connects the common fields in the tables
What happens when you select a record and select Delete Record from the drop-down
list on the Delete button - answerA message displays asking you to confirm that you
want to delete the record
The ability to relate, or _____, tables is part of what makes Access a relational database
system - answerjoin
In a one-to-many relationship, the table containing the "one" is referred to as the _____
table - answerprimary
_____ integrity rules ensure that a record added to a related table has a matching
record in the primary table. - answerReferential
The Name & Caption button can be found in the _____ group in the _____ tab. -
answerProperties; Table Tools Fields
CONCEPTS
File management systems are sometimes referred to as - answerflat file databases
If a field is one piece of information about a person, place, or item, then all the fields for
one unit make up a - answerRecord
The Primary Key button is located in the Tools group in the _____ tab - answerTable
Tools Design
If a value is not entered in a field, Access actually enters a - answernull value
Can more that one object be open in the work area at one time? If so, how are the
objects displayed? - answerYes; each object is displayed in its own tab
The process of defining a table's structure involves - answerassigning a data type to the
table's fields, designating a primary key, and determining the fields to be included
To insert a new field in a table, open the table in Datasheet view and then click -
answerin the first field below the Click to Add heading
How are joins represented visually in the Relationships window? - answerA black line
connects the common fields in the tables
What happens when you select a record and select Delete Record from the drop-down
list on the Delete button - answerA message displays asking you to confirm that you
want to delete the record
The ability to relate, or _____, tables is part of what makes Access a relational database
system - answerjoin
In a one-to-many relationship, the table containing the "one" is referred to as the _____
table - answerprimary
_____ integrity rules ensure that a record added to a related table has a matching
record in the primary table. - answerReferential
The Name & Caption button can be found in the _____ group in the _____ tab. -
answerProperties; Table Tools Fields
