Templates, Advanced Relationships, And Macros

This question bank verified by Studydeets
All Questions
Filter by:
Question 1
Free
True/False

An action query makes a temporary change to the data in the database and the Undo button is available to reverse the action.

Choose correct answer/s

True

False

Check answer
Question 2
Free
True/False

Action queries do not display confirmation messages after the action is complete.

Choose correct answer/s

True

False

Check answer
Question 3
Free
True/False

It is a good practice to make a backup copy of your database before you run any action query.

Choose correct answer/s

True

False

Check answer
Question 4
Free
True/False

While you could modify each record individually in a table,an update query allows you to make the change to all records using one command.

Choose correct answer/s

True

False

Check answer
Question 5
Free
True/False

In an update query,unlike the Criteria row,the Update To row is not case sensitive.

Choose correct answer/s

True

False

Check answer
Question 6
True/False

A delete query deletes the entire record.

Choose correct answer/s
True
False
To unlock the question
Question 7
True/False

Unlike the resulting datasheet from a regular select query,you can edit the results from a crosstab query.

Choose correct answer/s
True
False
To unlock the question
Question 8
True/False

After you create a crosstab query with the Crosstab Query Wizard,you can edit it in Design view and make changes to any of the selections made during the wizard.

Choose correct answer/s
True
False
To unlock the question
Question 9
True/False

If duplicate records are present,two or more records in a table share the same values.

Choose correct answer/s
True
False
To unlock the question
Question 10
True/False

Unmatched records are records in one table that do not contain any matching records in a related table.

Choose correct answer/s
True
False
To unlock the question
Question 11
True/False

The Top Values query property limits the number of records that display in a query answer.

Choose correct answer/s
True
False
To unlock the question
Question 12
True/False

The serial number is designated by the number of days the date is from January 1,2000.

Choose correct answer/s
True
False
To unlock the question
Question 13
True/False

The Now()function retrieves the current date,including the time,from your computer.

Choose correct answer/s
True
False
To unlock the question
Question 14
True/False

When you are viewing a report in Layout or Print Preview view,the sections are not as obvious as they are in Design view.

Choose correct answer/s
True
False
To unlock the question
Question 15
True/False

Creating a report in Layout view provides you with the most flexibility.

Choose correct answer/s
True
False
To unlock the question
Question 16
True/False

An embedded query updates as you add and remove fields from the report.

Choose correct answer/s
True
False
To unlock the question
Question 17
True/False

A parameter report asks the user to enter the specific criteria value for a field when the report is run.

Choose correct answer/s
True
False
To unlock the question
Question 18
True/False

To change the size of a control on a report,simply select the control and use the sizing handles to adjust the size.

Choose correct answer/s
True
False
To unlock the question
Question 19
True/False

If you want to perform the same modification on several controls,select them all before performing the change.

Choose correct answer/s
True
False
To unlock the question
Question 20
True/False

A calculated control contains an expression in the Control Source property.

Choose correct answer/s
True
False
To unlock the question