Question 1

Which Access 2016 view contains commands used to manage Access files and options? 
A) Datasheet view
B) Design view 
C) Backstage view
D) Form view

Accepted Answer

Backstage view contains commands related to managing Access files, such as creating a new database, saving, opening and closing a database, and changing program options.

Question 2

To save a table in Access with a name that relates to the database (a name other than the Access default name),it is necessary to complete which process? 
A) save the table object
B) save the database 
C) save the record
D) save the field

Accepted Answer

To save a table in Access with a name that relates to the database (a name other than the Access default name), it is necessary to save the table object with a new name. Saving the database or the record or the field will not change the name of the table.

Question 3

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column? 
A) wide fit
B) best fit 
C) column adjustment fit
D) trim fit

Accepted Answer

The term that describes the Access feature of sizing a column in datasheet view so that it is just wide enough to display the longest visible value in the column is called "best fit." This feature saves space and makes it easier to view data in a table or query.

Question 4

Which button is used to open and close the Navigation Pane? 
A) Navigation Bar
B) Record 
C) Shutter Bar Open/Close
D) Table View

Accepted Answer

The Shutter Bar Open/Close button is used to open and close the Navigation Pane in Microsoft Access. The Navigation Bar refers to a different feature within the program, Record and Table View buttons do not relate to the Navigation Pane.

Question 5

What is the purpose of the primary key? 
A) to uniquely identify each record in a table 
B) to uniquely identify each table in a database 
C) to create a relationship between two tables in a database 
D) to create a relationship for queries in a database

Accepted Answer

The purpose of the primary key is to uniquely identify each record in a table. It ensures that each record in the table can be uniquely identified and accessed, and is essential for maintaining data integrity and avoiding duplicates.

Question 6

The specific content of a field is referred to as the ____. 
A) field content
B) field value 
C) table value
D) column value

Accepted Answer

The specific content of a field is referred to as the field value. The other answer choices either do not accurately describe the content of a field or refer to a broader concept such as a column or table, rather than the specific data within a field.

Question 7

Which view is used to make design changes to a form while the form is displaying data? 
A) Design view
B) Table view 
C) Layout view
D) Datasheet view

Accepted Answer

Layout view is used to make design changes to a form while the form is displaying data. In this view, you can add or modify controls directly on the form and see how they will look to users who open the form. Design view is used for creating and modifying the design of a form without data. Table view is used to view and edit the data in a table. Datasheet view is used to view and edit the data in a form or report in a spreadsheet-like layout.

Question 8

Another term used for the column selector feature is ____. 
A) row selector
B) record selector 
C) name selector
D) field selector

Accepted Answer

The column selector feature is used to select fields in a table or dataset, which makes the best choice for this question the term "field selector." The other options are not as accurate or relevant to the feature being described.

Question 9

Which Access database object(s) might be used to enter,edit,and view records in a database? 
A) tables
B) forms 
C) reports
D) both a. and b.

Accepted Answer

The answer of  Which Access database object(s) might be used...

Question 10

Which Access 2016 view shows the contents of a table as a datasheet? 
A) Design view
B) Datasheet view 
C) Form view
D) Table view

Accepted Answer

Datasheet view shows the contents of a table in a spreadsheet-like format, allowing users to enter, edit, and delete data directly. Design view allows users to modify the structure of the table, Form view displays the data in a more user-friendly layout, and Table view shows the table structure without any data.

Question 11

Which Access feature provides information about Access commands and features and instructions about how to use them? 
A) Query Wizard
B) Access Help 
C) Form Wizard
D) Report Wizard

Accepted Answer

Access Help provides information about Access commands and features as well as instructions on how to use them. The Query Wizard, Form Wizard, and Report Wizard are all tools to help users create specific types of objects in Access.

Question 12

How many characters may a field name in Access contain including numbers,letters,spaces,and special characters? 
A) 255
B) 36 
C) 64
D) 146

Accepted Answer

The answer of  How many characters may a field name...

Question 13

What function does compacting an Access database perform other than reducing the file size? 
A) sorting the database
B) querying the database 
C) saving the database
D) repairing the database

Accepted Answer

Compacting an Access database not only reduces the file size but also helps in repairing the database by removing any unnecessary data, reorganizing the data, and fixing any corrupt or damaged tables.

Question 14

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables? 
A) primary key field
B) field value 
C) foreign key field
D) common field

Accepted Answer

The answer of  Which term identifies a field that appears...

Question 15

Each column in an Access table datasheet represents a ____. 
A) query
B) record 
C) field
D) primary key

Accepted Answer

In an Access table datasheet, each column represents a field, which is a specific piece of data or attribute that describes the records in the table. Option A is incorrect because a query is a tool used to extract data from one or more tables in a specific way. Option B is incorrect because a record represents a complete set of data for one entity, such as a customer or an order. Option D is incorrect because a primary key is a field that uniquely identifies each record in a table.

Question 16

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question? 
A) form
B) table 
C) query
D) report

Accepted Answer

A query is used to ask a question about the data stored in a database and display specific fields and records that answer the question. Forms are used to enter, edit, and view data in a user-friendly way, tables store data in the database, and reports display data in a formatted and organized way.

Question 17

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks? 
A) closes the current database 
B) closes the current database and exits Access 2016 
C) closes only the current database object 
D) copies the current database and exits Access 2016

Accepted Answer

Clicking on the Close option from the Backstage view in Access 2016 will only close the current database, but it will not exit Access 2016. To exit Access, you will need to click on the Exit option from the Backstage view or use the Close button on the top right corner of the Access window.

Question 18

Each row in an Access table datasheet displays which of the following? 
A) a query
B) a record 
C) a field
D) a data type

Accepted Answer

Each row in an Access table datasheet displays a record, which is a complete set of information about a specific entity or object being stored in the database.

Question 19

Data organized as a collection of tables creates this type of data system. 
A) database
B) database management system (DBMS) 
C) primary key system
D) relational database management system

Accepted Answer

A relational database management system organizes data as a collection of tables and allows for the creation, modification, and querying of data within those tables. It includes a system of primary keys and foreign keys to establish relationships between tables. Therefore, option D is the best choice. Option A, just "database" is too broad and could refer to any type of data system. Option B refers to the software used to manage databases but does not specify the type of database system. Option C refers to a component of a relational database management system but does not describe the system as a whole.

Question 20

Which Ribbon group allows you to add fields to an Access table with defined data types? 
A) Properties
B) Formatting 
C) Field Validation
D) Add & Delete

Accepted Answer

The Add & Delete group in the Fields tab of the ribbon allows you to add fields to an Access table with defined data types. The Properties group is used to view and modify the properties of selected fields or objects. The Formatting group is used to apply formatting to selected fields or objects. The Field Validation group is used to set validation rules for selected fields.

Quiz 1: Creating a Database

Which Access 2016 view contains commands used to manage Access files and options?

To save a table in Access with a name that relates to the database (a name other than the Access default name) ,it is necessary to complete which process?

Which of the following terms describes the Access feature that allows a user to size a column in datasheet view so that the column is just wide enough to display the longest visible value in the column?

Which button is used to open and close the Navigation Pane?

What is the purpose of the primary key?

The specific content of a field is referred to as the ____.

Which view is used to make design changes to a form while the form is displaying data?

Another term used for the column selector feature is ____.

Which Access database object(s) might be used to enter,edit,and view records in a database?

Which Access 2016 view shows the contents of a table as a datasheet?

Which Access feature provides information about Access commands and features and instructions about how to use them?

How many characters may a field name in Access contain including numbers,letters,spaces,and special characters?

What function does compacting an Access database perform other than reducing the file size?

Which term identifies a field that appears in two separate tables and may be used to connect records in the separate tables?

Each column in an Access table datasheet represents a ____.

Which Access database object asks a question about the data stored in a database and displays specific fields and records that answer the question?

Clicking on the Close option from the Backstage view in Access 2016 performs which of the following tasks?

Each row in an Access table datasheet displays which of the following?

Data organized as a collection of tables creates this type of data system.

Which Ribbon group allows you to add fields to an Access table with defined data types?