Chapter 1

ACCESS Assignments: Details

General Information

Always be sure your forms and printouts look correct. Adjust the spacing and alignment properly, make sure there are no spelling/typing errors in the data, and use appropriate clip art. Remember, the Chapter Learning Activities below are for you to learn the MS Access skills required to complete the assignments. These are not to be turned in and you can ignore any place they require you to print. The Step by Step exercises below are the materials that must be turned in throughout the semester. These are found at the end of the chapter starting on the page listed below e.g. (AC1.80) and have a red bar on top of the page. Assume you are completing these assignments for your boss and make them look professional. Attach a cover page containing your name, section, date the assignment, and staple all the pages together before turning in. You must complete all your own work; copies will not be accepted.

Assignments with Instructions and Database(s) or file(s) for completing exercises

Lab 1 – Creating a Database

PRE-WORK ASSIGNMENT (Chapter Learning Activities): pgs I.1-I.26, AC0.1-AC1.62 (White pages with Blue graphics inside the chapter)

Required Files/Databases: ac01_Badge1 (file)

TURN-IN ASSIGNMENT (Step by Step Exercise): ARF Adoptions Database (AC1.80) (yellow pages at the end of the chapter)

In this assignment you will create a new database, create a table, enter and edit table data, modify fields, change column widths, and preview information, and close and open and existing database and table. Follow the directions when completing the labs and include the additional steps defined in red below:

Required Files/Databases: Whitedog.bmp (file)

Make the following changes to the assignment in addition to the instructions defined in the book

a. Print the “table design view” after completion (Print 1)

Hint: see Print Table Design View (using print screen) at the bottom of this page

c. Print the”entire table design” after making the changes required in steps b & c (Print 2)

Hint: see Print Entire Table Design View (using MS Access Function) at the bottom of this page

d. Print the table (use datasheet view) after the records have been added in step d (Print 3)

e. Print the table again as instructed in the book after changes in step e (Print 4)

g. Preview and print table again as instructed after making the changes (Print 5)

Lab 2 – Modifying a Table and Creating a Form

PRE-WORK ASSIGNMENT (Chapter Learning Activities): pgs AC2.1-2.46 - White pages with Blue graphics inside the chapter

Required Files/Databases: ac02_Employees (database)

TURN-IN ASSIGNMENT (Step by Step Exercise): ARF Adoptions Database (AC2.62) - Yellow pages at the end of the chapter

In this assignment you will navigate large tables, customizing and inserting tables, hiding and redisplaying fields, finding and replacing data, sorting records, formatting the datasheet, creating and using forms, previewing and printing a form, identifying object dependencies and setting database and object properties, and documenting a database. Follow the directions when completing the labs and include the additional steps defined in red below:

Required Files/Databases: ac02_ARF (database)

Make the following changes to the assignment in addition to instructions defined in the book

b. Print the “table design view” after making the changes required in step b (Print 1)

c. Print the “entire table design” after making the changes required in step c (Print 2)

f. Print the datasheet view with all the records updated in step d & e (Print 3)

g. Print the form for the record containing your information added in step g (Print 4)

h. Print the database or file documentation containing your name (see in figures 2.54 and 2.55 in chapter) (Print 5)

Lab 3 – Analyzing Data and Creating Reports

PRE-WORK ASSIGNMENT (Chapter Learning Activities): pgs AC3.1-AC3.57 - White pages with Blue graphics inside the chapter -)

Required Files/Databases: ac03_Personnel

TURN-IN ASSIGNMENT (Step by Step Exercise): ARF Adoptions Database (AC3.69) - Yellow pages at the end of the chapter

Required Files/Databases: ac03_ARF3 (database)

In this assignment you will filter table records, create and modify a query, move columns, query two tables, create reports from tables and queries, modify a report design, select and move, and size controls, change page margins, preview and print a report, and compact and backup a database. Follow the directions when completing the labs and include the additional steps defined in red below:

Make the following changes to the assignment in addition to instructions defined in the book

b. Display and print the “design view” of the query from step b after saving (Print 1)

Please note: the “Foster Date” is actually in the “Rescues” table not in the “Foster” table as it says in the book

c. Print the query result from step c using the datasheet view (Print 2)

d. Print the datasheet view after adding your name in step d (Print 3)

g. Print the “design view” of the report after steps e, f, & g (Print 4)

h. Print the report as instructed in step h (Print 5)

Lab 4 – Working with Multiple Tables

PRE-WORK ASSIGNMENT (Chapter Learning Activities): pgs AC4.1-AC4.56 - White pages with Blue graphics inside the chapter

Required Files/Databases: ac04_Club Employees(database) ac04_pay (spreadsheet)

TURN-IN ASSIGNMENT (Step by Step Exercise): Animal Rescue Foundation Database (AC4.67)

Requited Files/Databases: ac04_ARF modified.zip (database) , Fosters.zip (file) In this assignment you will create a table by importing data from another application, create relationships between tables, create a multi-table query, add a criteria field to a query, and format and print a query. Follow the directions when completing the labs and include the additional steps defined in red below: