ch 1 access

Question 1

Which of the following conditions is available through a Selection​ filter?

A. AND condition
B. Delete condition
C. Equal condition
D. OR condition

Answer 1

C. Equal condition

Question 2

Which of the following utilities is used to recover in the event of loss or​ damage?

A. Compact and Repair Database
B. Back Up Database
C. Encrypt Database
D. Database Splitter

Answer 2

B. Back Up Database

Question 3

All of the following are examples of an Access object​ except?

A. Record
B. Form
C. Macro
D. Table

Answer 3

A. Record

Question 4

Where are data stored in a​ database?

A. Report
B. Form
C. Table
D. Query

Answer 4

C. Table

Question 5

Which of the following is true regarding table​ views?

A. Changes made in Datasheet view are automatically saved when you move the insertion point to a different record
B. You can​ add, edit, and delete records using Design view.
C. Datasheet view provides access to more field properties than Design view.
D. Datasheet view shows a detailed view of the table design.

Answer 5

A. Changes made in Datasheet view are automatically saved when you move the insertion point to a different record

Question 6

All of the following statements are true about creating a database​ except:

A. When creating a blank​ database, Access opens to a blank table in Datasheet view.
B. A single blank table is provided with a blank database.
C. The objects provided in a template cannot be modified.
D. Using a template to create a database saves time because it includes predefined objects

Answer 6

C. The objects provided in a template cannot be modified.

Question 7

To add a predefined table to an existing​ database, you should use which of the​ following?

A. Custom web app
B. Blank database
C. Database template
D. Application part

Answer 7

D. Application part

Question 8

Which of the following would be matched if you use a Selection​ filter’s exact match option for the title​ “Manager”?

A. Sales Manager and Manager​ (but not​ MANAGER)
B. Manager​ (but not​ MANAGER)
C. Sales Manager
D. Manager and MANAGER

Answer 8

D. Manager and MANAGER

Question 9

Which of the following is not true of an Access​ database?

A. Each field has a data type that establishes the kind of data that can be entered.
B. Every table in a database contains the same number of records as every other table.
C. A primary key uniquely identifies a record.
D. Every record in a table has the same fields as every other record.

Answer 9

B. Every table in a database contains the same number of records as every other table.

Question 10

You edit several records in an Access table. When should you execute the Save​ command?

A. Records are saved​ automatically; the Save command is not required
B. When you close the table
C. Immediately after you edit a record
D. Once at the end of the session

Answer 10

A. Records are saved​ automatically; the Save command is not required