Extra Practice 1. Create And Manage Databases

1.3 Navigate through a database

 

Instructions

Tips & Tricks

Help

1 Open the "Access_1-3" database, and save it in the practice files folder as "Access_1-3_Final". Then do the following:
2 Open the "Customers" table in Datasheet view. Use the search box to locate the record for "The Big Cheese". Take a screenshot showing the search box and save it in your practice files folder as "Access_ExPr_Screenshot01". Close the table. Acc16_PrT_1-3_Ex01
3 Create a Navigation Pane category named "Campaigns", and groups named "Campaign Details", "Products", and "Employees". Acc16_PrT_1-3_Ex02
4 Add the "Campaign Expenses", "CampaignLanguage", and "Marketing Campaigns" tables to the "Campaign Details" group.
5 Add the "Orders" and "Products" tables to the "Products" group.
6 Add the "Employees" table to the "Employees" group.
7 Create a navigation form that has the Vertical Tabs, Left layout. Acc16_PrT_1-3_Ex03
8 Add the "TaskDetails" form to the navigation form. Save the form (use the default name for this practice task).
9 Set the form as the startup form.  Exam Task
Make the current database open with the form named "TaskDetails" form. Do NOT close the database.
Acc16_ExT_1-3-3_Ex01
10 Create a navigation form named "Tasks" that shows the "TaskDetails" form on the left-most horizontal tab and the "TaskDS" form on the right-most horizontal tab.
Save and close the navigation form.
Χρησιμοποιήστε το πλαίσιο Search του Navigation Pane για να τα εντοπίσετε εύκολα. Acc16_ExT_1-3-2_Ex01
11 Unhide the "Status" table. Πρέπει πρώτα να ορίσετε να εμφανίζονται τα κρυμμένα αντικείμενα και μετά να αλλάξετε τις ιδιότητες του συγκεκριμένου πίνακα. Acc16_ExT_1-3-4_Ex01
12 Close the database.