Objective 1.1 Create and modify databases

  • 1.1.1 Create databases
  • 1.1.2 Import database objects and data
  • 1.1.3 Delete database objects

1.1 Practice & Exam Tasks


The practice files for these tasks are located in the Objective 1-1 practice file folder. The folder also contains result files that you can use to check your work.

1. Start Access and do the following:

1.1 Create a database from the Desktop contacts template (depending on your installation of Access, the template might be named Contacts). Name the database MOSContacts  and save it in the practice file folder.

1. 2 If you want to explore the contact management database features, play the Using the Contacts Database video from the Welcome screen.

Tip: If the Welcome screen doesn’t open automatically, double-click the Welcome form in the Navigation Pane.

1.3 Close the MOSContacts database without exiting Access.

  • Open the 1-1_R_MOSContacts.accdb database to check your work.

Acc16_PrT_1-1_Ex01

2. From the Access Start screen or the New page of the Backstage view, do the following:

2.1 From the search box, locate the Northwind (depending on your installation of Access, the template might be named Northwind 2007) sample template.

2.2 Create a database from the template. Name the database Northwind  and save it in the practice file folder.

2.3 Close the Northwind database without exiting Access.

  • Open the 1-1_R_Northwind.accdb database to check your work.

Acc16_PrT_1-1_Ex02

  • Open the Access_1-1 workbook (you will need it to complete exercise 3.3).

3. From the Access Start screen or the New page of the Backstage view, do the following:

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

3.2 Import the Customers and Orders table definitions (not the data) from the Northwind database you created (or downloaded).

Tip: Display the Options area and, in the Import Tables section, select Definition Only.

3.3 Import the ExpensesPaid worksheet from the Access_1-1 workbook located in the practice 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 .

  • Open the 1-1_R_MOSDatabase.accdb database. Compare the two databases to check your work. Then close the open databases.

Acc16_PrT_1-1_Ex03

Exam Practice

Use the Objective1-1.accdb database file to complete the following tasks. You will also need the  ExpensesPaid.xlsx, and the Objective1b.accdb.

Acc16_ExT_1-1-2_Ex01 Create a table named ExpensesPaid that is linked to the ExpensesPaid.xlsx workbook in the Practice folder.
Acc16_ExT_1-1-2_Ex02 Import the EmployeePrivileges table from the Objective1b database in the Practice folder. Save your import steps with the default name.

      • Tip: check the Saved Imports (External Data tab, Import & Link group) to confirm the import steps have been saved.

  • Open the Objective1-1_Results.accdb database to check your work.