Skill Review $1\mathrm{.}1$

In this project, you will review a database created for the Computer Science department of a local college. The school would like your assistance in using Access to keep track of which employees have borrowed items from the department. Become comfortable with the department$$s database by completing the steps below.

Skills needed to complete this project:

Introduction to Access $($Skill $1\mathrm{.}1)$

Working with Security Warnings $($Skill $1\mathrm{.}2)$

Backing Up a Database $($Skill $1\mathrm{.}16)$

Organizing Objects in the Navigation Pane $($Skill $1\mathrm{.}4)$

Switching between Database Object Views $($Skill $1\mathrm{.}5)$

Navigating Records $($Skill $1\mathrm{.}6)$

Creating a New Record in a Table and Entering Data $($Skill $1\mathrm{.}7)$

Finding and Replacing Data $($Skill $1\mathrm{.}12)$

Deleting Records $($Skill $1\mathrm{.}13)$

Adjusting Table Column Widths $($Skill $1\mathrm{.}9)$

Sorting Records in a Datasheet $($Skill $1\mathrm{.}8)$

Deleting and Renaming Database Objects $($Skill $1\mathrm{.}14)$

Creating a New Record in a Form and Entering Data $($Skill $1\mathrm{.}10)$

Understanding and Viewing Table Relationships $($Skill $1\mathrm{.}3)$

Using Compact and Repair $($Skill $1\mathrm{.}20)$

Steps to complete this project:

Mark the steps as checked when you complete them.

Alternate Instruction for Microsoft $365$ Apps iconThis image appears when a project instruction has changed to accommodate an update to Microsoft $365$ Apps. If the instruction does not match your version of Office, try using the alternate instruction instead.

Open the AC$2019-$SkillReview$-1-1$ database.

If necessary, enable active content by clicking the Enable Content button in the Message Bar.

The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.

Use the Navigation Pane.

By default, the Navigation Pane displays the Tables and Related Views All tables and related objects are visible.

Click the top of the Navigation Pane and select the Object Type

Observe that now all database objects are visible in the Navigation Pane, grouped by object type.

Open the Items table.

In the Navigation Pane, double$-$click the table object named Items.

Review the fields in this table: ItemID, ItemName, Description, Category, and Cost.

If necessary, use the horizontal scroll bar to view all the fields.

Switch views for the Items table.

Note the state of the View button $($on the Home tab, in the Views group$).$ When you are in Datasheet view, the Views button displays Design view.

On the Home tab, in the Views group, click the View button.

Observe that the View button has switched to Datasheet view to indicate that clicking the button will return you to Datasheet view.

Review the field names in Design view.

Go back to Datasheet view by clicking the View button again.

Navigate records in a table.

Observe the record navigation buttons at the bottom of the table. Move your mouse over the different arrow buttons and observe the ScreenTips.

Observe which record in the table becomes highlighted as you click the following record navigation buttons: Last record, First record, Next record, Previous record.

Find the Current Record box, which indicates the current record number and the total number of records. Click to select the number in the Current Record Type the number $7$ in this box and press Enter. The Current Record box should now display $7$ of $21$ and the seventh record in the table should be highlighted.

Click in any record in the table. Use the following shortcut keys on your keyboard and observe which field$/$record becomes highlighted: Tab, $,,,->.$ In addition, try holding Ctrl while pressing the $,$ or $.$

Enter a new record in the Items table.

Click the New $($blank$)$ record button at the bottom of the table.

Enter the following record into your table, using Tab to move from one field to the next. When you reach the Category field, observe that it is a lookup field. Use the drop$-$down arrow to view and select from the available values.

Table AC $1\mathrm{.}1$ displays the information for a record in Microsoft Access.

ItemID

ItemName

Description

Category

Cost

ACC$1$

AccountingPro $2\mathrm{.}0$

Accounting software for professionals

Software

$$175\mathrm{.}00$

Find the record with an item ID of GRA$1$ and edit the content.

Type GRA$1$ in the Search box at the bottom of the table.

Edit the content in the ItemName field to: Graphics Studio $14$

Delete the UFD$1$ item record.

Type UFD$1$ in the Search box at the bottom of the table.

Click the record selector box at the left side of that row to highlight the entire record.

On the Home tab, in the Records group, click the Delete button.

Click Yes to verify that you want to delete the record.

AutoFit the width of the Description column so all the descriptions are visible by double$-$clicking the right border of the top of the Description column.

Sort the items in the table so they are sorted alphabetically by category and then by item name within each category.

Click anywhere in the ItemName field.

On the Ho