Extra Practice 1. Create And Manage Databases
1.4 Protect and maintain databases
Instructions |
Tips & Tricks |
Help |
|
1 | Open the "Access_1-4" databaseand save it in the practice files folder as "Access_1-4_Final". Then open "Access_1-4_Final" for exclusive use, and then do the following: | ||
2 | Log on by using any user name. | ||
3 | Configure the database so it automatically compacts itselft when closed. Do NOT close the database. Take a screenshot of the d.b. and save the screenshot as "Access_ExPr_Screenshot02". | Acc16_ExT_1-4-1_Ex01 | |
4 | Create a password for the database. Use the password "Access2016". | Tip: Αγνοήστε το προειδοποιητικό μήνυμα. | Acc16_PrT_1-4_Ex01-05 |
5 | Compact and repair the database. Take a screenshot of the relevant backstage page and save the screenshot as "Access_ExPr_Screenshot03". | ||
6 | Create a backup of the database. Name the backup "MOSBackup". | Exam Task Back up the database to the Practice folder using the default file name. If multiple Practice folders are shown, any are acceptable. |
Acc16_ExT_1-4-2_Ex01 |
7 | Manage objects as follows: | Acc16_PrT_1-4_Ex06 | |
8 | Rename the "Customer List" form as "Customer List_old". | ||
9 | Restore the "Customer List" form from the "MOSBackup" database. | ||
10 | Delete the "Customer List_old" form. Take a screenshot of the deletion d.b. and save the screenshot as "Access_ExPr_Screenshot04". | ||
11 | Split the "Access_1-4_Final" database to create a front-end database and a back-end database. | ||
12 | Save the back-end database in the practice file folder using the default name "Access_1-4_Final_be". |
||
13 | Close the database. |