Exam 17: Creating a Database

You can add a new field to a table at any time. ​

Explain the Simple Query Wizard in Microsoft Access 2016. ​

In Microsoft Access 2016, _________ refers to the maximum storage size for Short Text, Long Text, Number, and AutoNumber fields. ​ A)Field Size B)Field capacity C)Field value D)Field type

In the accompanying figure of Microsoft Excel 2016, the color next to Box 1 indicates the _____. ​ ​

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

In the accompanying figure of a Microsoft Access 2016 document, the symbol that Box 1 is pointing to appears when you: ​ ​

In Microsoft Access 2016, a(n) _________ is a query that shows every field of every record as defined by the query criteria. ​ A)Simple Query Wizard B)detail query C)primary key D)foreign key

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 retrieve the names of the students who have consistently obtained B grade and above. She requests information from the database for the details of all the students that satisfy this criteria. The information requested by Alisha is an example of a _____.

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

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

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 creates a report based on a table she created. The current database view does not display the number of pages included in the report. To view the number of pages in the report, she should switch to _____.

The _____ Field Size property stores positive and negative numbers to precisely 15 decimal places and uses eight bytes. ​

The accompanying figure of a Microsoft Access 2016 document shows the _____ view of a report. ​ ​

The content of a field is the _________ . ​ A)field value B)field description C)field error D)common field

When you delete a field, you do not delete the values for that field from the table.

To enter records in a table datasheet, you type the field values below the column headings for the fields. ​

When working with Microsoft Access 2016, Zafar adds fields in Design view and wishes to switch to Datasheet view to enter records. He clicks the View button before saving the table design. Which of the following is a consequence of Zafar's action? ​

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

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

_________ a database rearranges the data and objects in a database to decrease its file size. ​ A)Extracting B)Compacting C)Printing D)Editing