Question 1

Jeff wants to create an Access database of the musical instruments he 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 2

The navigation bar is found at the top of the datasheet.

Accepted Answer

A) True 
 B)False

Question 3

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

Accepted Answer

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

Question 4

An Access database is called a(n) ____________________ database because more than one table can share information through a common linked field.

Accepted Answer

The answer of An Access database is called a(n) ____________________...

Question 5

In the figure above, template 5 represents an example of:

Accepted Answer

A)  Sales pipeline 
B)  Marketing projects 
C)  Events 
D)  Tasks 
A)  Sales pipeline 
B)  Marketing projects 
C)  Events 
D)  Tasks

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

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 10

Which of the following is not a Data Type?

Accepted Answer

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

Question 11

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 12

An Access database may be as large as 200 gigabytes.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following keys will help you delete unwanted data in Edit mode?

Accepted Answer

A)  [Insert] 
B)  [Home] 
C)  [Ctrl] 
D)  [Backspace] 
A)  [Insert] 
B)  [Home] 
C)  [Ctrl] 
D)  [Backspace]

Question 14

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

Accepted Answer

The Answer of [left arrow] and [up arrow] and [down is...

Question 15

Which of the following is NOT a way to open Access?

Accepted Answer

A)  From the Start menu 
B)  From Internet Explorer 
C)  From My Computer 
D)  From a shortcut on the desktop 
A)  From the Start menu 
B)  From Internet Explorer 
C)  From My Computer 
D)  From a shortcut on the desktop

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

Which data type stores only one of two values?

Accepted Answer

A)  OLE object 
B)  Hyperlink 
C)  Yes/No 
D)  Null 
A)  OLE object 
B)  Hyperlink 
C)  Yes/No 
D)  Null

Question 18

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 19

Jeff wants to create an Access database of the musical instruments he owns. He has written a paragraph about each instrument's tonal quality. Which data type should he use to define the field that will store this information?

Accepted Answer

A)  Text 
B)  Date/Time 
C)  Memo 
D)  Number 
A)  Text 
B)  Date/Time 
C)  Memo 
D)  Number

Question 20

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Exam 11: Access 2007 Unit A: Getting Started With Access 2007

Jeff wants to create an Access database of the musical instruments he owns. A Purchase Price field should be which data type?

The navigation bar is found at the top of the datasheet.

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

An Access database is called a(n) ____________________ database because more than one table can share information through a common linked field.

In the figure above, template 5 represents an example of:

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

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

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

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

Which of the following is not a Data Type?

In Access, data entry screens are called forms .

An Access database may be as large as 200 gigabytes.

Which of the following keys will help you delete unwanted data in Edit mode?

Which of the following is NOT a way to open Access?

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

Which data type stores only one of two values?

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Jeff wants to create an Access database of the musical instruments he owns. He has written a paragraph about each instrument's tonal quality. Which data type should he use to define the field that will store this information?

Tables contain all of the data in the database.

Word 2007 Unit A: Creating Documents With Word 2007

Word 2007 Unit B: Editing Documents

Word 2007 Unit C: Formatting Text and Paragraphs

Word 2007 Unit D: Formatting Documents

Outlook 2007 Unit A: Getting Started With E-Mail

Outlook 2007 Unit B: Managing Information Using Outlook

Powerpoint 2007 Unit A: Creating a Presentation in Powerpoint 2007

Powerpoint 2007 Unit B: Modifying a Presentation

Powerpoint 2007 Unit C: Inserting Objects Into a Presentation

Powerpoint 2007 Unit D: Finishing a Presentation

Access 2007 Unit B: Building and Using Queries

Access 2007 Unit C: Using Forms

Access 2007 Unit D: Using Reports

Excel 2007 Unit A: Getting Started With Excel 2007

Excel 2007 Unit B: Working With Formulas and Functions

Excel 2007 Unit C: Formatting a Worksheet

Excel 2007 Unit D: Working With Charts

Concepts Unit A: Understanding Essential Computer Concepts

Office 2007 Unit A: Getting Started With Microsoft Office 2007

Windows Vista Unit A: Getting Started With Windows Vista

Windows Vista Unit B: Understanding File Management

Windows Xp Unit A: Getting Started With Windows Xp

Windows Xp Unit B: Understanding File Management

Integration Unit A: Integrating Word and Excel

Integration Unit B: Integrating Word, Excel, and Access

Integration Unit C: Integrating Word, Excel, Access, and Powerpoint

Internet Unit A: Getting Started With Internet Explorer 7

Filters