Question 1

Match between columns
                        Premises: Next field of the current record

Accepted Answer

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

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

Access databases cannot be password protected.​

Accepted Answer

A) True 
 B)False

Question 4

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

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 8

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 9

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 10

Which of the following is NOT available to you as you start Access?

Accepted Answer

A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database 
A)  opening an existing database 
B)  recalibrating an existing database 
C)  creating a new database from a template 
D)  creating a new blank database

Question 11

Tables contain all of the data in the database.

Accepted Answer

A) True 
 B)False

Question 12

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 13

____________________ 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 14

What are the advantages of using Access for database management?

Accepted Answer

1.  Duplicate data is minimized. 
2.  In

Question 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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 20

____ 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

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

Access databases cannot be password protected.

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

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

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

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

Which is NOT true about Access?

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

Which of the following is NOT available to you as you start Access?

Tables contain all of the data in the database.

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

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

What are the advantages of using Access for database management?

Microsoft Access 2016 can best be described as ____ software.

Which is NOT a feature of Access reports?

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

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

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

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

Getting Started With Office 2017

Building and Using Queries

Using Forms

Using Reports

Filters

Exam 5: Module 1 Getting Started With Access

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

Access databases cannot be password protected.​

If a number has already been incremented beyond 1 for a first record in a field of the AutoNumber data type, the AutoNumber data type can no longer work as intended.

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

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

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

Which is NOT true about Access?

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

Which of the following is NOT available to you as you start Access?

Tables contain all of the data in the database.

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

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

What are the advantages of using Access for database management?

Microsoft Access 2016 can best be described as ____ software.

Which is NOT a feature of Access reports?

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

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

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

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

Getting Started With Office 2017

Building and Using Queries

Using Forms

Using Reports

Filters

Access databases cannot be password protected.