Question 1

In Microsoft Access 2016, you cannot change the default primary key. ​

Accepted Answer

A) True 
 B)False

Question 2

In Microsoft Access 2016, _________ refers to the value automatically entered in a field. ​ 
A)Description 
B)Decimal Places 
C)Default Value 
D)Caption

Accepted Answer

The answer of In Microsoft Access 2016, _________ refers to...

Question 3

_________ is the Microsoft Access view that shows a table's contents as a datasheet. ​ 
A)Access query view 
B)Worksheet view 
C)Datasheet view 
D)Datasheet query view

Accepted Answer

The answer of _________ is the Microsoft Access view that...

Question 4

All of the tables in a database are listed in the Navigation Pane. ​

Accepted Answer

A) True 
 B)False

Question 5

In the context of Microsoft Access 2016, what is a form? ​

Accepted Answer

Answers will vary. You use a form to ent

Question 6

In Microsoft Access 2016, any open table, report, or other object appears in the left pane with a tab that displays its name. ​

Accepted Answer

A) True 
 B)False

Question 7

In the accompanying figure of a Microsoft Access 2016 navigation bar, which of the following is Box 1 pointing to? ​

Accepted Answer

A) Next record button 
B) Previous record button 
C) First record button 
D) Last record button 
A) Next record button 
B) Previous record button 
C) First record button 
D) Last record button

Question 8

A database can be open but have all its objects closed. ​

Accepted Answer

A) True 
 B)False

Question 9

A(n) _____ is a field in a table that is a primary key in another table and that is included to form a relationship between the two tables. ​

Accepted Answer

A) encrypted key 
B) foreign key 
C) super key 
D) concatenated key 
A) encrypted key 
B) foreign key 
C) super key 
D) concatenated key

Question 10

In the accompanying figure of a Microsoft Access 2016 navigation bar, which of the following is Box 1 pointing to? ​

Accepted Answer

A) Blank record button 
B) New record button 
C) Next record button 
D) Last record button 
A) Blank record button 
B) New record button 
C) Next record button 
D) Last record button

Question 11

Access databases can contain thousands of records. ​

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is true of the primary key field in Microsoft Access 2016? ​

Accepted Answer

A) The data type of the primary key field cannot be changed. 
B) The default ID primary key field is assigned the Number data type. 
C) The default ID primary key field cannot be renamed. 
D) The primary key field can be chosen in Design view. 
A) The data type of the primary key field cannot be changed. 
B) The default ID primary key field is assigned the Number data type. 
C) The default ID primary key field cannot be renamed. 
D) The primary key field can be chosen in Design view.

Question 13

Which of the following is true of working with Microsoft Access 2016? ​

Accepted Answer

A) You can create a table only in Datasheet view. 
B) You can enter records only in Design view. 
C) When you create a table in Datasheet view, you should save it before switching to Design view. 
D) When you create a table in Design view, you can see the insertion point in the Field Properties 
A) You can create a table only in Datasheet view. 
B) You can enter records only in Design view. 
C) When you create a table in Datasheet view, you should save it before switching to Design view. 
D) When you create a table in Design view, you can see the insertion point in the Field Properties

Question 14

A table is not stored in a database until you save it. ​

Accepted Answer

A) True 
 B)False

Question 15

A database that contains a collection of associated tables is called a _________. ​ 
A)graph database 
B)relational database 
C)parallel database 
D)online database

Accepted Answer

The answer of A database that contains a collection of...

Question 16

In the accompanying figure of a Microsoft Access 2016 document, which of the following is Box 1 pointing to? ​ ​

Accepted Answer

A)  Encrypted Key button ​ 
B) Foreign Key button 
C) Primary Key button 
D) Concatenated Key button 
A)  Encrypted Key button ​ 
B) Foreign Key button 
C) Primary Key button 
D) Concatenated Key button

Question 17

Which of the following is true of entering records in Microsoft Access 2016? ​

Accepted Answer

A) You cannot edit the values in a field that has AutoNumber data type. 
B) When you start typing a value in a field, a star symbol appears. 
C) You cannot insert a row between existing records for a new record. 
D) After entering a record, you can press the Ctrl key to move to the next field. 
A) You cannot edit the values in a field that has AutoNumber data type. 
B) When you start typing a value in a field, a star symbol appears. 
C) You cannot insert a row between existing records for a new record. 
D) After entering a record, you can press the Ctrl key to move to the next field.

Question 18

In Datasheet view, you cannot move fields by dragging a field's column heading. ​

Accepted Answer

A) True 
 B)False

Question 19

Identify a true statement about deleting a field in Microsoft Access 2016? ​

Accepted Answer

A) When you delete a field, the values for that field remain in the table. 
B) You cannot select and delete a group of fields at the same time. 
C) You can delete fields only in Datasheet view and not in Design view. 
D) You cannot delete entered fields once they are saved. 
A) When you delete a field, the values for that field remain in the table. 
B) You cannot select and delete a group of fields at the same time. 
C) You can delete fields only in Datasheet view and not in Design view. 
D) You cannot delete entered fields once they are saved.

Question 20

Case 17-2 Alisha, a teacher, is required to maintain a database of the students in her class. She keeps track of each student's name, registration number, grades, and the number of courses they have signed up for. She uses Microsoft Access 2016 to maintain and manage the database. ​
Alisha wants to create a form to view the records in the database one at a time. She creates a new form, which opens in _____.

Accepted Answer

A) Outline view 
B) Draft View 
C) Datasheet view 
D) Layout view 
A) Outline view 
B) Draft View 
C) Datasheet view 
D) Layout view

Exam 17: Creating a Database

In Microsoft Access 2016, you cannot change the default primary key. ​

In Microsoft Access 2016, _________ refers to the value automatically entered in a field. ​ A)Description B)Decimal Places C)Default Value D)Caption

_________ is the Microsoft Access view that shows a table's contents as a datasheet. ​ A)Access query view B)Worksheet view C)Datasheet view D)Datasheet query view

All of the tables in a database are listed in the Navigation Pane. ​

In the context of Microsoft Access 2016, what is a form? ​

In Microsoft Access 2016, any open table, report, or other object appears in the left pane with a tab that displays its name. ​

In the accompanying figure of a Microsoft Access 2016 navigation bar, which of the following is Box 1 pointing to? ​

A database can be open but have all its objects closed. ​

A(n) _____ is a field in a table that is a primary key in another table and that is included to form a relationship between the two tables. ​

In the accompanying figure of a Microsoft Access 2016 navigation bar, which of the following is Box 1 pointing to? ​

Access databases can contain thousands of records. ​

Which of the following is true of the primary key field in Microsoft Access 2016? ​

Which of the following is true of working with Microsoft Access 2016? ​

A table is not stored in a database until you save it. ​

A database that contains a collection of associated tables is called a _________. ​ A)graph database B)relational database C)parallel database D)online database

In the accompanying figure of a Microsoft Access 2016 document, which of the following is Box 1 pointing to? ​ ​

Which of the following is true of entering records in Microsoft Access 2016? ​

In Datasheet view, you cannot move fields by dragging a field's column heading. ​

Identify a true statement about deleting a field in Microsoft Access 2016? ​

Introduction to Computers and the Internet

Computer Hardware

Computer Software

Computer Networks

The Internet and Email

Security and Privacy

Exploring Windows 10 and Managing Files

Using Edge Mail and People

Introducing Microsoft Office 2016

Creating a Document

Formatting a Long Document

Enhancing a Document

Creating a Workbook

Working With Formulas and Functions

Creating an Advanced Workbook

Inserting and Formatting Charts

Maintaining and Querying a Database

Creating Forms and Reports

Creating Apresentation

Enhancing a Presentation

Integrating Word, Excel, Access and Powerpoint

Filters

In Microsoft Access 2016, you cannot change the default primary key.

In Microsoft Access 2016, _________ refers to the value automatically entered in a field. A)Description B)Decimal Places C)Default Value D)Caption

_________ is the Microsoft Access view that shows a table's contents as a datasheet. A)Access query view B)Worksheet view C)Datasheet view D)Datasheet query view

All of the tables in a database are listed in the Navigation Pane.

In the context of Microsoft Access 2016, what is a form?

In Microsoft Access 2016, any open table, report, or other object appears in the left pane with a tab that displays its name.

In the accompanying figure of a Microsoft Access 2016 navigation bar, which of the following is Box 1 pointing to?

A database can be open but have all its objects closed.

A(n) _____ is a field in a table that is a primary key in another table and that is included to form a relationship between the two tables.

In the accompanying figure of a Microsoft Access 2016 navigation bar, which of the following is Box 1 pointing to?

Access databases can contain thousands of records.

Which of the following is true of the primary key field in Microsoft Access 2016?

Which of the following is true of working with Microsoft Access 2016?

A table is not stored in a database until you save it.

A database that contains a collection of associated tables is called a _________. A)graph database B)relational database C)parallel database D)online database

In the accompanying figure of a Microsoft Access 2016 document, which of the following is Box 1 pointing to?

Which of the following is true of entering records in Microsoft Access 2016?

In Datasheet view, you cannot move fields by dragging a field's column heading.

Identify a true statement about deleting a field in Microsoft Access 2016?