Question 1

Which one of the following is not a component of the Query Design view?
A) table pane
B) field list(s)
C) navigation bar
D) design grid

Accepted Answer

The navigation bar is not a component of the Query Design view. The table pane displays a list of tables or queries that can be used in the query, the field list(s) show the fields available in each table or query, and the design grid is where you design the query by selecting fields, specifying criteria, and selecting sorting and grouping options.

Question 2

Which one of the following is not a data type?
A) Text
B) Currency
C) Date/Time
D) HTML

Accepted Answer

HTML (Hypertext Markup Language) is not a data type. It is a markup language used to structure content on the internet. The other options, text, currency, and date/time are all common data types used in database management systems.

Question 3

To see the results of a query,
A) click the Close button
B) click the Run button
C) you must sort or filter the query first
D) you must save the query first

Accepted Answer

Clicking the Run button will execute the query and show the results. The Close button will simply close the query window without showing any results. Sorting or filtering the query is optional and saving the query is not required to view the results.

Question 4

To view all items of inventory that have a quantity on hand of less than or equal to 1,200, you would enter <=1,200 in the criteria line.

Accepted Answer

The answer of To view all items of inventory that...

Question 5

Referential integrity is used to ensure that relationships in tables are valid.

Accepted Answer

Referential integrity is a database concept that ensures that relationships between tables remain synchronized and valid. It is used to enforce business rules or logical rules created by developers that relate to the relationships between records in different tables. When referential integrity is applied, any changes made to records in one table are validated against related records to ensure that the relationships between tables remain consistent.

Question 6

A category of information, such as last names or telephone numbers, is called a
A) field
B) record
C) form
D) query

Accepted Answer

A category of information is typically referred to as a field in databases. Records refer to a group of fields that relate to a single entity, a form is a user interface for entering or displaying data, and a query is a request for specific information from a database.

Question 7

The results of a filter performed in a query will be saved when the query is saved.

Accepted Answer

The results of a filter are not saved with the query; only the query definition, including the filter criteria, is saved.

Question 8

The Label Wizard displays a prototype label where symbols, such as commas, can be inserted.

Accepted Answer

The Label Wizard allows users to design and create labels. It provides options for selecting fonts, colors, and text alignment. It also allows for the placement of symbols such as commas, periods, and hyphens to help organize and format the content on the label.

Question 9

You can switch between Design view and Datasheet view by clicking the
A) Queries object tab
B) Switch command on the View menu
C) View button and then clicking a view option
D) Run button

Accepted Answer

The View button allows you to switch between different views, such as Design view and Datasheet view, by selecting the desired option.

Question 10

A complete set of fields containing information about an item, such as a person or item of inventory, is called a record.

Accepted Answer

This statement is true. A record is a collection of fields that contain information about a particular item, such as a person or an item of inventory. Each field within a record holds a specific piece of information, and together, they create a complete picture of the item.

Question 11

The report Design view gives you the most control over the layout of labels and text boxes.

Accepted Answer

The Design view allows you to modify and customize the layout of labels and text boxes in a report, giving you more control over their appearance and position on the page.

Question 12

Suppose you are using a form to edit customer data. If you accidentally delete a record, click the Undo button to restore the record.

Accepted Answer

The ability to undo a deletion in a form depends on the specific software or application being used. Many applications do not have an "Undo" button for record deletions, requiring instead that you restore the record from a backup or through other means.

Question 13

Which one of the following symbols in an input mask requires the input of only a single alphabetic character?
A) #
B) L
C) A
D) *

Accepted Answer

In an input mask, "L" symbol requires the input of only a single alphabetic character.

The "#" symbol represents a single digit, while the "A" symbol represents a single alpha-numeric character. The "*" symbol can represent multiple characters of any type. Therefore, the best choice for requiring a single alphabetic character would be the "L" symbol.

Question 14

The default field size for a text field type is
A) 2
B) 25
C) 50
D) 255

Accepted Answer

The default field size for a text field type is 255. This is the maximum number of characters that can be stored in a single text field. Therefore, choosing D as the best choice ensures that there will be enough space to store the maximum amount of data.

Question 15

A relationship
A) is a way to print tables
B) is a combination of two tables
C) links identical fields between two tables
D) links queries between two files

Accepted Answer

A relationship is a link between identical fields between two tables in a database. This link is used to ensure data accuracy and consistency when performing queries and updates across tables.

Question 16

You can enter, edit, and delete data in the Layout view of a form.

Accepted Answer

In the Layout view of a form, you can modify the design and layout of the form, but you cannot enter, edit, or delete data. Data entry and editing are typically done in Form view.

Question 17

When creating a table, you must enter a field name, data type, and description.

Accepted Answer

When creating a table, entering a field name and data type is mandatory, but entering a description is optional.

Question 18

Which one of the following field properties would be least useful for a ZIP Code field?
A) format
B) input mask
C) default value
D) required value

Accepted Answer

The answer of Which one of the following field properties...

Question 19

The Datasheet view of a table is the preferred format for printing data in a table.

Accepted Answer

The Datasheet view is not ideal for printing. It is designed for data entry and editing. The Layout view or Report view are better options for printing data in a table.

Question 20

A primary key
A) is required for every field
B) is the default value of a field
C) uniquely defines a record
D) is required in all forms

Accepted Answer

A primary key uniquely identifies a record in a database table. It is not required for every field or in all forms, and it is not the default value of a field.

Quiz 6: Databases With Access

Which one of the following is not a component of the Query Design view?

Which one of the following is not a data type?

To see the results of a query,

To view all items of inventory that have a quantity on hand of less than or equal to 1,200, you would enter <=1,200 in the criteria line.

Referential integrity is used to ensure that relationships in tables are valid.

A category of information, such as last names or telephone numbers, is called a

The results of a filter performed in a query will be saved when the query is saved.

The Label Wizard displays a prototype label where symbols, such as commas, can be inserted.

You can switch between Design view and Datasheet view by clicking the

A complete set of fields containing information about an item, such as a person or item of inventory, is called a record.

The report Design view gives you the most control over the layout of labels and text boxes.

Suppose you are using a form to edit customer data. If you accidentally delete a record, click the Undo button to restore the record.

Which one of the following symbols in an input mask requires the input of only a single alphabetic character?

The default field size for a text field type is

A relationship

You can enter, edit, and delete data in the Layout view of a form.

When creating a table, you must enter a field name, data type, and description.

Which one of the following field properties would be least useful for a ZIP Code field?

The Datasheet view of a table is the preferred format for printing data in a table.

A primary key