Question 1

Explain the difference between a primary key and a foreign key.

Accepted Answer

The primary key may consist of one or more fields whose values are used to uniquely identify each record in a table.
If the same field used as the primary key in one table is also used as a field in another table,and that field is used to create a relationship between the two tables,that field is called a foreign key in the second table.  The foreign key is not used to uniquely identify records in the second table.

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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 B

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

Records in separate tables may be connected through a(n) ____________________ that appears in both tables.

Accepted Answer

The answer of  Records in separate tables may be connected...

Question 6

Each column in an Access table datasheet represents a ____.

Accepted Answer

A)  query 
B)  record 
C)  field 
D)  primary key 
A)  query 
B)  record 
C)  field 
D)  primary key

Question 7

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

Accepted Answer

A)  255 
B)  36 
C)  64 
D)  146 
A)  255 
B)  36 
C)  64 
D)  146

Question 8

What are the five primary functions of a Database Management System (DBMS)?

Accepted Answer

1.A DBMS allows the creation of datab

Question 9

Identify the letter of the choice that best matches the phrase or definition.
- A status box that displays the number of the current record and the total number of records in a table.

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 10

A single characteristic or attribute of a person,place,object,event,or idea is a table. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

Accepted Answer

A)  Tab, Insert 
B)  Enter, PgDn 
C)  Insert, PgUp 
D)  Tab, Enter 
A)  Tab, Insert 
B)  Enter, PgDn 
C)  Insert, PgUp 
D)  Tab, Enter

Question 12

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 13

Files created with Access 2016 may be used with which previous version of Access?

Accepted Answer

A)  Access 2010 
B)  Access 2000 
C)  Access 2005 
D)  Access 2003 
A)  Access 2010 
B)  Access 2000 
C)  Access 2005 
D)  Access 2003

Question 14

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 15

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

Accepted Answer

A)  field content 
B)  field value 
C)  table value 
D)  column value 
A)  field content 
B)  field value 
C)  table value 
D)  column value

Question 16

The default sort order for records in an Access table is based on the values in the primary key field._________________________

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete 
A)  Properties 
B)  Formatting 
C)  Field Validation 
D)  Add & Delete

Question 18

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

Accepted Answer

The answer of  Use the ____________________ feature on the Ribbon...

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Explain the difference between a primary key and a foreign key.

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

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

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

Records in separate tables may be connected through a(n) ____________________ that appears in both tables.

Each column in an Access table datasheet represents a ____.

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

What are the five primary functions of a Database Management System (DBMS)?

Identify the letter of the choice that best matches the phrase or definition. - A status box that displays the number of the current record and the total number of records in a table.

A single characteristic or attribute of a person,place,object,event,or idea is a table. _________________________

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

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

Files created with Access 2016 may be used with which previous version of Access?

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

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

The default sort order for records in an Access table is based on the values in the primary key field._________________________

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

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

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

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Filters

Exam 1: Creating a Database

Explain the difference between a primary key and a foreign key.

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

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

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

Records in separate tables may be connected through a(n) ____________________ that appears in both tables.

Each column in an Access table datasheet represents a ____.

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

What are the five primary functions of a Database Management System (DBMS)?

Identify the letter of the choice that best matches the phrase or definition. - A status box that displays the number of the current record and the total number of records in a table.

A single characteristic or attribute of a person,place,object,event,or idea is a table. _________________________

Which two keys on the keyboard allow an Access user to move the insertion point to the next field to the right in datasheet view when entering data?

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

Files created with Access 2016 may be used with which previous version of Access?

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

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

The default sort order for records in an Access table is based on the values in the primary key field._________________________

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

Use the ____________________ feature on the Ribbon to see how many pages are in a report based on the current layout.

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

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

Building a Database and Defining Table Relationships

Maintaining and Querying a Database

Creating Forms and Reports

Filters