Exam 1: Access 2019

After creating a report with the Report Wizard, you cannot add a sort to the report.

Use the Align button on the Arrange tab to align the edges of the controls.

To change the color of the bars on a chart in a form, you must work in Form Format view.

You can use a _____ to add, change, or delete table data based on conditions you specify.

_____ data is scrambled so that it is indecipherable when opened by another program.

_____ connects an Access database to data in an external file such as an Outlook folder.

In a CSV text file, a comma often separates each field value from another field value.

You can retain a history of changes to a _____ field.

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

Nina added a text box to a report to total the sales for each product type. Which Format property would be best for the new text box?

For a field that contains more than 256 characters of comments or notes, use the _____ data type.

A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.

To set a validation rule for an entire table, you _____.

What data type is most appropriate for a field named PaymentAmt?

Caitlin wants to assign the Before Update property of a form to a procedure. She clicks the Build button in the Before Update property and then clicks Expression Builder.

Tables, queries, and forms are examples of Access ____.

To delete a field from a query, drag the field out of its field list.

_____ is a standardized language that all major relational database software uses.

To add a sort to a report in Report Design view, you use the _____ button

To set the properties for an entire table, open the table's property sheet in Table Design view.