—•—
Course Description: MS Access - Paul Houston
This course is aimed at those wishing to create a relational database using MS Access version 97 or greater. Ideally you should be comfortable with using a Windows based PC, although no prior knowledge of Access is required.
You will learn how to create the database structure, create queries to sort and extract information from the database, set up forms to input and view data, and generate reports from the tables and queries you have created.
The course will consist of six weekly lessons with a 7th week wrap up and summary.
Prerequisites:
- Working knowledge of your PC and Windows
- Microsoft Access installed on your PC (at least version 97)
- The time and commitment to complete the six assignments. Access is very much a package with which you will only get out of it what you put into it!
Lessons
- Week 1
- What is a database?
- Creating a database using the Wizard
- Navigating the database
- Entering and Finding records
- Creating a Table using the Wizard
- Week 2
- Creating a Table using Design view
- Field Types
- Creating a Form
- Filtering the database
- Form Layout
- Week 3
- More on Creating Tables
- Setting up relationships
- Creating subforms
- Adding Command Buttons
- Form Properties and Controls
- Week 4
- Creating Queries using
- Sorting records
- Searching for records using Criteria
- Modifying the query
- Calculated Fields on a Query
- Week 5
- Creating a Report
- Sorting and Grouping Records
- Report Summaries
- Customising the Report Design
- Formatting the Report
- Week 6
- Input Masks
- Expression Builder
- Creating a Switchboard
- Editing Switchboard items
- Switchboard Design View
- Week 7
- Database design tips
- Questions and Answers
- Wrap up and Summary
Copyright © 2008 Visual Arts Academy
All rights reserved and protected by U.S. Copyright laws.
