Access Ch 1 qz

Modify the width of the CourseDescription column to best fit the data.

In the Access Table, you clicked on CourseDescription, right-clicked the CourseDescription column header. In the Right Click Menu menu, you clicked the Field Width menu item. Inside the Column Width dialog, you clicked the Best Fit button.

Use Filter by Selection to filter the table to show only records where the student's DOB is 10/25/1998 or later.

In the Access Table, you clicked on DOB. In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Access Table, you clicked on DOB, clicked in the 10/25/1998 Cell, clicked the arrow at the top of the DOB column, and clicked in the 10/25/1998Cell. In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button. In the Selection menu, you clicked the On or After "10/25/1998" menu item

From the current view, add a new Short Text field to the far right side of the table. Name the field: Description

In the Access Table, you clicked the Click To Add Field Heading. You right-clicked the undefinedObject. In the Drop-Down Menu menu, you clicked the Short Text menu item. In the Access Table, you typed Description and pressed Enter.

Create a filter using the Custom Filter dialog to show only records where the value in the CourseDescription field contains the word Foundation.

In the Access Table, you clicked the arrow at the top of the CourseDescription column, right-clicked the CourseDescription column header, clicked in the Information Technology and Productivity Tools Cell, clicked on CourseDescription, and clicked the arrow at the top of the CourseDescriptioncolumn. You right-clicked the undefined Object, right-clicked the undefined Object. In the Table Column Filter Right-Click menu in the Text Filters menu, you clicked the Contains... menu item. Inside the Custom Filter dialog, you typed Foundation in the CourseDescription contains input, clicked the OK button.

Sort the records in this table so they are grouped by the value in the Classification field from A to Z and then grouped within each classification by the value in the DOB field from newest to oldest. Don't forget that when sorting by multiple fields, start with the innermost sort and work your way out.

In the Access Table, you clicked the arrow at the top of the DOB column. You clicked the Table Column Filter Right-Click menu. In the Access Table, you clicked the arrow at the top of the DOBcolumn. In the Table Column Filter Right-Click menu, you clicked the Sort Z to A menu item. In the Access Table, you clicked the arrow at the top of the Classification column. In the Table Column Filter Right-Click menu, you clicked the Sort A to Z menu item.

Use AutoFilter to filter the query results to show only records where the value in the Department field is Accounting or Finance.

In the Access Table, you clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the (Select All) checkbox, clicked the Accounting checkbox, clicked the Finance checkbox, and clicked the OK button

Add the Status Quick Start fields to the right of the DegreeName field.

In the Fields Ribbon Tab in the Add & Delete Ribbon Group, you clicked the More Fields button. In the More Fields menu, you clicked the Status menu item.

Use the Find and Replace dialog to find the record with the text julie, matching the case exactly.

In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. Inside the Find and Replace dialog, you checked the Match Case check box, typed julie in the Find What input, and clicked the Find Next button.

Replace all instances of the first name julie with Julie. Be sure to match the case exactly.

In the Home Ribbon Tab in the Find Ribbon Group, you clicked the Find button. You clicked the Replace tab. Inside the Find and Replace dialog, you checked the Match Case check box, typed juliein the Find What input, typed Julie in the Replace With input, and clicked the Replace All button. Inside the Appointments dialog, you clicked the Yes button.

Use AutoFilter to filter the query results first to show only records where value in the Department field is Economics and the value in the Credits field is 4.

In the Home Ribbon Tab in the Sort & Filter Ribbon Group, you clicked the Selection button, clicked the Advanced button. In the Access Table, you clicked the arrow at the top of the Credits column. In the Table Column Filter Right-Click menu, you clicked the 3 checkbox, clicked the OK button. In the Access Table, you clicked the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, you clicked the English checkbox, clicked the OK button.

Enable active content in this database.

You clicked the Enable Content button.

Add a new record to the table with the student ID 6412 and advance to the second field.

You clicked the New Record Button. In the Access Table, you typed 6412, typed 6412 and pressed Enter.

Go to the next record.

You clicked the Next Record Button.

Create a backup of the database. You do not need to change the backup location.

You opened the backstage view, clicked the Save As navigation button, clicked the Back Up Database button, and clicked the Save As button. Inside the Save As dialog, you clicked the Savebutton.