Home > The Career Center > Access PowerUser Level
Provided by: The Career Center

Access PowerUser Level

 The Career Center
Your training in and use of Access has provided you with a solid foundation in the basic and intermediate skills for working in Access. You're now ready to extend your knowledge into some of the more specialized and advanced capabilities. You will use advanced capabilities of Access to work with improperly structured data, perform summary operations on data, create macros to automate tasks, enhance forms and reports, and use Access data in other Office applications. This course targets persons who have job responsibilities that include structuring existing data into properly designed tables, analyzing data, automating work in Access, implementing advanced form and report capabilities, and using Access tools. Persons who have some or all of these responsibilities and who perform these tasks for their own work or in support of less-advanced Access users.

Upon successful completion of this course, students will be able to:

  • use a variety of techniques to summarize data.
  • create and revise basic Access macros.
  • create macros that require data entry in certain fields and automatic 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.

This is primarily ilt training
instructor led trainingThis class may be available at a classroom in New York, NY, or at one of these training facilities: New York City, NY,
Duration:8 hours
Training Presented in:English
Training Provided by The Career Center
Click here for more information or to take this course
  • D asked: Interested in finding a numeric data entry course
  • asked: Do you have classes in long island for date entry?
Access PowerUser Level
Prerequisites:
  • Access Expert Level

Next Course(s):
None

This course is included in the following Certification Program:

  • Microsoft Office Specialist

Our Program is All-Inclusive:

  • 8 hours of classroom instruction
  • Unlimited supervised computer lab/practice time for 6 months
  • A complete instruction manual
  • Certificate upon completion
  • Career Enhancement Services
  • Full Placement Counseling
  • Free Resume Review
  • Job Placement Assistance
  • Free Test Preparation
  • Computer-Based Training Files
  • Assessment Testing
  • Internship Opportunities
  • Guarantee: Retake the course for free until test passed and/or employed.
  • Check the schedule

Topics:

Lesson 1: Structuring Existing Data
      Topic 1A: Use the Table Analyzer Wizard for Help
      Topic 1B: Decide on Your Own Design
      Topic 1C: Create a Junction Table
      Topic 1D: Modify the Original Tables and Complete the Design
      Topic 1E: Compact and Repair a Database

Lesson 2: Summarizing Data
      Topic 2A: Group and Summarize Records in Different Ways
      Topic 2B: Summarize with a Crosstab Query
      Topic 2C: Pivot Query Results
      Topic 2D: Display a Graphical Summary on a Form

Lesson 3: Simplifying Tasks with Macros
      Topic 3A: Create a Macro
      Topic 3B: Attach a Macro to a Command Button
      Topic 3C: Restrict Records

Lesson 4: Adding Interaction and Automation with Macros
      Topic 4A: Require Data Entry with a Macro
      Topic 4B: Display a Message Box with a Macro
      Topic 4C: Automate Data Entry

Lesson 5: Making Forms More Usable
      Topic 5A: Change the Display of Data Under Certain Conditions
      Topic 5B: Display a Calendar on a Form
      Topic 5C: Organize Information with Tab Pages

Lesson 6: Making Reports More Powerful
      Topic 6A: Cancel Printing of a Blank Report
      Topic 6B: Include a Chart
      Topic 6C: Arrange Data in Columns
      Topic 6D: Distribute Reports as a Snapshot

Lesson 7: Expanding the Reach of Your Data
      Topic 7A: Merge Access Data with a Word Document
      Topic 7B: Publish Access Data as a Word Document
      Topic 7C: Analyze Access Data in Excel

About The Training Provider: The Career Center
The Career Center - The Career Center has been advancing computer skills in the heart of New York City since 1988. We offer affordable hands-on, instructor-led classroom style training, in state-of-the-art classrooms at 34th St. & Madison Ave. or at the location of your choice.' We provide over 100 computer classes, taught by industry experienced instructors at convenient times and affordable prices. We offer...
Click here for more information or to take this course
Home > The Career Center > Access PowerUser Level
Advertise With Us
Do you offer training?
Custom Search
tcw11-v473M-12/15/11-10:01:29-()[B]-[B]-[B] -18:15:54