Microsoft Access 2003 (Levels 1-2-3)
|
|
||||||||||
- You will be able to apply this knowledge in the workplace
- You will have an appreciable understanding of the subject matter
- You will be trained in a systematic manner designed to get you up to speed on the subject matter in a short period of time
Assessment
Testing as part of the course through exam simulation engines
Course Details
Level 1 - Overview Introduction The Course Scenario Creating a Database Creating a Table in Design View Entering Data into a Table Using AutoForm Using AutoReport Using AutoPage Summary Level 2 - Overview Using the Simple Query Wizard Creating a Query in Design View Joining Tables Using Computed Fields Using the Crosstab Query Wizard Creating a Form Using the Form Wizard Changing Form Properties Handling Form Events Creating a Report Using the Report Wizard Creating a Report in Design View Creating Data Access Pages Using the Data Access Page Wizard Summary Level 3 - Overview Finding and Updating Records Creating Update and Delete Queries Changing Table Structure Modifying a Datasheet Using the PivotTable View Establishing Validation Rules Setting Default Values Enforcing Referential Integrity Defining Relationships Sorting and Indexing Data Using Database Utilities Importing and Exporting Data Summary
Contact Hours: 24
