In this project, you will review a database created for the computer science department of a local college. They 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 2013
• Working with Security Warnings
• Backing Up a Database
• Organizing Objects in the Navigation Pane
• Switching between Database Object Views
• Navigating Records
• Creating a New Record in a Table
• Finding and Replacing Data
• Deleting Records
• Creating a New Record in a Form
• Understanding and Viewing Table Relationships
• Exporting Data to Excel or Word
• Deleting and Renaming Database Objects
• Using Compact and Repair
1. Open the start file AC2013-SkillReview-1-1.
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 category. All tables and related objects are visible.
b. Click the top of the Navigation Pane and under the Filter By Group section, select Items.
c. Observe that the Navigation Pane now displays the title Items at the top and only objects related to the Items table are visible.
d. Click the top of the Navigation Pane and select the Object Type category.
e. 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: Item ID, 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 box. Type the number 5 in this box and press [Enter]. The Current Record box should now display 5 of 21 and the fifth record in the table should be highlighted.
d. Use the following shortcut keys on your keyboard and observe which field/record becomes highlighted: Tab, up arrow, down arrow, left arrow, right arrow. In addition, try holding [Ctrl] while pressing the up arrow or down arrow.
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.
| ItemId |
ItemName |
Description |
Category |
Cost |
| ACC1 |
Accounting 2.0 |
Accounting software for small business |
Software |
$149.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 10.1
10. Delete SPH1 item record.
a. Type SPH1 in the Search box at the bottom of the table.
b. Click the record selector box on 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. 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.
12. Enter a new record in a form.
a. In the Navigation Pane, double-click the form object named ItemsForm.
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.
d. Enter the following record into your form, using [Tab] to move from one field to the next.
| ItemId |
ItemName |
Description |
Category |
Cost |
| CAM1 |
Digital Camera |
10 Megapixel SLR digital camera |
Equipment |
$499.00 |
13. 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 $450
14. 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.
15. Close the ItemsForm form.
16. Open the Items table again.
a. In the Navigation Pane, double-click the table object named Items.
b. Observe that the CAM1 item record you entered in the form was added to the table. It should be listed as the fifth item in the table.
c. Click the Last record button at the bottom of the table.
d. Close the Items table.
17. Review the table relationships.
a. On the Database Tools tab, in the Relationships group, click the Relationships button.
b. Verify that all table relationships are shown. On the Relationship Tools Design tab, in the
Relationships group, click the All Relationships button.
c. Save the changes to the relationship window layout by clicking the Save button on the Quick Access Toolbar.
d. Close the Relationships window. On the Relationship Tools Design tab, in the Relationships group, click the Close button.
18. Export the Items table to Excel.
a. In the Navigation Pane, if necessary, click the Items table once to select it.
b. On the External Data tab, in the Export group, click the Excel button.
c. Click the Browse button.
d. If necessary, navigate to the location where you save your personal project files.
e. In the File name box, type: [your initials]AC-SkillReview-1-1-Items
f. Click Save.
g. In the Export-Excel Spreadsheet window, click OK.
h. Click the Close button to finish without saving the export steps.
19. Rename the Employees table.
a. In the Navigation Pane, right-click Employees and select Rename.
b. Type: Staff
c. Press [Enter].
20. Use Compact & Repair.
a. Minimize the Access 2013 window and navigate to the folder where you saved this database. Observe the file size.
b. Return to Access and click the File tab.
c. Click the Compact & Repair Database button.
d. Minimize Access 2013 and look at your database file again. How much did the file size decrease?
21. Back up the database.
a. If necessary, maximize Access 2013 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.
22. Close the database and exit Access.
23. Upload and save the project file.
24. Submit project for grading.
Attachment:- Assignment.rar