Using Access Databases
o Database Concepts
o Introducing Access 2003
o Introducing Database Objects
o Displaying Object Dependencies
o Displaying & Organizing Data
o Manipulating & Constraining Data
Tables
o Creating Access Databases
o Creating & Customizing Tables
o Displaying & Printing Table Data
o Customizing Field Properties
o Creating Table Relationships
o Creating Indexes
o Creating Lookup Fields
Queries
o Creating Select Queries
o Find Duplicates Query
o Find Unmatched Query
o Customizing Queries
o Sorting & Filtering through Queries
o Building Query Expressions
o Using Parameters in Queries
Forms
o Creating Simple Forms
o Designing Forms from Scratch
o Customizing Form Properties
o Creating Form Controls
o Creating Sub Forms
o Creating Search Screens
Reports
o Creating Simple Reports
o Designing Reports from Scratch
o Customizing Report Look & Feel
o Grouping & Sorting Report Data
o Creating Mailing Labels
o Adding Controls to Reports
o Previewing & Printing Reports
Data Access Pages (DAP)
o Creating Simple DAP
o Saving DAP as HTML File
o Displaying DAP from Web Browser
Macros
o Understanding Macro Components
o Creating Simple Macros
o Running Macros
o Auto Executing Macros
Advanced Database Techniques
o Importing Data to Access
o Linking Data with Different Sources
o Exporting Data to Other Programs
o Normalizing Databases
o Understanding Normal Forms
o Analyzing Databases
o Performance & Documenter Analyzer
Advanced Queries
o Crosstab Queries
o PivotTables & PivotCharts
o Joining Tables through Queries
o Make Table Query
o Update Query
o Append Query
o Delete Query
o SQL Queries
Application Automating
o Assigning Macros to Controls
o Assigning Macros to Events
o Assigning Macros to Conditions
o Macro Group
o Building Menus through Macros
Application Programming
o Introducing VBA Language
o Procedures, Functions & Modules
o Variables & Constants
o Event Procedures
o User Inputs & Program Outputs
o MsgBox & InputBox functions
o DoCmd property
o DoMenuItem Method
o Converting Macros to VBA
o Conditional If & Case Statements
o Repetitive Operations "Looping"
o List Programming
Securing & Maintaining Database
o Converting Database
o Backup, Compact And Repair
o Splitting Database
o Switchboard Manager
o Creating MDE Files
o Replicating Database
o Database Password
o User Accounts and Permissions
o User Level Security Wizard
Application
