Lab Outline

Home Up Prospectus Assignments Lab Outline Homework Database Concepts Using Documentor The Power of Queries Table Relationships Mid Term Review Final Review Final Ex.Inf. Thurs Eve Grades

1 Intro
2 Create A DB
3 Creating Tables
4 Objects
5 User Input
6 Relationships
7 Advanced Forms
8 Analyzing Data
9 Queries
10 Advanced Forms
11 Calculated Fields
12 Advanced Queries
13 Controls
14 Reports
Lab 15 Import/Export

CGS 1541 & CGV 0250 - Access 2000

Lab Outline

Instructor:         Ray Merry,  www.raymerry.com,  Email: ray@raymerry.com

Lab Outline: (Just Click on the Appropriate Link below)

To download all the tables for the exercises click here, then right click and save.
If you do not know how to use zip files go here first: http://www.writersforhire.com/help&faq/ZipFiles.html

OLD LABS, as in Printed Handout:
Note These are the old lessons, as in the printed tutorial, they are linked online at this time up through lab 11.  You may also use the printed tutorial to do these. Use these for assignments until notified to the contrary  You are to do the assignment as in the link on the left, then click on the right link to find out what you are to hand in.  The homework is generally the same as the excercises at the end of the tutorial, but not always!

  1.  - Creating A Database - Due Week2  Lab 2 Homework

  2.  - Tables Design - Week 3 Lab 3 Homework

  3.  - Introduction To Microsoft Access Objects - Week 4 Lab 4 Homework

  4.  - Controlling The User's Input - Week 5 Lab 5 Homework

  5.  - Relationships - Subdatasheets - Week 8 (3/8/01) Lab 6 Homework

  6.  - Forms Design Overview - Week 6 (2/8/01) Lab 7 Homework

  7.  - Exploring And Analyzing Data - Week 9 (3/15/01) Lab 8 Homework

  8.  - Queries, Design And Exploration - Week 10 (3/22/01) Lab 9&15 Homework

  9.  - Advanced Forms -  Week 11 (3/29/01) Lab 10 Homework

  10.  - Calculated Fields -  Week 12 (4/5/01)

  11. Advanced Queries on your own

  12.  - Exploring Forms Controls - on your own!

  13.  - Designing And Improving A Report - on your own!

  14.  - Importing From And Exporting Data To Other Applications  Week 10 (3/22/01)

  15.  - Macros - on your own

  16.  - Switchboard - on your own

You may use these new Lab Links for your own reference.  Homework will be based on old links above until notified otherwise.

New Online Tutorial References. or Use Web Reference: http://www.functionx.com/access/  

 

Home Prospectus Assignments Lab Outline Homework Database Concepts Using Documentor The Power of Queries Table Relationships Mid Term Review Final Review Final Ex.Inf. Thurs Eve Grades