|
|
ICB Consulting, Inc. Good with computers, but even better at helping people. |
|
|
ICB Consulting, Inc. Good with computers, but even better at helping people. |
|
|
Microsoft Access Level 2 Training Class This is a one day, intermediate level class on Microsoft Access. It is an instructor-led, classroom style training course. It assumes you have either taken the Microsoft Access Level 1 training class or you have at least some experience using Microsoft Access. Target Student: Students enrolling
in this course should have a basic level of understanding of the
Microsoft Access
interface, and should have some experience designing tables, simple
queries, forms, and reports. Lesson 1: Principles of Table Design Topic 1A: Normalizing Data Topic 1B: Normalizing Data for Fourth and Fifth Normal Forms Lesson 2: Principles of Table Relationships Topic 2A: Analyzing Table Relationships Topic 2B: Establishing and Testing Referential Integrity Lesson 3: Table Design Techniques Topic 3A: Data Validation Techniques Topic 3B: Indexing Techniques Lesson 4: Designing Select Queries Topic 4A: Using Calculated Fields in Queries Topic 4B: Creating Multiple-table Queries Lesson 5: Customizing Form Designs Topic 5A: Customizing the Form Design Topic 5B: Performing Calculations on a Form Topic 5C: Adding Combo Boxes to a Form Topic 5D: Adding Unbound Controls Lesson 6: Working with Data Access Pages Topic 6A: Creating Data Access Pages Topic 6B: Integrating with Other Applications Lesson 7: Customizing Reports Topic 7A: Customizing a Report Created by the Report Wizard Topic 7B: Working with Subreports Topic 7C: Creating a Report in Design View
|
|
Copyright: ICB Consulting, Inc. | About Us | Contact Us |
