Question 1

Item 8 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 C

Question 2

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

Accepted Answer

query

Question 3

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

Accepted Answer

A)  [Home] 
B)  [Shift][Tab] 
C)  [Up Arrow] 
D)  [F5] 
A)  [Home] 
B)  [Shift][Tab] 
C)  [Up Arrow] 
D)  [F5] B

Question 4

Item 5 in the figure above is:

Accepted Answer

A)  Where a new record would be entered 
B)  Where a new field would be entered 
C)  A field name 
D)  The navigation pane 
A)  Where a new record would be entered 
B)  Where a new field would be entered 
C)  A field name 
D)  The navigation pane

Question 5

When creating a database using an Access template, you must remember that field names cannot be altered later .

Accepted Answer

A) True 
 B)False

Question 6

This Access object contains all of the raw data within the database.

Accepted Answer

A)  Query 
B)  Form 
C)  Table 
D)  Module 
A)  Query 
B)  Form 
C)  Table 
D)  Module

Question 7

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

Question 8

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

Accepted Answer

1-to-many,

Question 9

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

Accepted Answer

A)  Lookup 
B)  OLE object 
C)  Yes/No 
D)  Link Wizard 
A)  Lookup 
B)  OLE object 
C)  Yes/No 
D)  Link Wizard

Question 10

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] 
A)  [End] 
B)  [Page Down] 
C)  [Down Arrow] 
D)  [Enter]

Question 11

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

Accepted Answer

A) True 
 B)False

Question 12

The [Esc] key will only affect the current field being edited.

Accepted Answer

A) True 
 B)False

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

Which data type stores Web addresses?

Accepted Answer

A)  Lookup Wizard 
B)  Hyperlink 
C)  www address 
D)  HTML 
A)  Lookup Wizard 
B)  Hyperlink 
C)  www address 
D)  HTML

Question 15

Microsoft Office 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 16

In the figure above, template 8 is an example of:

Accepted Answer

A)  Tasks 
B)  Events 
C)  Issues 
D)  Assets 
A)  Tasks 
B)  Events 
C)  Issues 
D)  Assets

Question 17

Which is NOT true about Access?

Accepted Answer

A)  It can be used to arrange data in a variety of ways. 
B)  It allows links between lists of information. 
C)  It is able to store any number of records up to 20 gigabytes. 
D)  Multiple users can simultaneously enter and update data within Access. 
A)  It can be used to arrange data in a variety of ways. 
B)  It allows links between lists of information. 
C)  It is able to store any number of records up to 20 gigabytes. 
D)  Multiple users can simultaneously enter and update data within Access.

Question 18

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 
A)  Object 
B)  Record 
C)  Field 
D)  Table

Question 19

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 20

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

Accepted Answer

1. Data entry is faster and easier.
2. I

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

Item 8 in the figure above is:

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

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

Item 5 in the figure above is:

When creating a database using an Access template, you must remember that field names cannot be altered later .

This Access object contains all of the raw data within the database.

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

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

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

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

The Navigation buttons on a datasheet display the total number of fields in the datasheet.

The [Esc] key will only affect the current field being edited.

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

Which data type stores Web addresses?

Microsoft Office Access can best be described as ____ software.

In the figure above, template 8 is an example of:

Which is NOT true about Access?

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

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

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

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