Question 1

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

Accepted Answer

Datasheet

Question 2

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] B

Question 3

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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

Accepted Answer

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

Question 6

In Access, data entry screens are called forms . _________________________

Accepted Answer

A) True 
 B)False

Question 7

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables. _________________________

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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 10

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

Accepted Answer

A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode 
A)  Edit mode 
B)  Navigation mode 
C)  Update mode 
D)  Form mode

Question 11

____ 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 12

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 13

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 14

Which 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 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

Which data type links files created in other programs such as pictures 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 20

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

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

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

Tables contain all of the data in the database.

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

In Access, data entry screens are called forms . _________________________

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables. _________________________

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

Which is NOT true about Access?

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

____ View provides the most options for defining fields.

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 is NOT a feature of Access reports?

Which Access object provides an easy-to-use data entry screen?

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

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

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

Microsoft Access can best be described as ____ software.

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters

Exam 1: Getting Started With Access 2013

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

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

Tables contain all of the data in the database.

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

In Access, data entry screens are called forms . _________________________

A(n) foreign key field is always on the "one" side of a one-to-many relationship between two tables. _________________________

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

Which is NOT true about Access?

In a datasheet, which mode assumes that you are trying to change the value of a particular field?

____ View provides the most options for defining fields.

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 is NOT a feature of Access reports?

Which Access object provides an easy-to-use data entry screen?

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

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

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

Microsoft Access can best be described as ____ software.

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Importing and Exporting Data

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Macros

Administering the Database

Access and the Web

Getting Started With Microsoft Office 2013

Filters