Why is it important to compact and repair a database?a. To enhance securityb. To reduce fragmentation and optimize performancec. To update database relationshipsd. To enable multi-user access  

Database objects like tables can be saved in formats like PDF or XPS.

A database encrypted with a password must be reopened in exclusive mode to remove the password.

What does the Filter by Form option allow you to do?a. Apply multiple criteria using Look for and Or tabsb.  Display only the most recently added recordsc. Save filtered records to a new tabled. Encrypt the filtered records  

To insert a calculation in a form, which property must you set in the Property Sheet task pane?a. Default Valueb. Conditional Formattingc. Control Sourced. Field Size  

When applying filters in a table, records that don’t meet the criteria are permanently deleted.

Control objects in a form can be resized, moved, or deleted in Layout view.

What button toggles between the full dataset and filtered data?a. Clear Filterb. Apply Filterc. Toggle Filterd. Sort Filter  

Control objects like text boxes and labels in a report can only be edited in Datasheet View.

The Ascending button sorts dates from earliest to latest by default.