Access Basics:
Exercise 2-1

Title: Jan's Illustrated Computer Literacy 101
Did you want: Working with Databases: Access 2007, 2010, 2013, 2016

You need to use what you just learned, and maybe learn a little more. Complete all parts of the following exercises. Don't forget to backup your Class disk when you have completed the exercises or whenever you stop for the day and saved a document along the way.

This exercise uses a file from the databases resource files. The default location for these files is c:\My Documents\complit101\databases\ You cannot make changes to these files and save them in the same place. Save the changed documents to your Class disk. This keeps the original resource files intact in case you need to start over or another student will be using this same computer.

Full floppy disk How to handle a full disk

Where you are:
JegsWorks > Lessons > Databases

Before you start...

Project 1: Intro
Project 2: Access Basics Arrow: subtopic open
    InterfaceTo subtopics
    Getting StartedTo subtopics  
    Access ObjectsTo subtopics
    RelationshipsTo subtopics
    Exercises Arrow: subtopic open
    Icon: Exercise Ex. 2-1 Employees
    Icon: Exercise Ex. 2-2 Productions
    Icon: Exercise Ex. 2-3 City Soccer League
    Icon: Exercise Ex. 2-4 On Your Own

Project 3: Tables & Queries

Project 4: Forms & Reports


Exercise Database 2-1: City Theater Employees

What you will do:

Open an existing database
Add records
Delete records
Edit records
Sort records
Filter records
View subdatasheets
Print selected records
View and print Relationships

Start with:   Access open

The City Theater is setting up a database of information about their employees. You will make some changes and do some printing.

  1. Copy the file citytheater-employees.mdb from your resource files to your Class disk in the databases project2 folder.  (Create the folder if necessary.)
  2. Employees table: Use the form Employees Form to add the records below to the table Employees. Fields that are not listed below are blank.
    EmployeeNumber 123-456-7890 987-654-3210 876-543-2109
    FirstName Heidi Larry Samuel
    LastName Bumgardner Foster McKinney
    HomePhone 615-555-8899   615-555-7788
    WorkPhone 615-555-8889 615-555-8899 615-555-8899
    Extension 21 19 18
    Department Production Production Design
    JobTitle Sound Engineer Lighting Engineer Chief Designer
    Supervisor? No No Yes
    SupervisorID Fellows Fellows  
    WorkLocation Main Theater Main Theater Design Studio

    • Delete Heidi Bumgardner's record. (Note that the AutoNumber values do not change for later records.)
    • In Datasheet view, look at the Print Preview.
      How many pages will it take to print these records in Portrait orientation?
          In Landscape orientation? (Do not print.)
    • In Form view, look at the Print Preview.
      Two problems are apparent: The form is too wide for the paper. Records are split between pages.
      • Make changes to the margins in Page Setup so that the form is narrow enough to fit in the width of a page.
      • In Form Design View, select the Detail section by clicking its header bar.
        In the Properties dialog, change the Keep Together value from No to Yes.
           (This will force each record to print on a separate page.)
    • Form-  page 2Form- page 1Filter the records to show only records where the Location is "Office".
      Icon: Printer From Form View, print the filtered records. (There should be 2 records on 2 pages, one record per page.)
  3. DatasheetLocations table: In Datasheet view sort the records in Ascending order on Location.
    • Icon: Printer Print the sorted datasheet.
    • Open each of the subdatasheets for this table. (HINT: Click the + at the left of the record or from the menu select  Format | Subdatasheet |  Expand All  to view all of the subdatasheets at once.)
      On your print-out of the datasheet, circle the location which has the most employees.
  4. Relationships reportRelationships:  Open the Relationships window. Enlarge the tables until all fields are displayed.
    • Icon: Printer Print the Relationships.