Question 1

No two records can have the same value in the primary key field.

Accepted Answer

A) True 
 B)False

Question 2

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Accepted Answer

A) True 
 B)False

Question 3

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Microsoft Access can best be described as ____ software.

Accepted Answer

A)  spreadsheet 
B)  presentation 
C)  database 
D)  systems 
A)  spreadsheet 
B)  presentation 
C)  database 
D)  systems

Question 6

Which shortcut key moves focus to the first field of the current record?

Accepted Answer

A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5] 
A)  [Home] 
B)  [End] 
C)  [F4] 
D)  [F5]

Question 7

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Accepted Answer

1-to-many,

Question 8

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

Accepted Answer

A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System 
A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System

Question 9

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

The answer of If you use ____________________ View to design...

Question 10

While editing a record, pressing [Esc] a second time ____.

Accepted Answer

A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing 
A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing

Question 11

You can use the Calendar Box to enter dates in a Date/Time field.

Accepted Answer

A) True 
 B)False

Question 12

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 13

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 14

Field properties change depending on the data type of the field.

Accepted Answer

A) True 
 B)False

Question 15

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

A) True 
 B)False

Question 16

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

Accepted Answer

A)  Pinned space 
B)  Navigation Pane 
C)  Objects Bar 
D)  Objects Tab 
A)  Pinned space 
B)  Navigation Pane 
C)  Objects Bar 
D)  Objects Tab

Question 17

The ____________________ refers to which data you would edit if you started typing.

Accepted Answer

The answer of The ____________________ refers to which data you...

Question 18

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Accepted Answer

A)  report 
B)  query 
C)  form 
D)  table 
A)  report 
B)  query 
C)  form 
D)  table

Question 19

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

Accepted Answer

A)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT 
A)  FILE 
B)  VIEW 
C)  PREVIEW 
D)  REPORT

Question 20

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

No two records can have the same value in the primary key field.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

An Access database is limited to a size of 1 gigabyte.

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

Microsoft Access can best be described as ____ software.

Which shortcut key moves focus to the first field of the current record?

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

While editing a record, pressing [Esc] a second time ____.

You can use the Calendar Box to enter dates in a Date/Time field.

Values in an AutoNumber field are automatically created by Access.

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

Field properties change depending on the data type of the field.

"Focus" refers to which data you would edit if you started typing.

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

The ____________________ refers to which data you would edit if you started typing.

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

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

Building and Using Queries

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters

Exam 1: Getting Started With Access 2013

No two records can have the same value in the primary key field.

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

An Access database is limited to a size of 1 gigabyte.

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

Microsoft Access can best be described as ____ software.

Which shortcut key moves focus to the first field of the current record?

A(n) ____________________ relationship describes when a record from one table is related to several records in another table.

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. Lauren has written a paragraph describing the use for each inventory item. Which data type should she use to define the field that will store this information?

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

While editing a record, pressing [Esc] a second time ____.

You can use the Calendar Box to enter dates in a Date/Time field.

Values in an AutoNumber field are automatically created by Access.

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

Field properties change depending on the data type of the field.

"Focus" refers to which data you would edit if you started typing.

The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.

The ____________________ refers to which data you would edit if you started typing.

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.

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

Building and Using Queries

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters