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
