Question 1

Which is NOT a feature of Access reports?

Accepted Answer

A)  Headers 
B)  Footers 
C)  Calculations on groups of records 
D)  Easy-to-use data entry screen

Question 2

What are the advantages of database software such as Access over spreadsheet software such as Excel?

Accepted Answer

The answer of What are the advantages of database software...

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

You can move datasheet columns by dragging the field name left or right.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

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

Question 7

Lauren wants to create an Access database of the musical instruments she owns.She 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) Text 
B) Date/Time 
C) Memo 
D) Number

Question 8

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Accepted Answer

The answer of ____________________ View is a spreadsheet-like grid that...

Question 9

Which data type links files created in other programs such as pictures, sound clips, or documents?

Accepted Answer

A)  Lookup 
B)  Attachment 
C)  Yes/No 
D)  Link Wizard

Question 10

Which two properties are required for every field?

Accepted Answer

A)  Field Name and Data Type 
B)  Field Name and Field Size 
C)  Data Type and Format 
D)  Field Size and Format

Question 11

Press this keystroke combination to move focus to the last field of the last record.

Accepted Answer

A)  [Alt][Ctrl][Up Arrow] 
B)  [Ctrl][Up Arrow] 
C)  [Ctrl][End] 
D)  [Ctrl][Page Up]

Question 12

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 13

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

Which data type is used to sequentially order each record added to a table?

Accepted Answer

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

Question 16

The Database window displays the Tables, Queries, Forms, and Reports.Describe what these four objects represent.

Accepted Answer

The answer of The Database window displays the Tables, Queries,...

Question 17

Match between columns
                        Premises: First field of the first record
Last field of the last record
Previous field of the current record
Current field of the next record
Last field of the current record
First field of the current record
Next field of the current record
Current field of the previous record

Accepted Answer

The Answer of [End] and [Ctrl][Home] and [left arrow] and is...

Question 18

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

Accepted Answer

A) True 
 B)False

Question 19

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)  Record 
B)  Table 
C)  Database 
D)  Object

Question 20

Pressing [Ctrl][;] will insert the current date in a Date field.

Accepted Answer

A) True 
 B)False

Exam 1: Getting Started With Access 2.0

Which is NOT a feature of Access reports?

What are the advantages of database software such as Access over spreadsheet software such as Excel?

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

You can move datasheet columns by dragging the field name left or right.

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

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

Lauren wants to create an Access database of the musical instruments she owns.She 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?

____________________ View is a spreadsheet-like grid that displays a table's fields and records.

Which data type links files created in other programs such as pictures, sound clips, or documents?

Which two properties are required for every field?

Press this keystroke combination to move focus to the last field of the last record.

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

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

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

Which data type is used to sequentially order each record added to a table?

The Database window displays the Tables, Queries, Forms, and Reports.Describe what these four objects represent.

Match the shortcut keystrokes to the correct action.

A foreign key field is always on the "one" side of a one-to-many relationship between two tables.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Pressing [Ctrl][;] will insert the current date in a Date field.