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)
This 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.
Use the Navigation Pane.
Open the Items table.
Switch views for the Items table.
Navigate records in a table.
Enter a new record in the Items table.
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
Find the record with an item ID of GRA1 and edit the content.
Delete the UFD1 item record.
Sort the items in the table so they are sorted alphabetically by category and then by item name within each category.
Rename the Items form.
Enter a new record in a form.
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
Find and edit the record with the item ID LAP1.
Find and delete the record with the item ID PB03.
Open the Items table again.
Review the table relationships.
Use the Compact and Repair Databases command.
Back up the database.
Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A