Query & Report in MSA

When you open an existing query in MS Access, it is displayed in Datasheet view.

• TRUE

• FALSE

A sort that includes more than one sorted field is called a multilevel sort.

• TRUE

• FALSE

Reports give you the ability to present components of your database in uneasy-to-read, non-printable format.

• TRUE

• FALSE

The Report Wizard is a tool that guides you through the process of creating complex reports.

• TRUE

• FALSE

When you are satisfied with your query design, select the Create Query command on

the Query Tools Design tab to run the query.

• TRUE

• FALSE

Report command is a quick way to create reports from the current object.

• TRUE

• FALSE

Access offers options to save your report as an Excel file, text file, PDF, and HTML document.

• TRUE

• FALSE

To sort your report data, you can click the top drop-down arrow, then select the name of the first field you

want to sort.

• TRUE

• FALSE

You can use the Publish command to create a query.

• TRUE

• FALSE

You can sort records in ascending or descending order.

• TRUE

• FALSE