Advertisement Upgrade to remove ads

A new calculated field uses the formatting of the field(s) used in the expression.

False

Which of the following is possible if referential integrity is enforced within a one-to-many relationship?

Deleting a record from the many table if there is a related record in the one table

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

[Cost]*0.20

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

Department would be to the left of Lastname in the query design grid.

The field on the one side of a one-to-many relationship is typically the primary key in that table.

True

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

create a select query on which to base the crosstab query.

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

Ready

Text criteria in a query are not case sensitive.

True

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

sort Lastname as the outermost field in ascending order.

In a query design, the Totals button can also be used to group (summarize) nonnumeric data.

True

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

sort ONLY the Last Name field, thus mixing up the records.

To create a copy of a database, Access 2010 requires you to use a closed database file rather than Save As.

False

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

>=300.

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?

Between 8/2/2015 and 8/8/2015

The Zoom dialog box allows more working space into which to type a calculation.

True

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

LOWEST

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

Discount: [Price]*0.20

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

enter >400 on both the Criteria and OR rows in the field for the scholarship amount.

Placing criteria for two different fields on the Criteria row creates an AND condition.

True

Queries are most often created as a basis for a report, but query results can be printed like any other table of data.

True

Which of the following is NOT true regarding security alerts?

They can be resolved permanently by most college users in the Trust Center.

If the field list is too small in the Relationships window, double-click the title bar to automatically resize the list.

False

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

Only the sort order specified in Datasheet view is saved with the query design.

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

A complex select query should be created using the Query Wizard.

Relationships are established based on key fields.

True

Sort order for a query is saved with the query design, whether the sort was specified in the design grid or in Datasheet view.

False

Every field included in the query design grid must appear in the query result.

False

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

Trust Center

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

Is Null

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

It saves time if your new query uses the same fields as the existing query.

Sorting a table in Ascending order on the State field would result in Alaska displaying before California.

True

A crosstab query summarizes a large amount of data into a small, easy-to-read space.

True

When referential integrity is enforced, small symbols indicate which is the one table and which is the many table within the relationship.

True

The address 123 Main Street would NOT display using the criteria

?? Main St??

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?

R?d

In Query Design view, the Show Table command is used to add tables to the design grid.

True

Access will automatically add quotes around a dollar amount used as a criteria.

False

In addition to a one-to-many relationship, tables can also have a one-to-one relationship.

True

Sort order in Datasheet view overrides the sort order in Design view.

True

When sorting a table in Datasheet view, Access allows only one sort field per table.

False

When creating an OR condition for the values in a single field, you must enter the word OR in the criteria row.

False

In query criteria, when searching for a single unknown character, use the ? character.

True

In a query, you should not enter dollar signs in the query criteria.

True

The table or tables from which a query selects its data are referred to as the data source.

True

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

the same field name.

Because fields are only added to the right of the design grid, to add a field between existing fields requires you to clear the grid and start over.

False

You can sort query results only in Design view.

False

When you are searching for a numbered street address on Maple, but aren't sure whether it's Maple Avenue, Maple Street, or Maple Way, which of the following criteria would you use?

Maple

When printing tables, Access automatically includes the table name in the footer of the printout.

False

The advantage of using calculated fields in a query is the need for fewer fields in the database and increased flexibility.

True

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set