ACCESS proj

Skill Review 1.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.1)
• Working with Security Warnings (Skill 1.2)
• Backing Up a Database (Skill 1.16)
• Organizing Objects in the Navigation Pane (Skill 1.4)
• Switching between Database Object Views (Skill 1.5)
• Navigating Records (Skill 1.6)
• Creating a New Record in a Table and Entering Data (Skill 1.7)
• Finding and Replacing Data (Skill 1.12)
• Deleting Records (Skill 1.13)
• Adjusting Table Column Widths (Skill 1.9)
• Sorting Records in a Datasheet (Skill 1.8)
• Deleting and Renaming Database Objects (Skill 1.14)
• Creating a New Record in a Form and Entering Data (Skill 1.10)
• Understanding and Viewing Table Relationships (Skill 1.3)
• Using Compact and Repair (Skill 1.20)

Steps to complete this project:

Mark the steps as checked when you complete them.

1. Open the AC2021-SkillReview-1-1 database.
2. If necessary, enable active content by clicking the Enable Content button in the Message Bar.
3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
4. 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 TypeObserve that now all database objects are visible in the Navigation Pane, grouped by object type.
5. Open the Items table.In the Navigation Pane, double-click the table object named Items.Review the fields in this table:

   ItemID

   ,

   Save Time On Research and Writing

   Hire a Pro to Write You a 100% Plagiarism-Free Paper.

   Get My Paper

   ItemName

   ,

   Description

   ,

   Category

   , and

   Cost

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

6. 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.
7. 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 ↓.
8. 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.1 displays the information for a record in Microsoft Access.

ItemIDItemNameDescriptionCategoryCost

ACC1	AccountingPro 2.0	Accounting software for professionals	Software	$175.00

1. Find the record with an item ID of GRA1 and edit the content.Type GRA1 in the Search box at the bottom of the table.Edit the content in the ItemName field to: Graphics Studio 14
2. Delete the UFD1 item record.Type UFD1 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.
3. 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.
4. 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 Home tab, in the Sort & Filter group, click the Ascending button.Click anywhere in the Category field.On the Home tab, in the Sort & Filter group, click the Ascending button.Save the table by pressing Ctrl + S.
5. Close the Items table by clicking the X at the upper right corner of the table. Be careful not to close the Access database instead.
6. Rename the Items form.In the Navigation Pane, right-click the Items form and select Rename. Be careful not to rename the Items table.Type: Enter ItemsPress Enter.
7. Enter a new record in a form.In the Navigation Pane, double-click the form object named Enter Items.Observe the record navigation buttons at the bottom of the form and note that they are the same as those in the table.Click the New (blank) record button at the bottom of the form.
8. Enter the following record into your form, using Tab to move from one field to the next.

Table AC 1.2 displays the information for a record in Microsoft Access.

ItemIDItemNameDescriptionCategoryCost

TAB1

Tablet

High res tablet

Equipment

$649.00

1. Find and edit the record with the item ID LAP1.On the Home tab, in the Find group, click the Find button.Type LAP1 in the Find What box.Click the Find Next button.Close the Find and Replace dialog by clicking the X in the upper right corner of the dialog.The form should now display the Laptop 1000 item.Click in the Cost field and change the value from $550 to $799.
2. Find and delete the record with the item ID PB03.On the Home tab, in the Find group, click the Find button.Type PB03 in the Find What box.Click the Find Next button.Close the Find and Replace dialog by clicking the X in the upper right corner of the dialog.The form should now display the Presentation Basics item.On the Home tab, in the Records group, click the Delete button arrow, and select Delete Record.Click Yes to verify that you want to delete the record.
3. Close the Enter Items form.
4. Open the Items table again.In the Navigation Pane, double-click the table object named Items.Observe that the TAB1 item record you entered in the form was added to the table. It should be listed as the eighth item in the table.Click the Last record button at the bottom of the table.Close the Items table.
5. Review the table relationships.On the Database Tools tab, in the Relationships group, click the Relationships button.Verify that all table fields are shown. If necessary, increase the size of the table boxes. Starting with the table at the far left of the Relationships window, right-click the table and selct Size to Fit. Repeat the process with the remaining tables, moving from left to right across the Relationships window.Display all table relationships. On the Relationships Design tab, in the Relationships group, click the All Relationships button.Save the changes to the Relationships window layout by pressing Ctrl + S.Close the Relationships window. On the Relationships Design tab, in the Relationships group, click the Close button.
6. Use the Compact and Repair Databases command.Minimize the Access window and navigate to the folder where you saved this database. Observe the file size.Return to Access and click the Database Tools tab.In the Tools group, click the Compact & Repair Database button.Minimize Access and look at your database file again. How much did the file size decrease?
7. Back up the database.If necessary, maximize Access and click the File tab.Click Save As.In the Save Database As section, under Advanced, click Back Up Database, and click the Save As button.If necessary, navigate to the location where you save your personal project files. Click the Save button.
8. Close the database and exit Access.
9. Upload and save your project file.
10. Submit project for grading.

Skill Review 1.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.1)
Working with Security Warnings (Skill 1.2)
Backing Up a Database (Skill 1.16)
Organizing Objects in the Navigation Pane (Skill 1.4)
Switching between Database Object Views (Skill 1.5)
Navigating Records (Skill 1.6)
Creating a New Record in a Table and Entering Data (Skill 1.7)
Finding and Replacing Data (Skill 1.12)
Deleting Records (Skill 1.13)
Adjusting Table Column Widths (Skill 1.9)
Sorting Records in a Datasheet (Skill 1.8)
Deleting and Renaming Database Objects (Skill 1.14)
Creating a New Record in a Form and Entering Data (Skill 1.10)
Understanding and Viewing Table Relationships (Skill 1.3)
Using Compact and Repair (Skill 1.20)
Steps to complete this project:
Mark the steps as checked when you complete them.
1. Open the AC2021-SkillReview-1-1 database.
2. If necessary, enable active content by clicking the Enable Content button in the
Message Bar.
3. The file will be renamed automatically to include your name. Change the project file
name if directed to do so by your instructor.
4. Use the Navigation Pane.
a. By default, the Navigation Pane displays the Tables and Related Views All
tables and related objects are visible.
b. Click the top of the Navigation Pane and select the Object Type
c. Observe that now all database objects are visible in the Navigation Pane,
grouped by object type.
5. Open the Items table.
a. In the Navigation Pane, double-click the table object named Items.
b. Review the fields in this table: ItemID, ItemName, Description, Category,
and Cost.
c. If necessary, use the horizontal scroll bar to view all the fields.
6. Switch views for the Items table.
a. 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.
b. On the Home tab, in the Views group, click the View button.
c. Observe that the View button has switched to Datasheet view to indicate
that clicking the button will return you to Datasheet view.
d. Review the field names in Design view.
e. Go back to Datasheet view by clicking the View button again.
7. Navigate records in a table.
a. Observe the record navigation buttons at the bottom of the table. Move
your mouse over the different arrow buttons and observe the ScreenTips.
b. Observe which record in the table becomes highlighted as you click the
following record navigation buttons: Last record, First record, Next
record, Previous record.
c. 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.
d. 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 ↓ .
8. Enter a new record in the Items table.
a. Click the New (blank) record button at the bottom of the table.
b. 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.1 displays the information for a record in Microsoft Access.
ItemID
ItemName
Description
Category
Cost
ACC1
AccountingPro
2.0
Accounting
software for
professionals
Software
$175.00
9. Find the record with an item ID of GRA1 and edit the content.
a. Type GRA1 in the Search box at the bottom of the table.
b. Edit the content in the ItemName field to: Graphics Studio 14
10. Delete the UFD1 item record.
a. Type UFD1 in the Search box at the bottom of the table.
b. Click the record selector box at the left side of that row to highlight the
entire record.
c. On the Home tab, in the Records group, click the Delete button.
d. Click Yes to verify that you want to delete the record.
11. 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.
12. Sort the items in the table so they are sorted alphabetically by category and then by
item name within each category.
a. Click anywhere in the ItemName field.
b. On the Home tab, in the Sort & Filter group, click the Ascending button.
c. Click anywhere in the Category field.
d. On the Home tab, in the Sort & Filter group, click the Ascending button.
e. Save the table by pressing Ctrl + S .
13. Close the Items table by clicking the X at the upper right corner of the table. Be
careful not to close the Access database instead.
14. Rename the Items form.
a. In the Navigation Pane, right-click the Items form and select Rename. Be
careful not to rename the Items table.
b. Type: Enter Items
c. Press Enter .
15. Enter a new record in a form.
a. In the Navigation Pane, double-click the form object named Enter Items.
b. Observe the record navigation buttons at the bottom of the form and note
that they are the same as those in the table.
c. Click the New (blank) record button at the bottom of the form.
16. Enter the following record into your form, using Tab to move from one field to the
next.
Table AC 1.2 displays the information for a record in Microsoft Access.
ItemID
ItemName
Description
Category
Cost
TAB1
Tablet
High res tablet
Equipment
$649.00
17. Find and edit the record with the item ID LAP1.
a. On the Home tab, in the Find group, click the Find button.
b. Type LAP1 in the Find What box.
c. Click the Find Next button.
d. Close the Find and Replace dialog by clicking the X in the upper right
corner of the dialog.
e. The form should now display the Laptop 1000 item.
f. Click in the Cost field and change the value from $550 to $799.
18. Find and delete the record with the item ID PB03.
a. On the Home tab, in the Find group, click the Find button.
b. Type PB03 in the Find What box.
c. Click the Find Next button.
d. Close the Find and Replace dialog by clicking the X in the upper right
corner of the dialog.
e. The form should now display the Presentation Basics item.
f. On the Home tab, in the Records group, click the Delete button arrow, and
select Delete Record.
g. Click Yes to verify that you want to delete the record.
19. Close the Enter Items form.
20. Open the Items table again.
a. In the Navigation Pane, double-click the table object named Items.
b. Observe that the TAB1 item record you entered in the form was added to
the table. It should be listed as the eighth item in the table.
c. Click the Last record button at the bottom of the table.
d. Close the Items table.
21. Review the table relationships.
a. On the Database Tools tab, in the Relationships group, click
the Relationships button.
b. Verify that all table fields are shown. If necessary, increase the size of the
table boxes. Starting with the table at the far left of the Relationships
window, right-click the table and selct Size to Fit. Repeat the process with
the remaining tables, moving from left to right across the Relationships
window.
c. Display all table relationships. On the Relationships Design tab, in
the Relationships group, click the All Relationships button.
d. Save the changes to the Relationships window layout by pressing Ctrl + S .
e. Close the Relationships window. On the Relationships Design tab, in
the Relationships group, click the Close button.
22. Use the Compact and Repair Databases command.
a. Minimize the Access window and navigate to the folder where you saved
this database. Observe the file size.
b. Return to Access and click the Database Tools tab.
c. In the Tools group, click the Compact & Repair Database button.
d. Minimize Access and look at your database file again. How much did the
file size decrease?
23. Back up the database.
a. If necessary, maximize Access and click the File tab.
b. Click Save As.
c. In the Save Database As section, under Advanced, click Back Up Database,
and click the Save As button.
d. If necessary, navigate to the location where you save your personal project
files. Click the Save button.
24. Close the database and exit Access.
25. Upload and save your project file.
26. Submit project for grading.