CS302 UPDATED ACTUAL Exam
Questions and CORRECT Answers
The ____ key is the linking field on the "many" side of the relationship. - CORRECT
ANSWER - foreign
Database templates create tables and queries, but not forms and reports. - CORRECT
ANSWER - false
Which of the following templates lets you create a database from scratch? - CORRECT
ANSWER - blank desktop database
besides reducing file size, what other benefits does compacting an Access database provide? -
CORRECT ANSWER - repairing the database
to rename a field in Table Datasheet view, you change the text in the _____ - CORRECT
ANSWER - column heading
Which data type stores only one of two values? - CORRECT ANSWER - yes/no
a relational database can best be described as a collection of related ____ designed to minimize
redundant data. - CORRECT ANSWER - tables
to navigate a record in a table, switch to Table Design View - CORRECT ANSWER - false
in Form Design view, you can make changes while displaying the data - CORRECT
ANSWER - false
to add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane
- CORRECT ANSWER - true
, what are you doing when you enter data into a subdatasheet? - CORRECT ANSWER - you
are entering records in the related table
to back up a database, you use the ______ command - CORRECT ANSWER - back up
database
to add, delete, or change fields in a query, you use the Query Design view. - CORRECT
ANSWER - true
tables, queries, and forms are examples of Access - CORRECT ANSWER - objects
sorting a table data sheet temporarily displays only those records that match given criteria -
CORRECT ANSWER - false
when using the Report Wizard, you can click the back button to review previous dialog boxes. -
CORRECT ANSWER - true
to link the data from one table to another in Access relational database, a(n) _______ must be
common to each table - CORRECT ANSWER - field
what is the most efficient way to navigate to the last record in a table containing 100 records? -
CORRECT ANSWER - use the Last Record button on the navigation bar
suppose you rename a field in Table Design view. what must you do before you can view the
data in the table? - CORRECT ANSWER - save the table
to add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.
- CORRECT ANSWER - true
Questions and CORRECT Answers
The ____ key is the linking field on the "many" side of the relationship. - CORRECT
ANSWER - foreign
Database templates create tables and queries, but not forms and reports. - CORRECT
ANSWER - false
Which of the following templates lets you create a database from scratch? - CORRECT
ANSWER - blank desktop database
besides reducing file size, what other benefits does compacting an Access database provide? -
CORRECT ANSWER - repairing the database
to rename a field in Table Datasheet view, you change the text in the _____ - CORRECT
ANSWER - column heading
Which data type stores only one of two values? - CORRECT ANSWER - yes/no
a relational database can best be described as a collection of related ____ designed to minimize
redundant data. - CORRECT ANSWER - tables
to navigate a record in a table, switch to Table Design View - CORRECT ANSWER - false
in Form Design view, you can make changes while displaying the data - CORRECT
ANSWER - false
to add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane
- CORRECT ANSWER - true
, what are you doing when you enter data into a subdatasheet? - CORRECT ANSWER - you
are entering records in the related table
to back up a database, you use the ______ command - CORRECT ANSWER - back up
database
to add, delete, or change fields in a query, you use the Query Design view. - CORRECT
ANSWER - true
tables, queries, and forms are examples of Access - CORRECT ANSWER - objects
sorting a table data sheet temporarily displays only those records that match given criteria -
CORRECT ANSWER - false
when using the Report Wizard, you can click the back button to review previous dialog boxes. -
CORRECT ANSWER - true
to link the data from one table to another in Access relational database, a(n) _______ must be
common to each table - CORRECT ANSWER - field
what is the most efficient way to navigate to the last record in a table containing 100 records? -
CORRECT ANSWER - use the Last Record button on the navigation bar
suppose you rename a field in Table Design view. what must you do before you can view the
data in the table? - CORRECT ANSWER - save the table
to add a field list to the upper pane in Query Design view, drag a table from the Navigation Pane.
- CORRECT ANSWER - true
