ACCESS EXAM 3 QUESTIONS & UPDATED CORRECT ANSWERS

ACCESS EXAM 3 QUESTIONS &
UPDATED CORRECT ANSWERS
To avoid the chance of data being lost or corrupted, you should ________ your
database.

---index

---compact

---backup

---restore - Correct Answer ✔✔ ---backup

You can use the Compact and Repair Database button on the Database Tools tab to
reduce the size of the database.

--- True

---False - Correct Answer ✔✔ --- True

You can select up to ________ fields for row headings in a crosstab query.

---3

---4

---5

---6 - Correct Answer ✔✔ ---3

When creating a calculated field, the new field name must be followed by a colon and
each field name that will be used in the expression must be enclosed within in its own
pair of:

---quotation marks (")

---brackets ([])

---asterisks (*)

---pound signs (#) - Correct Answer ✔✔ ---brackets ([])

, The only way to create a Crosstab query is to use the Crosstab Query Wizard.

---True

---False - Correct Answer ✔✔ ---False

When creating a calculated field, all values in the expression must come from an
existing table field.

---True

---False - Correct Answer ✔✔ ---False

Which of the following is NOT a valid expression in Access?

--- Average:[Total/Count]

--- Cost:[Price]+[Tax]

--- Average:[Total]/[Count]

--- Required:[Bits]^2 - Correct Answer ✔✔ --- Average:[Total/Count]

When using the Form Wizard, you can select fields from tables and _____ in the
database.

--- other forms

--- reports

--- themes

---queries - Correct Answer ✔✔ ---queries

In Form view, how can you navigate to the previous record in the form?

--- Click the Back button on the Home tab.

--- Click the left arrow button on the left side of the form.

--- Click the Previous record button on the navigation bar.

--- Click the Previous button in the status bar. - Correct Answer ✔✔ --- Click the
Previous record button on the navigation bar.