Question 1

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 2

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 3

Field properties change depending on the data type of the field.

Accepted Answer

A) True 
 B)False

Question 4

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

Accepted Answer

The answer of A(n) ____________________ object allows a user to...

Question 5

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

Accepted Answer

one to man

Question 6

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Accepted Answer

The answer of If you use ____________________ View to design...

Question 7

Access databases cannot be password protected.

Accepted Answer

A) True 
 B)False

Question 8

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 9

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 10

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

Accepted Answer

A) True 
 B)False

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

Microsoft Access 2016 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 13

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 14

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 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

The Answer of [Home] and [Ctrl][Home] and [Left Arrow] and is...

Question 17

What are the advantages of using Access for database management?

Accepted Answer

1.  Duplicate data is minimized.
2.  Inf

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

Accepted Answer

A) True 
 B)False

Question 20

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Accepted Answer

A)  View Button 
B)  Open/Close Navigation Button 
C)  View Database Objects Button 
D)  Shutter Bar Open/Close Button 
A)  View Button 
B)  Open/Close Navigation Button 
C)  View Database Objects Button 
D)  Shutter Bar Open/Close Button

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

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

Field properties change depending on the data type of the field.

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

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

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Access databases cannot be password protected.

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

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

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

____ View provides the most options for defining fields.

Microsoft Access 2016 can best be described as ____ software.

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

Which is NOT a feature of Access reports?

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

What are the advantages of using Access for database management?

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

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Building and Using Queries

Using Forms

Using Reports

Getting Started With Office 2016

Filters

Exam 1: Getting Started With Access

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

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

Field properties change depending on the data type of the field.

A(n) ____________________ object allows a user to select a subset of data from one or more tables.

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

If you use ____________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.

Access databases cannot be password protected.

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

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

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

____ View provides the most options for defining fields.

Microsoft Access 2016 can best be described as ____ software.

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

Which is NOT a feature of Access reports?

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

What are the advantages of using Access for database management?

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

The linking field on the "many" side of a one-to-many relationship is called the foreign key field.

If the Navigation Pane is not open, click the _____ to open it and view the database objects.

Building and Using Queries

Using Forms

Using Reports

Getting Started With Office 2016

Filters