Deck 17: Creating a Database

Question 1

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

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

Answer 1

A

Question 2

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

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

Answer 2

B

Question 3

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

Answer 3

False

Question 4

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

Question 5

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

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

Question 7

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

A)Each row in a table is a field.
B)A table can have many primary keys.
C)Each column in a table is a record.
D)A table can have many foreign keys.

Question 8

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

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 9

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

Question 10

Access databases can contain thousands of records. ​

Question 11

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

Question 12

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

Question 13

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

Question 14

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

A)Short Text
B)Hyperlink
C)AutoNumber
D)Long Text

Question 15

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

Question 16

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

A)The Navigation Pane is the main control center for opening and working with database objects.
B)After a database is opened, the Navigation Pane appears along the right side of the window.
C)Any open table, report, or other object appears in the left pane.
D)Only one database object can be opened at a time.

Question 17

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

Question 18

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

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

Question 19

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

Question 20

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

Question 21

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

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

Question 22

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

A)It stores whole numbers from −2,147,483,648 to 2,147,483,647 in four bytes.
B)It stores whole numbers from -32,768 to 32,767 in two bytes.
C)It stores positive and negative numbers to precisely seven decimal places and uses four bytes.
D)It stores positive and negative numbers to precisely 15 decimal places and uses eight bytes.

Question 23

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

A)Integer
B)Double
C)Single
D)Decimal

Question 24

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

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 25

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

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

Question 26

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

A)Datasheet View button
B)Layout View button
C)SQL View button
D)Design View button

Question 27

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

A)select the primary key value.
B)delete a record.
C)start typing a value in a field.
D)modify the foreign key value.

Question 28

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

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 29

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

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

Question 30

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

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 31

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

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

Question 32

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

A)Box A
B)Box B
C)Box C
D)Box D

Question 33

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

A)The three tables in the database
B)The three records created
C)The three fields created
D)The three queries in the database

Question 34

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

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

Question 35

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

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

Question 36

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

A)Box A
B)Box B
C)Box C
D)Box D

Question 37

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

A)Design view
B)Draft view
C)Layout view
D)Outline view

Question 38

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

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 39

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

A)Add & Delete group
B)Macros & Code group
C)Sort & Filter group
D)Import & Link group

Question 40

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? ​

A)The table is automatically saved and Datasheet view is opened.
B)The error value "#VALUE" is displayed.
C)Microsoft Access switches to Datasheet view and the fields are lost.
D)Microsoft Access reminds him to save the table.

Question 41

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

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

Question 42

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

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

Question 43

Which of the following best defines the term wizard? ​

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 44

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

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

Question 45

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

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 46

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

A)Layout view does not show how many pages are included.
B)You cannot resize columns in Layout view.
C)You cannot display reports in Layout view.
D)Layout view does not contain a page number field.

Question 47

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

A)disk storage after compacting
B)database before compacting
C)random access memory control signal
D)read-only memory program signal

Question 48

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

A)A report in the Navigation Pane
B)A form in the Navigation Pane
C) A query in the Navigation Pane
D)A table in the Navigation Pane

Question 49

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

A)random access memory control signal
B)read-only memory program signal
C)active database element
D)deleted database element

Question 50

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

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 51

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

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

Question 52

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

A)Layout view
B)Design view
C)Datasheet view
D)SQL view

Question 53

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

A)record
B)query
C)form
D)hash

Question 54

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

A)Outline Preview
B) Design view ​
C)Print Preview
D)Layout view

Question 55

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

A)database after compacting
B)disk storage before compacting
C)random access memory control signal
D)read-only memory program signal

Question 56

The content of a field is the _________ . ​

A)field value
B)field description
C)field error
D)common field

Question 57

A database that contains a collection of associated tables is called a _________. ​

A)graph database
B)relational database
C)parallel database
D)online database

Question 58

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

A)field
B)form
C)record
D)query

Question 59

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

A)It has a graphic of the report in the upper-right corner.
B)It defines the page area to be printed by solid lines.
C) It shows field values for each record in a row. ​
D)It has a less visually appealing format than a datasheet.

Question 60

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

A)random access memory control signal
B)read-only memory program signal
C)active or open database element
D)deleted or replaced database element

Question 61

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

Question 62

In Microsoft Access 2016, _________ refers to the value automatically entered in a field. ​

A)Description
B)Decimal Places
C)Default Value
D)Caption

Question 63

In Microsoft Access 2016, the _________ property describes how a value is displayed. ​

A)Caption
B)Format
C)Decimal places
D)Default value

Question 64

A field that appears in more than one table is called a _________. ​

A)field error
B)field value
C)unique field
D)common field

Question 65

How is a report formatted in Microsoft Access 2016? ​

Question 66

_________ 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

Question 67

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

Question 68

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

Question 69

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

Question 70

_________ a database rearranges the data and objects in a database to decrease its file size. ​

A)Extracting
B)Compacting
C)Printing
D)Editing

Question 71

Explain the Simple Query Wizard in Microsoft Access 2016. ​

Question 72

_________ 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

Question 73

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

Question 74

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