Exam 17: Creating a Database

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. ​ The only field that uniquely identifies each employee in the database is the Employee ID field. The Employee ID field is the _____.

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

After you create or open a database, the Navigation Pane appears along the right side of the Access window. ​

A field that appears in more than one table is called a _________. ​ A)field error B)field value C)unique field D)common field

In the accompanying figure, the color next to Box 2 indicates the _____. ​ ​

In the accompanying image of Microsoft Access 2016, Box 2 indicates the _____. ​ ​

You cannot choose which field to use as the primary key in Design view. ​

In Microsoft Access 2016, the _____ data type is used for the primary key in any table. ​

Which of the following is true of a database created in Microsoft Access 2016? ​

In Microsoft Access 2016, _________ refers to the field name as it will appear in database objects, such as in the table in Datasheet view. ​ A)Default Value B)Description C)Format D)Caption

Identify a true statement about reports in Microsoft Access 2016. ​

In the accompanying figure of a Microsoft Access 2016 document, which of the following boxes is pointing to the icon for reports? ​

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

_____ is the Microsoft Access view that shows the underlying structure of a database object and allows you to modify that structure. ​

In Microsoft Access 2016, the _________ property describes how a value is displayed. ​ A)Caption B)Format C)Decimal places D)Default value

Which of the following is true of the Long Integer type in Field Size property settings? ​

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

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. ​ Robert adds a new column in the database to include each employee's strength. The new column added by Robert to include a characteristic of each employee is an example of a _____.

In the accompanying figure of Microsoft Access 2016, Box 1 indicates the _____. ​ ​

_________ is the Access view that shows exactly how a report will look when printed. ​ A)Page Setup B)Print Preview C)Print Settings D)Page Layout