Exam 4: Access: Querying a Database

The accompanying figure shows a join of the Business Analyst and Client tables.____________________ properties are the properties that indicate which records appear in a join.

To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the ____ button to create a new query.

Four types of filters are available in Access: Filter By Selection, Common Filters, Filter By Form, and Advanced Filter/Sort.

You cannot create a form for a query.

To search for a specific record click the _____ button on the Home tab shown in the accompanying figure to display the Find and Replace dialog box.

The simplest type of filter is called Filter By Form.

Camashaly Design has decided to add some additional validation rules to the Client table shown in Design view in the accompanying figure.They have asked you to create these validation rules. Because the majority of clients that Camashaly Design services are located in North Carolina, management would like to minimize any data entry in this field.What property do you need to change and what would you enter in the property box?

Explain what happens if you upsize a database containing multivalued fields to SQL Server.

When the Business Analyst table is related to the Client table, it is possible to view the clients of a given analyst when you are viewing the datasheet for the Business Analyst table.The clients for the analyst will appear below the analyst in a split form .

To add a new record using Form view, click the New (blank)record button on the Navigation bar.

To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted, and then press the DELETE key.

To find duplicate records in a table, use the _____ Query Wizard.

Camashaly needs to gather some additional statistics on its clients.An employee at Camashaly has created an initial query as shown in the accompanying figure that calculates the average amount paid.The employee is unsure what aggregate functions to use for additional calculations. Which aggregate function will count the number of records?

To use the Expression Builder to create a calculated field, select the column in the Field row, right-click to display the shortcut menu, and then click ____.

To create a validation rule for the State field to restrict entries to TN or TX, enter ____ in the Validation Rule property box.

To display the Total row in a datasheet, click the Sum button on the Ribbon.

To use a common filter with a field whose data type is Text, click the arrow to the right of the field name and point to the _____ command to display the common text filters.

To create an update query, create a new query and then click the ____ button on the Design tab.