Access Chapter 1 Simulation

Close the Navigation Pane.

Click the Nav Pan Open/Close button.

Close the Course table.

Click the Course table tab (the one at the left). Click the X at right side of the tab.

Go to record number 20.

Click the Current Record Box, type 20, and press Enter.

Enable active content in this database.

Click the Enable Content button.

Create a new blank database named Accounting.

Click File, click New, click the Blank database template, type Accounting in the File Name box, and click Create.

Create a new database from the Students template. Do not change the location. Name the database: Students.

Click File, click New, click the Students template, type Students in the File Name box, and click Create.

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

Click in Cell 33 in the Student ID column, type 6412, and press Tab.

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

Click the 10/25/1998 Cell. On the Home tab, in the Sort & Filter group, click the Selection button. In the Selection menu, click the On or After "10/25/1998" button.

Go to the last record.

Click the Last Record Button.

Go to the next record.

Click the Next Record button.

Go to the previous record.

Click the Previous Record button.

Open the Course table.

Double-click the Course table.

From the current view, rename the ID field to: DegreeName

Double-click the ID column header, type DegreeName and press Enter.

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

Double-click the border next to the CourseDescription column header.

From the current view, move the Description field so it is the last field in the table.

Drag Description after Status.

From the current view, delete the Description field.

Right-click the Description column header. Click the Delete Field button. Click Yes.

Delete this student record (StudentID 3191).

Right-click the Row Selector (that shows 3191). Click the Delete Record button. Click Yes.

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

Click the File tab. Click Save As. Click Back Up Database in the Save Database As section at the right side of the screen. Click the Save As button. Click Save.

Go to the first record.

Click the First Record button.

Change the Navigation Pane grouping option so all database objects of the same type are grouped together (all tables together, all forms together, etc.)

Click the Navigation Pane Header. In the Category/Group menu, click the Object Type button.

Change the Navigation Pane grouping option so tables and dependent database objects are grouped together.

Click the Navigation Pane Header. In the Category/Group menu, click the Tables and Related Views button.

Use the Search box to begin searching for a student with the last name beginning with Car.

Click the Search Box, type Car.

Open the Navigation Pane.

Click the Shutter Bar Open/Close button.

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

Click the arrow at the top of the Click To Add column. In the Drop-Down Menu, click the Short Text menu item.

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

Click the arrow at the top of the CourseDescription column. Point to Text Filters, and select Contains... Type Foundation in the CourseDescription contains box. Click OK.

Sort the records in this table by the values in the DOB field, so students with the newest birth dates appear first.

Click the arrow at the top of the DOB column. Click the Sort Newest to Oldest 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.

Click the arrow at the top of the DOB column. Click the Sort Z to A button. Click the arrow at the top of the Classification column. Click the Sort A to Z 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.

Click the arrow at the top of the Department column and click the (Select All) check box to remove all the checkmarks. Click the Economics check box to add a checkmark. Click OK. Click the arrow at the top of the Credits column and click (Select All) check box to remove all the checkmarks. Click the 4 check box to add a checkmark. Click OK.

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

Click the arrow at the top of the Department column. Click the (Select All) checkbox, click the Accounting checkbox, click the Finance checkbox, click OK.

Clear the filter from the Department field.

Click the arrow at the top of the Department column. In the Table Column Filter Right-Click menu, click the Clear Filter button.

Create a new table in Datasheet view. Save it with the name: Degrees

On the Create tab, in the Table group, click the Table button. Click the Save button on the Quick Access Toolbar. Type Degrees in the Table Name box. Click OK.

Import all of the fields from the Assets worksheet in the Accounting Excel file to a new table. Use the first row as column headings. Do not change any field information. Use the AccountID field as the primary key. Accept the new table Assets. Do not save the import steps.

On the External Data tab, in the Import & Link group, click the New Data Source button. Point to From File, and click Excel. Click the Browse button. Click the Accounting file. Click Open. Click OK. Click Next. Click the First Row Contains Column Headings check box. Click Next. Click Next. Click the Choose my own primary key radio button. Click Next. Click Finish. Click Close.

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

On the Fields tab, in the Add & Delete group, click the More Fields button. Scroll to the bottom of the Field Types gallery to the Quick Start section. Click Status.

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

On the Home tab, in the Find group, click the Find button to open the Find and Replace dialog. Type julie in the Find What box. Click the Match Case check box. Click Find Next.

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

On the Home tab, in the Find group, click the Replace button to open the Find and Replace dialog. Type julie in the Find What box. Type Julie in the Replace with box. Click the Match Case check box. Click Replace All. Click Yes.

Modify the width of the Time column to exactly 22.

On the Home tab, in the Records group, click the More button, and select Field Width to open the Column Width dialog. Type 22 in the Column Width: box. Click OK.

Clear the sorting from this table.

On the Home tab, in the Sort & Filter group, click the Remove Sort button.