Microsoft Access 2002: Level 3 training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Microsoft Access 2002: Level 3  

 Email information about this seminar Microsoft Access 2002: Level 3 by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Microsoft Access 2002: Level 3 by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for anyone who uses Access 2002 as a tool for getting their work done.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

In this course, students will extend their Access skills to create and implement switchboard forms, develop data access pages that include advanced controls, protect that information using security protocols, and make the data more accessible and portable (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

microsoft+access+database+2002 training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Microsoft Access 2002: Level 3 seminar

 

 

Training Course Syllabus:


Description
In this course, student will extend their Access skills to create and implement switchboard forms, develop data access pages that include advanced controls, protect that information using security protocols, and make the data more accessible and portable.

Audience
Anyone who uses Access 2002 as a tool for getting their work done. Job responsibilities might include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced capabilities, and using Access tools, as well as supporting less-advanced Access users.

Objectives
·  Put existing data into correctly designed tables and compact your database.
·  Use a variety of techniques to summarize data.
·  Create and revise basic Access macros.
·  Create macros that require data entry in certain fields and automate data entry in others.
·  Use advanced features to enhance forms.
·  Use advanced features to enhance reports and distribute a report to non-Access users.
·  Use Office Links to use Access data in other Office programs.

Benefits
·  Students will learn advanced Access 2002 skills, including how to structure existing data, summarize data, simplify tasks with macros, add interaction and automation with macros, make forms more usable, make reports more powerful, and expand the reach of data beyond Access.

Required Prerequisites
 ·  Microsoft Access 2002: Level 2

Exams
 ·  Access 2002 : Access 2002

Outline
    1. Structuring Existing Data
      1. Use the Table Analyzer Wizard for Help
      2. Decide on Your Own Design
      3. Create a Junction Table
      4. Modifying the Original Tables and Completingthe Design
      5. Compact and Repair a Database
    2. Summarizing Data
      1. Group and Summarize Records in Different Ways
      2. Summarize with a Crosstab Query
      3. Pivot Query Results
      4. Displaying a Graphical Summary on a Form
    3. Simplifying Tasks with Macros
      1. Create a Macro
      2. Attach a Macro to a Command Button
      3. Restrict Records
    4. Adding Interaction and Automation with Macros
      1. Require Data Entry with a Macro
      2. Displaying a Message Box with a Macro
      3. Automate Data Entry
    5. Making Forms More Usable
      1. Change the Display of Data Under Certain Conditions
      2. Display a Calendar on a Form
      3. Organize Information with Tab Pages
    6. Making Reports More Powerful
      1. Cancel Printing of a Blank Report
      2. Including a Chart
      3. Arranging Data in Columns
      4. Distributing Reports as a Snapshot
    7. Expanding the Reach of Your Data
      1. Merge Access Data with a Word Document
      2. Publishing Access Data as a Word Document
      3. Analyze Access Data in Excel

    Seminar Summary:

    In this course, students will extend their Access skills to create and implement switchboard forms, develop data access pages that include advanced controls, protect that information using security protocols, and make the data more accessible and portable (see full course description)

    print this agenda print agenda for the Microsoft Access 2002: Level 3 training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search