Question 1

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 
A) Hyperlink 
B) Web 
C) Lookup Wizard 
D) AutoNumber

Question 2

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 3

Relational ____________________ software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.

Accepted Answer

The answer of Relational ____________________ software is used to manage...

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

The [F2] key switches between Edit and Navigation modes.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Item 7 in the figure above is the:

Accepted Answer

A) Record selector box 
B) Customers table tab 
C) Navigation pane 
D) Focus 
A) Record selector box 
B) Customers table tab 
C) Navigation pane 
D) Focus

Question 8

This Access object provides an easy-to-use data entry screen.

Accepted Answer

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

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

The answer of The ____________________ refers to which data you...

Question 14

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 
A) Lookup 
B) Attachment 
C) Yes/No 
D) Link Wizard

Question 15

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 
A)  Text 
B)  Date/Time 
C)  Memo 
D)  Number

Question 16

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

Question 17

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 18

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

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 20

Values in an AutoNumber field are automatically created by Access.

Accepted Answer

A) True 
 B)False

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

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

Relational ____________________ software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.

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

The [F2] key switches between Edit and Navigation modes.

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

Item 7 in the figure above is the:

This Access object provides an easy-to-use data entry screen.

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

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

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

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

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

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?

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

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

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)____.

Values in an AutoNumber field are automatically created by Access.

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

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

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

Relational ____________________ software is used to manage data that can be organized into lists of related information such as customers, products, vendors, employees, projects, or sales.

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

The [F2] key switches between Edit and Navigation modes.

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

Item 7 in the figure above is the:

This Access object provides an easy-to-use data entry screen.

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

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

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

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

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

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?

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

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

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)____.

Values in an AutoNumber field are automatically created by Access.

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