Question 1

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

In Access, data entry screens are called forms .

Accepted Answer

A) True 
 B)False

Question 4

____ View provides the most options for defining fields.

Accepted Answer

A)  Table Design 
B)  Table Creation 
C)  Field Definition 
D)  Definition 
A)  Table Design 
B)  Table Creation 
C)  Field Definition 
D)  Definition

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which is NOT true about Access?

Accepted Answer

A)  It can be used to create forms 
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 create forms 
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 7

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 8

Critical Thinking Questions Case 1-1 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)  Easier setup 
D)  Additional reporting features 
A)  More data storage 
B)  Multiuser capability 
C)  Easier setup 
D)  Additional reporting features

Question 9

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 10

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]

Question 11

Which of the following is NOT a data type?

Accepted Answer

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

Question 12

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

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

Press [Esc] once to undo a change to the current field.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ key field contains unique data for each record.

Accepted Answer

The answer of A(n) ____________________ key field contains unique data...

Question 16

Which data type stores Web addresses?

Accepted Answer

A)  Lookup Wizard 
B)  Hyperlink 
C)  URL 
D)  HTML 
A)  Lookup Wizard 
B)  Hyperlink 
C)  URL 
D)  HTML

Question 17

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

Accepted Answer

The Answer of [Home] and [Up Arrow] and [Ctrl][End] and is...

Question 18

A(n) ____________________ field automatically assigns a new number each time you add a record.

Accepted Answer

The answer of A(n) ____________________ field automatically assigns a new...

Question 19

What are the advantages of using Access for database management?

Accepted Answer

1. Duplicate data is minimized.
2. Infor

Question 20

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

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

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

In Access, data entry screens are called forms .

____ View provides the most options for defining fields.

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

Which is NOT true about Access?

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

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 previous field of the current record?

Which of the following is NOT a data type?

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

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

Press [Esc] once to undo a change to the current field.

A(n) ____________________ key field contains unique data for each record.

Which data type stores Web addresses?

A(n) ____________________ field automatically assigns a new number each time you add a record.

What are the advantages of using Access for database management?

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?

Building and Using Queries

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters

Exam 1: Getting Started With Access 2013

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

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

In Access, data entry screens are called forms .

____ View provides the most options for defining fields.

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

Which is NOT true about Access?

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

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 previous field of the current record?

Which of the following is NOT a data type?

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

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

Press [Esc] once to undo a change to the current field.

A(n) ____________________ key field contains unique data for each record.

Which data type stores Web addresses?

A(n) ____________________ field automatically assigns a new number each time you add a record.

What are the advantages of using Access for database management?

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?

Building and Using Queries

Using Forms

Using Reports

Getting Started With Microsoft Office 2013

Filters