Question 1

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

Accepted Answer

A) primary key field 
B) field value 
C) foreign key field 
D) common field 
A) primary key field 
B) field value 
C) foreign key field 
D) common field

Question 2

When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

Accepted Answer

A) Write 
B) Touch 
C) Tap 
D) Tablet 
A) Write 
B) Touch 
C) Tap 
D) Tablet

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 database or a relational database is a collection of related tables._________________________

Accepted Answer

A) True 
 B)False

Question 5

Identify the letter of the choice that best matches the phrase or definition.
-An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

Accepted Answer

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

Question 6

Which data type allows field values to contain letters,digits,and other characters?

Accepted Answer

A) Short Text 
B) AutoNumber 
C) Currency 
D) Date/Time 
A) Short Text 
B) AutoNumber 
C) Currency 
D) Date/Time

Question 7

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 
A) a query 
B) a record 
C) a field 
D) a data type

Question 8

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 
A) data,fields,and table relationships 
B) numbers,tables,and fields 
C) symbols,numbers,and tables 
D) fields,tables,and table relationships

Question 9

Field values that may be entered into a field are determined by the data type of the field._________________________

Accepted Answer

A) True 
 B)False

Question 10

Identify the letter of the choice that best matches the phrase or definition.
-The specific content of a field.

Accepted Answer

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

Question 11

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables;the field in the second table is called a(n)____________________.

Accepted Answer

The answer of A field in a second table that...

Question 12

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. 
A) tables 
B) forms 
C) reports 
D) both a.and b.

Question 13

The default primary key for an Access database is the ID field._________________________

Accepted Answer

A) True 
 B)False

Question 14

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time.
_________________________

Accepted Answer

A) True 
 B)False

Question 15

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

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

When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

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

A database or a relational database is a collection of related tables._________________________

Identify the letter of the choice that best matches the phrase or definition. -An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

Which data type allows field values to contain letters,digits,and other characters?

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

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

Field values that may be entered into a field are determined by the data type of the field._________________________

Identify the letter of the choice that best matches the phrase or definition. -The specific content of a field.

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables;the field in the second table is called a(n)____________________.

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

The default primary key for an Access database is the ID field._________________________

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

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

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 Formsmodule

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: Creating a Database

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

When working with Access in ____ Mode,the user may tap the buttons on the Ribbon and also tap to use other features of Access 2016.

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

A database or a relational database is a collection of related tables._________________________

Identify the letter of the choice that best matches the phrase or definition. -An Access 2016 tool that allows the user to quickly add fields and records to display in query results.

Which data type allows field values to contain letters,digits,and other characters?

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

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

Field values that may be entered into a field are determined by the data type of the field._________________________

Identify the letter of the choice that best matches the phrase or definition. -The specific content of a field.

A field in a second table that is the primary key in the first table is used to form a relationship between the two tables;the field in the second table is called a(n)____________________.

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

The default primary key for an Access database is the ID field._________________________

Each Access database may be as large as two gigabytes in size and may have up to 255 people using the database at the same time. _________________________

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

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 Formsmodule

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