||Access Tutorial 1.1 DB
||Read Chapters 1 and 2, What
is Access, Installing and Using Access. Do Lab Ex 1, Intro and 2, Creating
||Read Chap 3&4, Database
Concepts and Tour of Access 2000. Start Lab Excercise 3 Table Design.
||Read Chap 5, Database
Design, & 6,Creating Database Tables. Lab 4, Access Objects: Queries,
Forms, Reports (See
homework sheet or Lab for Details) Lab,
Chap. 7 Entering/Changing/Deleting/Displaying Data and Ch 8 Creating and
Using Simple Data-Entry Forms. In Lab:
Lab 5 Controlling Users Input
||Read Chap 9 Queries and 10
Printing Reports Start Lab 7 Forms Design.
||Mid Term Practical Exam. Be able to create Databases, Tables, Forms, Queries, and Data Access Pages
||Go over Practical Exam. Do Multiple Choice Exam
||Teachers Conference, No Class
||Read Chap 11 Relationships Chap 12 Using Operators, Functions & Expressions. Lab 6 Relationships
||Chap 13 Creating Relations & Joins in Queries Ch 14 Creating Select Queries.
Lab 8 Exploring and Analyzing Data
||Chap 15 Understanding Controls & Properties. Chap 16 Creating & Customizing Data-Entry Forms, Lab 9&15
||Chap 17 Creating Great Looking Forms, Chap 18 Adding Data Validation Controls to Forms, Lab 10 Forms Properties
||Lab 11 Calculated Fields due Read chap 22 calculations & summaries
||Review, Final Practical Exam Starts
||Final Exam Access MC
||Make up exams, grades available on the Website
||Best of luck in the future!