Exam 5: Access: Maintaining a Database

Critical Thinking Questions Case 2 JSP Recruiters 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. Figure 3-4. Because JSP may upsize the database to SQL Server, they have decided to delete the Specialties Needed field. How do you delete the field?

A ____ field allows the user to select from a list of values

When you have created a filter using either Filter By Form or Advanced Filter/Sort, you can save the filter settings as a query by using the ____________________ command on the Advanced menu.

If you add a field to a table and later realize the field is in the wrong location, you can move the field. To move the field, click the ____________________ for the field and then drag the field to the new location.

To clear a filter, click the ____ button on the Home tab and then click Clear All Filters.

Figure 3-3 To add the Client and Recruiter tables to the Relationships window shown in the accompanying figure, click the Add button in the ___________________ dialog box.

Critical Thinking Questions Case 1 JSP Recruiters 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. Figure 3-4 Because most of the clients that JSP services are located in Colorado, 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?