Access Questions and Answers

A database object that retrieves specific data from one or more tables is a

A flat database

A query is a database object that

An Access record is saved when you

Before populating a table, which is the correct sequence of steps?

Each table row contains all the categories of data pertaining to one entity and is called a

Good database design does NOT include

Headers and footers for Microsoft Access tables and queries

In Microsoft Access, all data is stored in one or more

One purpose of a form is to

One purpose of a report is to

Raw data that has been organized so as to become useful is also known as

The Access view that displays the table data in columns and rows is called

The Caption property

The advantage of using a template when starting a new database is that

The most common database objects are

The process of creating a query involves

The table Design view shows

To create a query using the Simple Query Wizard, you choose the data source and

To organize your database objects you must use the

To rename a table, you can

To view a table in Design view:

When creating a new table, Access does NOT

When data in a table becomes redundant,

When importing data from an Excel workbook, you may NOT

If you accidentally place two copies of the same table list in the Relationships window, which is the correct method for removing the extra table?

If you want the records in a table to be sorted by last name and then by first name within each last name, you would need to

In a query, to sort Z to A by Department (outermost), then A to Z by Lastname (innermost),

Regarding the sorting of query results, which of the following is FALSE?

Sorting a table in descending order by a Last Name field would NOT

The address 123 Main Street would NOT display using the criteria

To create a crosstab query based on two tables, you must

To find a contribution amount of $300 or greater, the entry in the Amount field's criteria should be

To locate records in which a field is left blank, what should be used as the criteria for that field?

When Baseball is placed on the Criteria row of the Sport field and Football is placed on the OR row for the same field, the only way to specify scholarship amounts greater than $400 for both sports is to

When establishing a relationship, common fields do NOT necessarily need to have

When looking for a date during the week beginning 8/2/2015 and ending 8/8/2015, which of the following would be the correct criteria?

When searching for "Red" or "Rad" or "Rid" or "Rod", but NOT "Rodney" or "Reed" or "Ron", which of the following criteria should be used?

Where can you view the security and privacy settings for Access?

Which is the correct expression for calculating 20 percent of the existing field Cost?

Which is the primary advantage of creating a new query based on an existing query?

Which of the following expressions would correctly add a calculated field named Discount that is 20 percent of the Price field?

Which of the following is NOT a function that can be used with the Totals button?

Which of the following is NOT a true statement regarding a select query?

Which of the following is NOT true regarding security alerts?

Which of the following would NOT be displayed for a criteria of R*d?

A theme

Access forms can

Compared to Filter by Form, Filter by Selection

Compared to the Form tool, the Form Wizard

Form Layout view differs from Design view in that

In Layout view, if the width of controls is insufficient to display all of the data, the field has been

In Layout view, the ________ is a small symbol displayed in the upper left corner used to move the entire group of controls.

Organizing and summarizing data in a report can be accomplished by

Resizing sections in a form must be done in

The OR condition

The Report Wizard

The advantage of resizing controls in Layout view rather than in Design view is

To print just one record from a form, which of the following would you choose in the Print dialog box?

To view report data while making changes to a report, use

Using a form for data entry can increase the usefulness of a database by increasing

Using the"keep whole group together on one page" command ensures

When a field is too narrow to display numeric information, the data displays as

When a filter is active, which of the following is NOT true?

When viewing a report in Design view, which of the following is NOT a section name?

When you delete records in Access,

Which is NOT true concerning forms?

Which of the following can display records based on values in one or more fields?

Which of the following displays only records that contain the value in the selected field?

Which of the following is NOT true regarding a report?

Which of the following would NOT be considered a design modification of a report?