Question 1

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following is NOT available to you as you start Access?

Accepted Answer

A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database 
A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database

Question 3

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

A) True 
 B)False

Question 4

Which data type is used for sequential integers controlled by Access?

Accepted Answer

A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber 
A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber

Question 5

Which of the following is NOT a data type?

Accepted Answer

A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text 
A)  Number 
B)  Formula 
C)  Date/Time 
D)  Short Text

Question 6

More than one person can enter, update, and analyze data in an Access database at the same time.

Accepted Answer

A) True 
 B)False

Question 7

Characteristics, such as Field Name and Data Type, are ____________________  that define a field.

Accepted Answer

The answer of Characteristics, such as Field Name and Data...

Question 8

In Access, two users can edit the same record at the same time. ____________________

Accepted Answer

A) True 
 B)False

Question 9

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential 
A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential

Question 10

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

Accepted Answer

A table contains all of the raw data wit

Question 11

A(n) ____________________ key field contains unique data for each record.

Accepted Answer

The answer of A(n) ____________________ key field contains unique data...

Question 12

Which editing keystroke deletes one character to the right of the insertion point?

Accepted Answer

A)  [Backspace] 
B)  [Delete] 
C)  [F2] 
D)  [F7] 
A)  [Backspace] 
B)  [Delete] 
C)  [F2] 
D)  [F7]

Question 13

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns.
A Purchase Price field should be which data type?

Accepted Answer

A)  Text 
B)  Number 
C)  Monetary 
D)  Currency 
A)  Text 
B)  Number 
C)  Monetary 
D)  Currency

Question 14

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

Accepted Answer

A) True 
 B)False

Question 15

Critical Thinking Questions Case 1-1
Hannah wants to create a record keeping system to track the inventory needed to efficiently run her lawn and landscape business, such as spare parts, gas cans, string trimmers, etc. Her crew manager will also be using the system.
Hannah is considering whether to use Excel or Access. Which one of the following is NOT a benefit of using Access?

Accepted Answer

A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features 
A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features

Question 16

A primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 17

A(n) ____________________ object provides an easy-to-use data entry screen.

Accepted Answer

The answer of A(n) ____________________ object provides an easy-to-use data...

Question 18

The navigation buttons are found at the top of the datasheet. _________________________

Accepted Answer

A) True 
 B)False

Question 19

Which is NOT true about Access?

Accepted Answer

A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access. 
A)  It can be used to create forms 
B)  It relates lists of information in a relational database. 
C)  Reporting is limited to 20 saved reports. 
D)  Multiple users can simultaneously enter and update data within Access.

Question 20

Which data type stores only one of two values?

Accepted Answer

A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null 
A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null

Values in an AutoNumber field are automatically created by Access.

Which of the following is NOT available to you as you start Access?

The [F2] key switches between Edit and Navigation modes.

Which data type is used for sequential integers controlled by Access?

Which of the following is NOT a data type?

More than one person can enter, update, and analyze data in an Access database at the same time.

Characteristics, such as Field Name and Data Type, are ____________________ that define a field.

In Access, two users can edit the same record at the same time. ____________________

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

A(n) ____________________ key field contains unique data for each record.

Which editing keystroke deletes one character to the right of the insertion point?

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

A primary key field uniquely identifies each record.

A(n) ____________________ object provides an easy-to-use data entry screen.

The navigation buttons are found at the top of the datasheet. _________________________

Which is NOT true about Access?

Which data type stores only one of two values?

Building and Using Queries

Using Forms

Using Reports

Getting Started With Office 2016

Filters

Exam 1: Getting Started With Access

Values in an AutoNumber field are automatically created by Access.

Which of the following is NOT available to you as you start Access?

The [F2] key switches between Edit and Navigation modes.

Which data type is used for sequential integers controlled by Access?

Which of the following is NOT a data type?

More than one person can enter, update, and analyze data in an Access database at the same time.

Characteristics, such as Field Name and Data Type, are ____________________ that define a field.

In Access, two users can edit the same record at the same time. ____________________

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

A(n) ____________________ key field contains unique data for each record.

Which editing keystroke deletes one character to the right of the insertion point?

Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

A subdatasheet shows the records on the "many" side of a one-to-many relationship.

A primary key field uniquely identifies each record.

A(n) ____________________ object provides an easy-to-use data entry screen.

The navigation buttons are found at the top of the datasheet. _________________________

Which is NOT true about Access?

Which data type stores only one of two values?

Building and Using Queries

Using Forms

Using Reports

Getting Started With Office 2016

Filters