Question 1

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 2

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 3

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

Accepted Answer

A)  report 
B)  query 
C)  form 
D)  table 
A)  report 
B)  query 
C)  form 
D)  table

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

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 7

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

Accepted Answer

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

Question 8

"Focus" refers to which data you would edit if you started typing.

Accepted Answer

A) True 
 B)False

Question 9

Microsoft 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 10

In Navigation mode, press [Tab] or ____ 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

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 12

Which data type is used for sequential integers controlled by Access?

Accepted Answer

A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber 
A)  Hyperlink 
B)  Web 
C)  Lookup Wizard 
D)  AutoNumber

Question 13

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 14

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

Accepted Answer

A)  record 
B)  table 
C)  database 
D)  object 
A)  record 
B)  table 
C)  database 
D)  object

Question 15

In the accompanying figure, the leftmost TourSales is a ____ tab.

Accepted Answer

A)  query 
B)  table 
C)  form 
D)  report 
A)  query 
B)  table 
C)  form 
D)  report

Question 16

Which keystroke combination moves focus to the last field of the last record?

Accepted Answer

A)  [Alt][Ctrl][Up Arrow] 
B)  [Ctrl][Up Arrow] 
C)  [Ctrl][End] 
D)  [Ctrl][Page Up] 
A)  [Alt][Ctrl][Up Arrow] 
B)  [Ctrl][Up Arrow] 
C)  [Ctrl][End] 
D)  [Ctrl][Page Up]

Question 17

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she 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 18

A primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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]

In Access, data entry screens are called forms .

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

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

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

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

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

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

"Focus" refers to which data you would edit if you started typing.

Microsoft Access can best be described as ____ software.

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

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

Which data type is used for sequential integers controlled by Access?

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

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

In the accompanying figure, the leftmost TourSales is a ____ tab.

Which keystroke combination moves focus to the last field of the last record?

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

A primary key field uniquely identifies each record.

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters

Exam 1: Getting Started With Microsoft Office 2013

In Access, data entry screens are called forms .

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

In the accompanying figure, the rightmost TourSales tab is a ____ tab.

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

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

The Database window displays the tables, queries, forms, and reports. Describe what these four objects represent.

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

"Focus" refers to which data you would edit if you started typing.

Microsoft Access can best be described as ____ software.

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

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

Which data type is used for sequential integers controlled by Access?

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

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

In the accompanying figure, the leftmost TourSales is a ____ tab.

Which keystroke combination moves focus to the last field of the last record?

Critical Thinking Questions Case 1-2 Lauren wants to create an Access database of the musical instruments she owns. A Purchase Price field should be which data type?

A primary key field uniquely identifies each record.

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

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

Getting Started With Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Filters