Course Info

MA2003-2 - Microsoft Access 2003 Intermediate

Categories Microsoft Office Training, Database Training, Microsoft Access Training, Applications Training, MOUS Certification Training

Duration 1 day (7 hours)

Pre-requisites
MA2003-1 - Microsoft Access 2003 Introduction or equivalent experience.

Courseware MA20032-TL (100 pages)

Price $195

Notes
Learn powerful access features such as, charts, filters, relationships, data integrity and forms.

This intermediate Microsoft Access 2003 training course covers topics including Table Design, Primary Keys, Memo Fields, Normalization, Relating Tables, Custom Forms, Queries against Multiple Tables, Calculated Fields, Internet features, Database Maintenance, and more.

"[I learned] how to do tasks that I didn't know before. [The instructor] was awesome.Take it.." -- Evelyn P. from San Diego, CA

"It's really great for database mgmt! Can you please clone [the instructor] so I can take her with me to work?." -- Rosemarie W. from San Diego, CA

"Take it, and do the exercises at home immediately. Great instructor. Personable, patient, colloquial, and good explanitory skills.." -- Victoria R. from San Diego, CA

Relational databases
      Database normalization
      Relating tables
      Implementing referential integrity
Working with related tables
      Lookup fields
      Modifying Lookup fields
      Subdatasheets
Complex queries
      Joining tables in queries
      Creating calculated fields
      Summarizing and grouping values
Advanced form design
      Adding unbound controls
      Graphics
      Adding calculated values
      Adding combo boxes
Advanced reports
      Customized headers and footers
      Adding calculated values
      Subreports
Charts
      Charts in forms
      Charts in reports
PivotTables and PivotCharts
      PivotTables
      Modifying PivotTables
      PivotCharts
Internet integration
      Hyperlink fields
      Working with data access pages
Microsoft Office Specialist exam objectives map
      Comprehensive exam objectives