Introduction to Access 2000/97   4 classes • 12 hours + practice • $130 This course focuses on working with databases. In this course, you will learn the basics of Access, which is the industry standard software for database manipulations. You will learn how to create a database, then how to fill it with data. Then, you will learn how to interrogate the database to produce pertinent information. You will also learn how to make tables, reports and forms. Everyone will have the opportunity to work hands on in building a few different databases.
At the end of the course, you will have created a complete slide presentation on a topic chosen by the class.
Everyone will have the opportunity to work hands on in building this presentation.   Prerequisites: This course is intensive.
There is no homework, but be prepared to work hard when you are in class.
This course is ONLY for people who are already comfortable with Windows environment (95, 98, ME, XP, etc.) and who have at least basic word processing skills.
 
Lesson 1 Lesson 3
     
  • Introduction to course
  • Assumptions
  • Introduction to Access
  • Difference between Excel and Access
  • What is a database? Examples
  • Different views
  • Records and fields
  • Primary key
  • Creating a database
  • Quiz
     
  • Queries
  • Create a new query
  • Print the results of the query
  • Query exercises
  • Query criteria
  • Save the query
  • Quiz
Lesson 2 Lesson 4
     
  • Tables
  • Create a table
  • Add data to the table
  • Print the contents of a table
  • Create more tables
  • Forms
  • Create a form
  • Reports
  • Create a report
  • Quiz
     
  • Maintaining a database
  • Adding records to a table
  • Modifying records
  • Deleting records
  • Adding a field
  • Modifying a field
  • Deleting a field
  • Specifying required fields, a range, default value, etc.
  • Quiz
 


Last update: March 2005

(next update to be determined)
FRASER-HICKSON LIBRARY COMPUTER CENTRE • 4855 Avenue Kensington, Montreal QC H3X 3S6 • TEL: (514) 489-5301 ext. 203
 • e-mail • webmaster • Web Design Fight Spam!