Database Concepts - Exam Prep
In the ______, Access lists each object in the open Navigation Pane
database.
When editing a record, what key can you sue to navigate Down Arrow
to the next record?
T/F: To navigate to a record in a table, switch to Table True
Design view
T/F: To enter data in a table, open it in Table Datasheet True
view
What is the most efficient way to navigate to the last record Use the LAST RECORD button on the navigation bar.
in a table containing 100 records?
T/F: When you add a field to a table in Table Design view, False
entering the field is optional.
T/F: You can use the Compact & Repair Database button True
on the Database Tools tab to reduce the size of the
database.
________ view provides the most options for defining Table Design
fields.
Which Access object contains all of the data in the Table
database?
Which data type is used for sequential integers controlled AutoNumber
by Access?
T/F: Compacting a database has the same result as False
backing up a database.
Which of the following is a difference between Table C) Table Design view does not display data
Design view and Table Datasheet view?
A) Table Datasheet view does not display data
B) Table Design view displays table relationships
C) Table Design view does not display data
D) Table Datasheet view does not allow changes
What is the fastest way to open an Access database? Double-Click the database icon.
T/F: Before you close a database, you must save any False
changes you made to the data.
, Database Concepts - Exam Prep
The first step in the Form Wizard is to _____. select the fields to include in the form
Each row in a table datasheet displays a ________. record
The upper pane of _____ view shows field names and Table Design
data types.
Which data type stores web addresses? Hyperlink
Which of the following is best practice when you are A) Separate the first and last names in two fields
creating a table containing employee names?
A) Separate the first and last names into two fields
B) Keep the first and last names together in one field
C) Assign the Long data type to any field containing names
D) Create the table in Table Datasheet view
______ view is a spreadsheet-like view of the data in a Datasheet
table.
T/F: You can create a table in Table Datasheet view or True
Table Design view.
When does Access save changes you make to a record? When you move to a different record.
T/F: A new blank desktop database includes one table True
named Table1.
Which of the following tools can you uses to create a B) Simple Query Wizard
query?
A) Choose Fields Wizard
B) Simple Query Wizard
C) Query Datasheet
D) Blank Query Wizard
If you want to manage lists of data about customers and Relational Database
the products they order, use _____ software.
At what point does Access save the data in a database? When you finish entering or editing the record.
When you ____ a database, you reduce the size of the Compact & Repair
database.
In a datasheet, what do you click to select a record for Record Selector button
deletion?
In the ______, Access lists each object in the open Navigation Pane
database.
When editing a record, what key can you sue to navigate Down Arrow
to the next record?
T/F: To navigate to a record in a table, switch to Table True
Design view
T/F: To enter data in a table, open it in Table Datasheet True
view
What is the most efficient way to navigate to the last record Use the LAST RECORD button on the navigation bar.
in a table containing 100 records?
T/F: When you add a field to a table in Table Design view, False
entering the field is optional.
T/F: You can use the Compact & Repair Database button True
on the Database Tools tab to reduce the size of the
database.
________ view provides the most options for defining Table Design
fields.
Which Access object contains all of the data in the Table
database?
Which data type is used for sequential integers controlled AutoNumber
by Access?
T/F: Compacting a database has the same result as False
backing up a database.
Which of the following is a difference between Table C) Table Design view does not display data
Design view and Table Datasheet view?
A) Table Datasheet view does not display data
B) Table Design view displays table relationships
C) Table Design view does not display data
D) Table Datasheet view does not allow changes
What is the fastest way to open an Access database? Double-Click the database icon.
T/F: Before you close a database, you must save any False
changes you made to the data.
, Database Concepts - Exam Prep
The first step in the Form Wizard is to _____. select the fields to include in the form
Each row in a table datasheet displays a ________. record
The upper pane of _____ view shows field names and Table Design
data types.
Which data type stores web addresses? Hyperlink
Which of the following is best practice when you are A) Separate the first and last names in two fields
creating a table containing employee names?
A) Separate the first and last names into two fields
B) Keep the first and last names together in one field
C) Assign the Long data type to any field containing names
D) Create the table in Table Datasheet view
______ view is a spreadsheet-like view of the data in a Datasheet
table.
T/F: You can create a table in Table Datasheet view or True
Table Design view.
When does Access save changes you make to a record? When you move to a different record.
T/F: A new blank desktop database includes one table True
named Table1.
Which of the following tools can you uses to create a B) Simple Query Wizard
query?
A) Choose Fields Wizard
B) Simple Query Wizard
C) Query Datasheet
D) Blank Query Wizard
If you want to manage lists of data about customers and Relational Database
the products they order, use _____ software.
At what point does Access save the data in a database? When you finish entering or editing the record.
When you ____ a database, you reduce the size of the Compact & Repair
database.
In a datasheet, what do you click to select a record for Record Selector button
deletion?
