Access Ch. 1-5 Key Terms Matching

Which of the following is an example of an Access object?

Where is data in a database stored?

You edit several records in an Access table. When should you execute the Save command?

Which of the following is not true of an Access database?

Which of the following is true regarding table views?

Which of the following utilities is used to recover in the event of loss or damage?

Which of the following would be matched if you use a Selection filter's exact match option for the name Ann?

Which of the following conditions is available through a Selection filter?

All of the following statements are true about creating a database except:

To add a predefined table to an existing database, you should use which of the following?

A filtering method that displays only records that match selected criteria.

A filtering method that displays records based on multiple criteria.

A main component that is created and used to make a database function, such as a table or form

A method of listing records in a specific sequence (such as alphabetically).

A predefined database that includes professionally designed tables, forms, reports, and other objects.

A question you ask about the data in your database.

An Access interface element that organizes and lists database objects in a database

An Access object that simplifies entering, modifying, and deleting table data.

A set of common Access components that can be added to an existing database.

An object that contains professional-looking formatted information from underlying tables or queries.

An object used to store data, organizing data into columns and rows

Complete set of all the fields about one person, place, event, or concept

A collection of data organized as meaningful information that can be accessed, managed, stored, queried, sorted, and reported.

All of the following are suggested guidelines for table design except:

Which of the following determines how the field names can be made more readable in table and query datasheets?

When entering, deleting, or editing input masks:

With respect to importing data into Access, which of the following statements is true?

The main reason to set a field size in Access is to:

An illustration of a one-to-many relationship would be:

A query's specifications as to which tables to include must be entered on the:

When adding date criteria to the Query Design view, the dates you enter must be delimited by:

It is more efficient to make a copy of an existing query rather than to create a new query when which of the following is true?

Which of the following is true for the Query Wizard?

Which of the following cannot be used in a calculated field?

When creating a calculation, which of the following would be identified as an error by Access?

What is the result of the following expression? 2 * 5 + 8 − 6 / 2

Which of the following cannot be adjusted in the Property Sheet?

Which of the following could not be done using an aggregate function?

Which of the following can be added to a totals query?

Which statement about a totals query is true?

Which of the following statements is true?

If you want to calculate aggregate statistics about graduation rates for students in a college database, which of the following would provide the least useful information if you were to group by it?

Which of the following about the Total row in Query design is false?

A report can be made from one or more tables or a query. The object(s) that a report is based on is known as the:

Which of the following statements is false?

In order to summarize data in a report and override the sort order of the record source you would use:

The simplest view you can use to modify control widths in a form is:

Which of the following views provides you with the most flexibility in modifying forms and reports?

Which of the following statements about reports is false?

Which of the following statements is false?

Which of the following is not a data validation technique?

Which of the following fields is least likely to be set to required?

Which of the following enables users to choose from a list of options while entering data?

The string of characters !(999") "000-0000;0;_ represents which of the following?

A parameter query enables you to:

When would you use the Date function?

Which of the following statements about the Round function is false?

Which of the following statements is false?

Which of the following is not a valid condition for an IIf function?

Which of the following cannot be extracted by the DatePart function?

Which one of the following tasks cannot be completed with an action query?

Which statement is true about update queries?

Which type of query would you run as a method of previewing the results of the other three?

In a large products table that you have acquired from an external source, you find that there are repeating product IDs. You need to set ProductID as the primary key field in this table. What is the best way to resolve this problem?

Why is it important to monitor how many times an update query is executed?

When is it generally useful to run a delete query?

Why would you use an append query?

What is the easiest way to create a crosstab query?

What is an unmatched record?

What is the best way to find students who have not handed in a certain assignment?