Question 1

When a table is open, the ribbon includes the ___________ contextual tab for working with individual fields and records.
A) DATA TOOLS
B) TABLE TOOLS
C) DATABASE TOOLS
D) FIELD TOOLS

Accepted Answer

When a table is open, the ribbon includes the TABLE TOOLS contextual tab for working with individual fields and records. This tab contains sub-tabs such as DESIGN, LAYOUT, and TABLE STYLE OPTIONS that provide tools for modifying the structure and appearance of the table.

Question 2

To identify the table you should give it a(n) __________ name.
A) unique and short
B) numeric
C) unique and descriptive
D) automatically generated

Accepted Answer

A unique and descriptive name helps to identify the table easily and understand the purpose of it at a glance. It also helps to avoid confusion while using the table in complex databases. A short name may not be able to describe the table properly, and a numeric or automatically generated name may be confusing and difficult to remember.

Question 3

A comma-delimited file is simply data separated by commas, and it is referred as a _____ file.
A) CDF
B) CSV
C) CSD
D) CDD

Accepted Answer

A comma-delimited file is commonly referred to as a CSV file, which stands for "Comma-Separated Values". This format is widely used for storing and exchanging data between different software systems, including spreadsheets, databases, and programming languages. The values in a CSV file are separated by commas, and each row represents a separate record or data entry.

Question 4

Referring to the figure above, which callout points to the button you can click to create simple queries quickly?
A) E
B) B
C) C
D) H

Accepted Answer

Callout B points to the button for creating simple queries quickly, labeled as "Query Wizard".

Question 5

Which of the following buttons should you click to add all fields to the query?
A) 
B) 
C) 
D)

Accepted Answer

The answer of Which of the following buttons should you...

Question 6

By default, the data type for the primary key is _________.
A) Number
B) AutoNumeric
C) AutoNumber
D) UniqueNumber

Accepted Answer

The data type for the primary key by default in Microsoft Access is AutoNumber. This is because it automatically generates a unique value for each record and is often used with tables where a natural key does not exist.

Question 7

The field that uniquely identifies records in a table is called a(n) __________.
A) secondary key
B) primary key
C) search key
D) identifier

Accepted Answer

The primary key is a field that uniquely identifies records in a table. It must have a unique value for each record and cannot be null. A secondary key is an optional field that can also be used for identification purposes, but it does not have the same constraints as a primary key. A search key is a field that is indexed for faster searching, but it does not necessarily have to be unique. An identifier is a general term for any field that is used for identification purposes, but it does not have the same specific meaning as a primary key.

Question 8

The field you use for the primary key should have a checkmark in the _______ box.
A) Required
B) Indexed
C) Validated
D) Unique

Accepted Answer

The primary key should be unique to each record and the "Unique" option ensures that there are no duplicate values. While the "Required" option can be useful for ensuring that a value is entered in the field for each record, it is not necessary for the primary key. The "Indexed" option can improve performance but is not required for the primary key. The "Validated" option is used for setting specific rules or requirements for the data entered into a field, but again, is not necessary for the primary key.

Question 9

When entering data, you can use the _____ key(s) to move from one field to the next without having to move your hand to the mouse.
A) Ctrl+Tab
B) Ctrl+Alt
C) Esc
D) Tab

Accepted Answer

The Tab key is commonly used to move the cursor to the next field in a form or document. It is often more efficient than using the mouse to click on the next field. Ctrl+Tab is also a valid option in some programs, but it is less commonly used for navigation within a form. Ctrl+Alt and Esc are not used for navigation between fields.

Question 10

To open a table that was created peviously, you have to start Access, open the database, and then _______ the table name in the Navigation Pane.
A) double-click
B) left-click
C) click
D) right-click

Accepted Answer

To open a table that was created previously, you have to double-click the table name in the Navigation Pane.

Question 11

The ________ key is used to delete text to the left of the insertion point.
A) Delete
B) Shift + Delete
C) Backspace
D) Shift + Backspace

Accepted Answer

The Backspace key is used to delete text to the left of the insertion point. The Delete key is used to delete text to the right of the insertion point. Shift + Delete is used to permanently delete a selected file without moving it to the Recycle Bin. Shift + Backspace is not a standard keyboard shortcut.

Question 12

New records are added ______________________.
A) at the beginning of the table
B) at a random location in the table
C) at the location specified by user
D) at the end of the table

Accepted Answer

New records are typically added at the end of the table in order to preserve the order of existing records and ensure that the newest records are easily accessible for analysis and reporting.

Question 13

After opening a New Query window, which of the following would you usually select?
A) Crosstab Query Wizard
B) Simple Query Wizard
C) Find Duplicates Query Wizard
D) Find Unmatched Query Wizard

Accepted Answer

The Simple Query Wizard is the best choice as it allows you to create a basic query by selecting tables and fields, without any complex criteria or calculations. The other options are specific wizards for finding duplicates, unmatched records, or creating crosstab queries, which may not be relevant for every query.

Question 14

To delete an entire record, ______ the row header containing the record, click Delete Record, then click the Yes button.
A) right-click
B) click
C) left-click
D) double-click

Accepted Answer

To delete a record, you can right-click the row header containing the record and select Delete Record from the context menu. Then click the Yes button to confirm the deletion.

Question 15

Which of the following fields is designed to be used as the primary key in an empty table?
A) AutoNumber
B) Primary Key
C) ID
D) Identifier

Accepted Answer

The answer of Which of the following fields is designed...

Question 16

All of the following are controls for operations that can be performed on a table, except __________.
A) Delete a record
B) Sort records
C) Move a record
D) Search

Accepted Answer

Moving a record is not a standard control for operations on a table. The other options, deleting a record, sorting records, and searching are all common controls for working with data in a table.

Question 17

You can modify data within a field using Backspace, Delete, and typing keys. To complete the modification you should press the _____ key.
A) Ctrl + Shift
B) Esc
C) Enter
D) Shift + Enter

Accepted Answer

Pressing the Enter key confirms and saves the modification made to the field.

Question 18

Referring to the figure above, which callout points to the tab that should be clicked first to build a query?
A) A
B) B
C) D
D) H

Accepted Answer

Callout A points to the "Create Query" tab, which should be clicked first to build a query.

Question 19

Which of the following icons should you click to save the table?
A) 
B) 
C) 
D)

Accepted Answer

Based on the given options, B is the only icon that has the traditional "save" symbol (a floppy disk). A, C, and D are not related to saving a table.

Question 20

Import options are listed on Access's ______________ tab.
A) EXTERNAL DATA
B) EXPORT DATA
C) IMPORT DATA
D) DATABASE TOOLS

Accepted Answer

The import options are listed under the "EXTERNAL DATA" tab where you can select from various sources to import data into your Access database. The other options listed (Export Data, Import Data, and Database Tools) are related to exporting and managing data within Access, but do not specifically address the task of importing data.

Quiz 10: Creating a Database

When a table is open, the ribbon includes the ___________ contextual tab for working with individual fields and records.

To identify the table you should give it a(n) __________ name.

A comma-delimited file is simply data separated by commas, and it is referred as a _____ file.

Referring to the figure above, which callout points to the button you can click to create simple queries quickly?

Which of the following buttons should you click to add all fields to the query?

By default, the data type for the primary key is _________.

The field that uniquely identifies records in a table is called a(n) __________.

The field you use for the primary key should have a checkmark in the _______ box.

When entering data, you can use the _____ key(s) to move from one field to the next without having to move your hand to the mouse.

To open a table that was created peviously, you have to start Access, open the database, and then _______ the table name in the Navigation Pane.

The ________ key is used to delete text to the left of the insertion point.

New records are added ______________________.

After opening a New Query window, which of the following would you usually select?

To delete an entire record, ______ the row header containing the record, click Delete Record, then click the Yes button.

Which of the following fields is designed to be used as the primary key in an empty table?

All of the following are controls for operations that can be performed on a table, except __________.

You can modify data within a field using Backspace, Delete, and typing keys. To complete the modification you should press the _____ key.

Referring to the figure above, which callout points to the tab that should be clicked first to build a query?

Which of the following icons should you click to save the table?

Import options are listed on Access's ______________ tab.