What you'll learn?

  • Understand and get familiar with the database normalization
  • Work with the Table Analyzer to enhance tables' design
  • Use the Performance Analyzer to enhance the database performance
  • Use the Documenter to produce statistical reports about databases
  • Create and use crosstab queries to get structural matrix reports
  • Create and customize PivotTables to produce complex structural matrix reports
  • Create PivotCharts to graphically represent data
  • Display related data from multiple tables using joins
  • Manipulate tables' data using action queries
  • Write simple SQL SELECT statements against tables' data
  • Use the WHERE clause to restrict data through SELECT statements
  • Use the ORDER BY clause to sort data through SELECT statements
  • Create and use macros to automate database usual tasks
  • Assign macros to controls, events and conditions
  • Create and use macro groups
  • Convert databases between various Microsoft Access versions
  • Split a database to back-end and front-end databases
  • Compact and repair databases
  • Create a backup copy from the database file
  • Secure databases by using passwords
  • Create switchboard forms using the Switchboard Manager

Description

In this course, trainees will learn advanced features of Microsoft Access 2007. They will go through the development of several sophisticated applications a step by step. The course stresses on providing in-depth understanding of database design, as well as using the advanced Access 2007 techniques to enhance both of the appearance and functionality of the database applications.

Audience :

This course is designed for trainees who would like to master Access 2007 advanced features.

Topics :

Advanced Database Techniques

o  Normalizing databases

o  First, second and third normal forms

o  Analyzing databases

o  Performance Analyzer & Documenter

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

Automating Database Applications

o  Working with macros

o  Assigning macros to controls

o  Assigning macros to events

o  Assigning macros to conditions

o  Working with macro groups

Securing & Maintaining Databases

o  Converting databases

o  Backing up, compacting and repairing databases

o  Splitting databases

o  Working with Switchboard Manager

o  Applying a database password

Prerequisities :

Recommended Knowledge :

Microsoft Access 2007 Core Level

Recommended Course(s) :

Category :

  • Desktop
  • Database
  • Office

Training Materials :

YAT Official Courseware

Labs :

This course includes several labs to ensure that you will gain the targeted skills and experiences.

Credential :

This course is an essential part of YPDA 2007 Expert and Mastering Access.