Question 1

A formatted printout (or screen display) of the contents of one or more tables or queries is a form. _________________________

Accepted Answer

A) True 
 B)False

Question 2

Identify the letter of the choice that best matches the phrase or definition.
- A question that is asked about the data stored in a database.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The answer of Identify the letter of the choice that...

Question 3

What is the purpose of the primary key?

Accepted Answer

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

Question 4

Another term used for the column selector feature is ____.

Accepted Answer

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

Question 5

Identify the letter of the choice that best matches the phrase or definition.
- The Access Ribbon tab that offers the option for the user to compact and repair a database.
A)field value
B)primary key
C)Backstage view
D)data type
E)Current Record Box
F)Create tab
G)query
H)Simple Query Wizard
I)Print Preview
J)File tab

Accepted Answer

The answer of Identify the letter of the choice that...

Question 6

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

Question 7

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 8

The default ____________________ provided by Access is the ID field.

Accepted Answer

The answer of  The default ____________________ provided by Access is...

Question 9

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

Accepted Answer

A)  sorting the database 
B)  querying the database 
C)  saving the database 
D)  repairing the database

Question 10

A relationship between two tables in a database is formed using a Backstage field. _________________________

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)  tables 
B)  forms 
C)  reports 
D)  both a. and b.

Question 12

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

Accepted Answer

A)  a query 
B)  a record 
C)  a field 
D)  a data type

Question 13

Access report printing options may be changed using theNavigation dialog box._________________________

Accepted Answer

A) True 
 B)False

Question 14

In a relational DBMS,a user may create a database structure that contains which of the following?

Accepted Answer

A)  data, fields, and table relationships 
B)  numbers, tables, and fields 
C)  symbols, numbers, and tables 
D)  fields, tables, and table relationships

Question 15

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

Accepted Answer

A)  Navigation Bar 
B)  Record 
C)  Shutter Bar Open/Close 
D)  Table View

Question 16

Each record in a table is uniquely identified by a foreign key. _________________________

Accepted Answer

A) True 
 B)False

Question 17

A table is a predesigned database that includes professionally designed database objects. _________________________

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

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

Question 19

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

Accepted Answer

A)  creating reports using Access 
B)  related databases 
C)  programming tasks 
D)  queries

Question 20

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.

Accepted Answer

The answer of  Data can be presented in customized and...

Exam 1: Creating a Database

A formatted printout (or screen display) of the contents of one or more tables or queries is a form. _________________________

Identify the letter of the choice that best matches the phrase or definition. - A question that is asked about the data stored in a database. A)field value B)primary key C)Backstage view D)data type E)Current Record Box F)Create tab G)query H)Simple Query Wizard I)Print Preview J)File tab

What is the purpose of the primary key?

Another term used for the column selector feature is ____.

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

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

The default ____________________ provided by Access is the ID field.

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

A relationship between two tables in a database is formed using a Backstage field. _________________________

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

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

Access report printing options may be changed using theNavigation dialog box._________________________

In a relational DBMS,a user may create a database structure that contains which of the following?

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

Each record in a table is uniquely identified by a foreign key. _________________________

A table is a predesigned database that includes professionally designed database objects. _________________________

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

Experienced database developers avoid using spaces in field names and object names because names with spaces might cause errors if the objects are involved in ____.

Data can be presented in customized and useful ways different from tables and queries by using a Simple ____________________.