Extra Practice 1. Create And Manage Databases

1.1 Create and modify databases

 

Instructions

Tips & Tricks

Help
1 Start Access and do the following: Acc16_PrT_1-1_Ex01
2 Create a database from the Desktop contacts template. (Depending on your installation of Access, the template might be named Contacts desktop.) Name the database "MOSContacts" and save it in the practice file folder.
3 If you want to explore the contact management database features, play the Using the Contacts Database video from the Welcome screen. Otherwise, close the Welcome screen. Tip: If the Welcome screen doesn’t open automatically, double-click the Welcome form in the Navigation Pane.
4 Close the "MOSContacts" database without exiting Access.
5 From the Access Start screen or the New page of the Backstage view, do the following: Acc16_PrT_1-1_Ex02
6 From the search box, locate the "Northwind" sample template.
7 Create a database from the template. Name the database "Northwind" and save it in the practice file folder.
8 Close the Northwind database without exiting Access. You will need to log into the db first.
9 From the Access Start screen or the New page of the Backstage view, do the following: Acc16_PrT_1-1_Ex03
10 Create a blank desktop database. (Depending on your installation of Access, the template might be named Blank database or Blank desktop database.) Name the database "MOSDatabase" and save it in the practice file folder.
11 Import the "Customers" and "Orders" table definitions (not the data) from the "Northwind" database you created. Tip: In the Import Objects d.b., display the Options area and, in the Import Tables section, select Definition Only.
12 Import the "ExpensesPaid" worksheet from the "Access_1-1" workbook located in the Objective1 file folder to create a new table in the "MOSDatabase" database, using the worksheet’s column headings. Use the "ExpenseID" field as the primary key. Name the table "Expenses".
13 Create a table named "ExpensesPending" that is linked to the "ExpensesPending" worksheet from the "Access_1-1.xlsx" workbook. Acc16_ExT_1-1-2_Ex01
14 Import the "EmployeePrivileges" table from the "Objective1b" database. Save your import steps with the default name. Acc16_ExT_1-1-2_Ex02
15 Close all open databases.