Question 1

An Access database is limited to a size of 1 gigabyte.

Accepted Answer

A) True 
 B)False  False

Question 2

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 D

Question 3

Which data type stores only one of two values?

Accepted Answer

A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null 
A)  Attachment 
B)  Hyperlink 
C)  Yes/No 
D)  Null C

Question 4

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 5

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

Accepted Answer

The Answer of [Home] and [Up Arrow] and [Down Arrow] is...

Question 6

Which is NOT a feature of Access reports?

Accepted Answer

A)  headers 
B)  footers 
C)  calculations on groups of records 
D)  easy-to-use data entry screen 
A)  headers 
B)  footers 
C)  calculations on groups of records 
D)  easy-to-use data entry screen

Question 7

In Access, two users can edit the same record at the same time. ____________________

Accepted Answer

A) True 
 B)False

Question 8

A primary key field uniquely identifies each record.

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

one to man

Question 10

What are the advantages of using Access for database management?

Accepted Answer

1.  Duplicate data is minimized. 
2.  In

Question 11

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 12

While editing a record, pressing [Esc] a second time ____.

Accepted Answer

A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing 
A)  deletes the current field 
B)  deletes the current datasheet 
C)  removes all data from the current record 
D)  removes all changes made to the record you are currently editing

Question 13

Critical Thinking Questions Case 1-2
Lauren wants to create an Access database of the musical instruments she owns.
Lauren 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)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System 
A)  Paragraph 
B)  Comment 
C)  Long Text 
D)  System

Question 14

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 15

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 16

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

Accepted Answer

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

Question 17

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

Accepted Answer

A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential 
A)  Hierarchical 
B)  Network 
C)  Schematic 
D)  Referential

Question 18

____________________ View is a spreadsheet-like view of the data in a table.

Accepted Answer

The answer of ____________________ View is a spreadsheet-like view of...

Question 19

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 20

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]

An Access database is limited to a size of 1 gigabyte.

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?

Which data type stores only one of two values?

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

Which is NOT a feature of Access reports?

In Access, two users can edit the same record at the same time. ____________________

A primary key field uniquely identifies each record.

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

What are the advantages of using Access for database management?

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

While editing a record, pressing [Esc] a second time ____.

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

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

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

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

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

____________________ View is a spreadsheet-like view of the data in a table.

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

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

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 1: Getting Started With Access

An Access database is limited to a size of 1 gigabyte.

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?

Which data type stores only one of two values?

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

Which is NOT a feature of Access reports?

In Access, two users can edit the same record at the same time. ____________________

A primary key field uniquely identifies each record.

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

What are the advantages of using Access for database management?

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

While editing a record, pressing [Esc] a second time ____.

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

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

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

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

____ integrity refers to a set of Access rules that govern data entry and helps to ensure data accuracy.

____________________ View is a spreadsheet-like view of the data in a table.

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

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

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Importing and Exporting Data

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters