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:  

Make the following changes to the assignment in addition to instructions defined in the book. Please note: the database ac04_ARF does not contain the table Fosters (you will add it in additional instructions in step a below)

a. After renaming the database, import the information from the spreadsheet Fosters into a new table “Fosters” in the “Animal Rescue Foundation” database. Make the “Foster ID” the primary key in this new table

c. Print the relationships report as instructed in step c (Print 1)

e. Print the “table design” of the Fosters table after changes were in step d & e (Print 2)

e. Print the table as instructed after making the changes in step e (Print 3)

g. Print the query “design view” after making changes in step f & g (Print 4)

i.  Print the query as instructed in step i created from steps h & i (Print 5)

 

Lab 5:

Lab 5 will be given by your instructor

 

Special Instructions for Labs (as referenced above)

Print Table Design View (using print screen)

1.      Display the design view for a table

2.      Open a Powerpoint or Word document and set the orientation to landscape

3.      Press the Function Key and Print Screen button simultaneously

4.      Position the cursor on the Powerpoint or Word document and press Ctrl and V or Edit then Paste to paste the screen image into the document

5.      Resize and format as appropriate so that it can be read by the grader

Print Entire Table Design (using MS Access Function)

1.      On the Tools menu, point to Analyze, and then click Documenter.

2.      Click the Tables tab and select the table that you want to document and click OK

3.      Once the preview of the design view is displayed, check the length of the document (total number of pages).  If you are working in the school lab, and the document is 3 pages or less click Print Button image from the toolbar.  If you are in the school lab, and the document is greater than 4 pages, on the File menu, select and click Print and print first pages 1-3,  then print again from pages 4-n.