Question 1

In Microsoft Access 2016, the field size of the data type AutoNumber is _____. ​

Accepted Answer

A) 255 characters 
B) 15 digits 
C) 520 characters 
D) 9 digits 
A) 255 characters 
B) 15 digits 
C) 520 characters 
D) 9 digits

Question 2

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

Accepted Answer

A) Record navigation bar 
B) Navigation Pane 
C) Database search bar 
D) Search Panel 
A) Record navigation bar 
B) Navigation Pane 
C) Database search bar 
D) Search Panel

Question 3

Which of the following best defines the term wizard? ​

Accepted Answer

A) It is a window that suddenly appears when a special function key is pressed. 
B) It is a series of dialog boxes that takes you step-by-step through a process. 
C) It is a graphical control element that allows a user to choose a value from a list. 
D) It is a command that has the opposite effect on successive occasions. 
A) It is a window that suddenly appears when a special function key is pressed. 
B) It is a series of dialog boxes that takes you step-by-step through a process. 
C) It is a graphical control element that allows a user to choose a value from a list. 
D) It is a command that has the opposite effect on successive occasions.

Question 4

Case 17-1 Robert, the manager of a small-scale software firm, uses Microsoft Access 2016 to store employee details. He maintains the database and updates it as the details change. Robert retrieves the stored details as and when required using Access. ​
Sam is a new employee in the software firm. Robert adds the details about Sam in a new row in the database. The new row created by Robert is an example of a _____.

Accepted Answer

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

Question 5

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

Accepted Answer

A) View button 
B) Table button 
C) Report button 
D) Form button 
A) View button 
B) Table button 
C) Report button 
D) Form button

Question 6

How is a report formatted in Microsoft Access 2016? ​

Accepted Answer

Answers will vary. The report is display

Question 7

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

Accepted Answer

A) The records in the selected table 
B) The fields in the selected table 
C) The executed queries 
D) The tables in the current database 
A) The records in the selected table 
B) The fields in the selected table 
C) The executed queries 
D) The tables in the current database

Question 8

In Microsoft Access 2016, _________ is the data type that includes Letters, digits, spaces, and special characters. ​ 
A)Hyperlink 
B)Date/Time 
C)Long Text 
D)Yes/No

Accepted Answer

The answer of In Microsoft Access 2016, _________ is the...

Question 9

Identify an accurate statement about creating a form in Microsoft Access 2016? ​

Accepted Answer

A) Tables and queries cannot perform any of the functions performed by a form. 
B) You cannot use Layout view to make changes to a form. 
C) When you first create a form, it opens in Layout view. 
D) In a simple form, all the fields and records in a table are displayed at once. 
A) Tables and queries cannot perform any of the functions performed by a form. 
B) You cannot use Layout view to make changes to a form. 
C) When you first create a form, it opens in Layout view. 
D) In a simple form, all the fields and records in a table are displayed at once.

Question 10

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

Accepted Answer

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

Question 11

In Microsoft Access 2016, the Primary Key button in the Tools group on the Table Tools Design tab is a toggle. ​

Accepted Answer

A) True 
 B)False

Question 12

Which of the following is true of working in Datasheet view on Microsoft Access 2016? ​

Accepted Answer

A) In Microsoft Access, each column is a field, and each row is a record. 
B) A field name cannot be used again in another table in the same database. 
C) In Microsoft Access, each field need not be assigned a data type. 
D) A new row can be inserted between existing records in a datasheet. 
A) In Microsoft Access, each column is a field, and each row is a record. 
B) A field name cannot be used again in another table in the same database. 
C) In Microsoft Access, each field need not be assigned a data type. 
D) A new row can be inserted between existing records in a datasheet.

Question 13

In Microsoft Access 2016, a _________ is an optional property for explaining a field in a database. ​ 
A)data type 
B)description 
C)field name 
D)record

Accepted Answer

The answer of In Microsoft Access 2016, a _________ is...

Question 14

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

Accepted Answer

A) Insert Rows button 
B) Shift Rows button 
C) Hide Rows button 
D) Delete Rows button 
A) Insert Rows button 
B) Shift Rows button 
C) Hide Rows button 
D) Delete Rows button

In Microsoft Access 2016, the field size of the data type AutoNumber is _____.

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

Which of the following best defines the term wizard?

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

How is a report formatted in Microsoft Access 2016?

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

In Microsoft Access 2016, _________ is the data type that includes Letters, digits, spaces, and special characters. A)Hyperlink B)Date/Time C)Long Text D)Yes/No

Identify an accurate statement about creating a form in Microsoft Access 2016?

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

In Microsoft Access 2016, the Primary Key button in the Tools group on the Table Tools Design tab is a toggle.

Which of the following is true of working in Datasheet view on Microsoft Access 2016?

In Microsoft Access 2016, a _________ is an optional property for explaining a field in a database. A)data type B)description C)field name D)record

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

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

Exam 17: Creating a Database

In Microsoft Access 2016, the field size of the data type AutoNumber is _____. ​

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

Which of the following best defines the term wizard? ​

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

How is a report formatted in Microsoft Access 2016? ​

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

In Microsoft Access 2016, _________ is the data type that includes Letters, digits, spaces, and special characters. ​ A)Hyperlink B)Date/Time C)Long Text D)Yes/No

Identify an accurate statement about creating a form in Microsoft Access 2016? ​

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

In Microsoft Access 2016, the Primary Key button in the Tools group on the Table Tools Design tab is a toggle. ​

Which of the following is true of working in Datasheet view on Microsoft Access 2016? ​

In Microsoft Access 2016, a _________ is an optional property for explaining a field in a database. ​ A)data type B)description C)field name D)record

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

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, the field size of the data type AutoNumber is _____.

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

Which of the following best defines the term wizard?

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

How is a report formatted in Microsoft Access 2016?

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

In Microsoft Access 2016, _________ is the data type that includes Letters, digits, spaces, and special characters. A)Hyperlink B)Date/Time C)Long Text D)Yes/No

Identify an accurate statement about creating a form in Microsoft Access 2016?

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

In Microsoft Access 2016, the Primary Key button in the Tools group on the Table Tools Design tab is a toggle.

Which of the following is true of working in Datasheet view on Microsoft Access 2016?

In Microsoft Access 2016, a _________ is an optional property for explaining a field in a database. A)data type B)description C)field name D)record

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