Question 1

A(n) ____________________ field automatically assigns a new number each time you add a record.

Accepted Answer

The answer of A(n) ____________________ field automatically assigns a new...

Question 2

Microsoft Access can best be described as ____ software.

Accepted Answer

A)  Spreadsheet 
B)  Presentation 
C)  Database 
D)  Systems

Question 3

In the figure above, use item number 1 to:

Accepted Answer

A)  Create a database from a template 
B)  Open an existing database 
C)  Search Microsoft online templates 
D)  Exit Access

Question 4

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Accepted Answer

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

Question 5

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) It's easier to set up a relational database than a spreadsheet 
D) More reporting features

Question 6

Tables, queries, and forms are examples of Access ____.

Accepted Answer

A)  Entities 
B)  Objects 
C)  Values 
D)  Controls

Question 7

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

The answer of A(n) ____________________ relationship describes when a record...

Question 9

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

Accepted Answer

A)  Relational database 
B)  Field 
C)  Record 
D)  Object

Question 10

More than one person can be entering, updating, and using an Access database at the same time.

Accepted Answer

A) True 
 B)False

Question 11

In Navigation mode, press [Tab] or this keystroke to move to the next field within the same record.

Accepted Answer

A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter]

Question 12

Item 5 in the figure above is:

Accepted Answer

A)  The date/time 
B)  A record 
C)  A field name 
D)  The focus

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

A(n) ____________________  is a fundamental building block of a relational database because this object stores all of the data.

Accepted Answer

The answer of A(n) ____________________  is a fundamental building block...

Question 15

Field names appear in the top row of a datasheet.

Accepted Answer

A) True 
 B)False

Question 16

Which is NOT true about Access?

Accepted Answer

A)  It can be used to arrange data in a variety of ways. 
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 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

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

Accepted Answer

A) True 
 B)False

Question 19

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Accepted Answer

A) True 
 B)False

Question 20

Press [Esc] once to undo a change to the current field.

Accepted Answer

A) True 
 B)False

Exam 1: Getting Started With Access 2.0

A(n) ____________________ field automatically assigns a new number each time you add a record.

Microsoft Access can best be described as ____ software.

In the figure above, use item number 1 to:

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

Tables, queries, and forms are examples of Access ____.

In Access, data entry screens are called forms .

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

A(n) ____ is a collection of tables associated with a general topic such as sales of products to customers.

More than one person can be entering, updating, and using an Access database at the same time.

In Navigation mode, press [Tab] or this keystroke to move to the next field within the same record.

Item 5 in the figure above is:

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

A(n) ____________________ is a fundamental building block of a relational database because this object stores all of the data.

Field names appear in the top row of a datasheet.

Which is NOT true about Access?

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

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

If Access assumes that you are attempting to make changes to a field value, you are in Navigation mode.

Press [Esc] once to undo a change to the current field.