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. |