Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

A collection of records for a single subject, such as all of the customer records, is called a(n)____.

Accepted Answer

A) Table 
B) Control 
C) Element 
D) Object 
A) Table 
B) Control 
C) Element 
D) Object A

Question 3

A(n)____________________ object allows a user to select a subset of fields or records from one or more tables.

Accepted Answer

query

Question 4

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 5

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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 11

A primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 12

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 13

____________________ View is a view in which you create and manipulate the structure of an object.

Accepted Answer

The answer of ____________________ View is a view in which...

Question 14

Item 5 in the figure above is:

Accepted Answer

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

Question 15

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 16

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

Question 17

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

Accepted Answer

1.Duplicate data is minimized
2.Informat

Question 18

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 
A) Field Name and Data Type 
B) Field Name and Field Size 
C) Data Type and Format 
D) Field Size and Format

Question 19

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 of...

Question 20

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 
A)  More data storage 
B)  Multiuser capability 
C)  It's easier to set up a relational database than a spreadsheet 
D)  More reporting features

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

A collection of records for a single subject, such as all of the customer records, is called a(n)____.

A(n)____________________ object allows a user to select a subset of fields or records from one or more tables.

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

In Access, data entry screens are called forms .

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

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

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

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

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

A primary key field uniquely identifies each record.

Tables contain all of the data in the database.

____________________ View is a view in which you create and manipulate the structure of an object.

Item 5 in the figure above is:

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

Which data type stores only one of two values?

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

Which two properties are required for every field?

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

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Filters

Exam 10: Getting Started With Access 2.0

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

A collection of records for a single subject, such as all of the customer records, is called a(n)____.

A(n)____________________ object allows a user to select a subset of fields or records from one or more tables.

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

In Access, data entry screens are called forms .

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

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

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

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

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

A primary key field uniquely identifies each record.

Tables contain all of the data in the database.

____________________ View is a view in which you create and manipulate the structure of an object.

Item 5 in the figure above is:

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

Which data type stores only one of two values?

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

Which two properties are required for every field?

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

Getting Started With Microsoft Office 2010 Question

Building and Using Queries

Using Forms Question

Using Reports Question

Modifying the Database Structure Question

Improving Queries Question

Enhancing Forms Question

Analyzing Data With Reports Question

Web Apps: Working With Windows Live and Office Web Apps

Filters