Question 1

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

Accepted Answer

A) Design view 
B) Table view 
C) Layout view 
D) Datasheet view 
A) Design view 
B) Table view 
C) Layout view 
D) Datasheet view

Question 2

Which of the following attributes of a table are saved only when the table object is saved?

Accepted Answer

A) records 
B) field values 
C) characteristics of the fields 
D) data records 
A) records 
B) field values 
C) characteristics of the fields 
D) data records

Question 3

The only option available for creating tables in Access is to use the datasheet view.  _________________________

Accepted Answer

A) True 
 B)False

Question 4

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS).   _________________________

Accepted Answer

A) True 
 B)False

Question 5

Match between columns
                        Premises: AutoNumber and Short Text are two examples of this Access feature which determines the values that may be entered in a field.

Accepted Answer

The Answer of field value and Backstage view and data is...

Question 6

Match between columns
                        Premises: The Access Ribbon tab that offers the option for the user to compact and repair a database.

Accepted Answer

The Answer of File tab and Print Preview and primary is...

Question 7

Clicking or tapping this navigation button 
   
moves the insertion point to the ____________________ in a table.

Accepted Answer

The answer of Clicking or tapping this navigation button 
...

Question 8

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

Accepted Answer

A) Design view 
B) Datasheet view 
C) Form view 
D) Table view 
A) Design view 
B) Datasheet view 
C) Form view 
D) Table view

Question 9

A table's contents are shown in rows and columns when using the ____________________ view.

Accepted Answer

The answer of A table's contents are shown in rows...

Question 10

Another term used for the column selector feature is ____.

Accepted Answer

A) row selector 
B) record selector 
C) name selector 
D) field selector 
A) row selector 
B) record selector 
C) name selector 
D) field selector

Question 11

Match between columns
                        Premises: A question that is asked about the data stored in a database.

Accepted Answer

The Answer of Backstage view and Print Preview and Create is...

Question 12

The query results are stored in the database in which the query has been created._________________________

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

Match between columns
                        Premises: A field, or collection of fields, whose values are used to uniquely identify each record in a table.

Accepted Answer

The Answer of Current Record Box and Print Preview and is...

Question 15

Match between columns
                        Premises: The Access 2016 view that allows the user to manage files and options.

Accepted Answer

The Answer of Create tab and data type and primary is...

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

Which of the following attributes of a table are saved only when the table object is saved?

The only option available for creating tables in Access is to use the datasheet view. _________________________

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). _________________________

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

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

A table's contents are shown in rows and columns when using the ____________________ view.

Another term used for the column selector feature is ____.

The query results are stored in the database in which the query has been created._________________________

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters

Exam 1: Access-Module 1: Creating a Database

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

Which of the following attributes of a table are saved only when the table object is saved?

The only option available for creating tables in Access is to use the datasheet view. _________________________

A software program that lets the user create databases and then manipulate the data in the databases is called a database management system (DBMS). _________________________

Clicking or tapping this navigation button moves the insertion point to the ____________________ in a table.

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

A table's contents are shown in rows and columns when using the ____________________ view.

Another term used for the column selector feature is ____.

The query results are stored in the database in which the query has been created._________________________

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Creating Advanced Queries and Enhancing Table Design

Using Form Tools and Creating Custom Forms

Creating Custom Reports

Sharing, Integrating, and Analyzing Data

Using Action Queries and Advanced Table Relationships

Automating Tasks With Macros

Using and Writing Visual Basic for Applications Code

Managing and Securing a Database

Relational Databases and Database Design

Filters