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.