Microsoft Access            Spring 2006

Instructor: Hank Maier 302 239 6552

TA: Frank Romanilli                   

WebSite: http://udel.edu/~hankudel/

 

Class Objective: To build skills so that the student can: 1) Understand an Access application, 2) learn to use Access tools to extend their capability and address ad hoc needs, 3) learn to enhance an Access application thru adding or modifying tables, writing queries, developing forms and / or writing reports and 4) use the MS Access, MSDN and search engine results to refresh or extend the knowledge gains in this class. 

 

We will not address extending an application with Visual basic (VBA).

 

Approach: Lecture, show & tell and hand on experience using examples provided by Microsoft.  Note I don’t expect to use may handouts or PowerPoint presentations. Access provides much of what the student needs to know thru menus, designer panels and the Help System. Search engines can provide a wealth of additional information.

 

Class 1 – Introduction to MS Access and examples
The IDE (Integrated Development Environment)
Contact database
Inventory database
We will cover the data base objects, tool bars, menus and the Help System
On your system explore the data base objects, tool bars, menus and the Help System. Notice how the toolbars & menus change depending on the database object selected.

Class 2- Relational databases
What are they, why do we use them
Open Contact.mdb
Open Tables Object
Explore Table Designer
Explore main data types
Explore the Relationships designer
Add a new table and link it with the Relationships designer panel

Class 3 – Queries
What are they and why do we use them?
Open Contacts.mdb
Open Query Object
Explore the Query Designer
Discuss the different type of queries
Write a query to extract data

Class 4 – Forms
Types of Forms
Simple 1 Table Forms (Auto Form)
Multiple Table & Queries (Parent / Child)
Navigate between Forms
Explore the Contact.MDB’s form
Observe the controls.
What is the data source for the form?
What are the controls “bound to”?

Class 5 – Forms
Form Wizzards
Develop a form to maintain the table created in Class 2 above

Class 6 – Forms
Develop a form to maintain a related table (Parent/Child)

Class 7 – Reports
Develop a contact report

Class 8 – Reports
Develop an inventory report

Class 9 – Reports
Using sub reports
Add a sub report to your contact report above

Class 10 – Using the Switchboard to build an application
Incorporate your form and reports into the Contact.mdb switchboard.

Class 11 – Wrap up