Exam 4: Access: Querying a Database

When tables are joined in a query, it is not possible to restrict retrieval by using criteria.

In the accompanying figure, the criterion for Current Due is 0.The query results for this query will display ____ in the Current Due field.

To export data from a query to Excel, select the query in the Navigation Pane, click _____ on the Ribbon, and then click the Excel button.

If the Client Number field in a record always should display the two characters in the client number in uppercase, then the correct format for this field is ____.

To add a record using the form shown in the accompanying figure, click the ____ button on the Navigation bar.

Camashaly has just realized that they need to make some additional changes to the Client table shown in Design view in the accompanying figure.They have asked you to make these changes. Because Camashaly may upsize the database to SQL Server, they have decided to delete the Services Needed field.How do you delete the field?

In the Camashaly Design database, a one-to-many relationship exists between the Business Analyst table and the Client table.

To use Filter By Form to filter records, click the ____ button on the Home tab and then click Filter By Form.

To remove a total row that appears in a datasheet, click the ____ button on the Home tab.

To create a crosstab, click the ____ button on the Create tab.

You can export to Excel but you cannot export data to a text file.

The field or fields on which records are sorted is called the sort key.

To include calculated fields in queries, enter a name for the calculated field, a(n)_____, and then the expression in one of the columns in the Field row.

To open a form in Form view from the Navigation Pane, right-click the form and click Form View on the shortcut menu.

To sort records by amount paid within business analyst number, specify Business Analyst Number as the ____________________ key.

When an update query is created, a(n)_________________________ row displays in the design grid.

When a filter is in effect, you can redisplay all records by clicking the ____ button on the Home tab.

The ____________________ wildcard represents any individual character.

To open the Relationships window in the accompanying figure, click the _________________________ button on the Database Tools tab.