Microsoft Access Training: 2 Days

Microsoft Access Training Course Microsoft® Access Training
By Shivonne Louis
Microsoft® Access:

Microsoft® Access for Intermediate / Advanced Level

“Learn to generate more complicated queries, advanced forms, and reports with Microsoft Access.”

Shivonne Louis


Microsoft Office Specialist - MASTER (2000 & XP) • PSMB Certified Trainer
Request for In-house TrainingRequest for In-house Training
Register for Public Training Public program not yet available
Contact Customer Service +603-4270-3064
+6016-5488-336
Email Customer Service [email protected]
Course Title:
Microsoft® Access for Intermediate / Advanced Level
Training Category:
Information Technology
Target Audience:
This course is aimed at participants who wish to further their knowledge in the Access database environment. Candidates must have a basic understanding of Windows environment and relatively comfortable in Managing Files and Folders, Searching for Files and Folders, Using the Control Panel, and Viewing System Information.
Duration:
2 Days
For In-house Training
Request for Quotation Request for Quotation
For Other Inquiries
Contact Peak Success Abundance
Contact customer service +603-4270-3064
+6016-5488-336
Email customer service [email protected]
Delivery Methods
  • Language: English
  • PowerPoint Presentation
  • Group Discussion
  • Demonstrations
  • Certificate of Participation
Ad by Google
*Terms & Conditions

Course Introduction ›

This 2-day intermediate/advanced Microsoft Access training course is suitable for those with a basic working knowledge of Microsoft Access. It is designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features. On completion you will be able to understand relational databases and work with related tables. You will learn how to generate much more complicated queries and create more advanced forms and reports before tackling Macros.

Course Objectives ›

At the end of the course, participants should be able to:

  • Import, link and export tables
  • Work with advanced table properties
  • Use advanced select queries and create crosstab queries and charts, as well as use action queries
  • Design forms and use subforms
  • Create simple macros
  • Design Microsoft Access reports

Course Outline ›

DAY 1

LESSON 1: CONTROLLING DATA ENTRY

  • Restrict Data Entry Using Field Properties
  • Establish a Pattern for Entering Field Values
  • Create a List of Values for a Field

LESSON 2: JOINING TABLES

  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table

LESSON 3: CREATING FLEXIBLE QUERIES

  • Set Select Query Properties
  • Create Parameter Queries
  • Create Action Queries

LESSON 4: IMPROVING FORMS

  • Design a Form Layout
  • Enhance the Appearance of a Form
  • Restrict Data Entry in Forms
  • Add a Command Button to a Form
  • Create a Subform

LESSON 5: CUSTOMIZING REPORTS

  • Organize Report Information
  • Format the Report
  • Set Report Control Properties
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
DAY 2

LESSON 6: SHARING DATA ACROSS APPLICATIONS

  • Import Data into Access
  • Export Data
  • Analyze Access Data in Excel
  • Export Data to a Text File
  • Merge Access Data with a Word Document

LESSON 7: USING DATABASES ON THE INTERNET

  • Creating a Hyperlink
  • Exporting a Form to HTML
  • Creating a Data Access Page
  • Grouping a Data Access Page
  • Sorting and Grouping Data on a Data Access Page

LESSON 8: AUTOMATING TASKS

  • Creating an AutoKeys Macro
  • Using Controls to Run a Macro
  • Assigning a Macro to an Event
  • Assigning a Macro to a Condition
  • Testing and Debugging a Macro

LESSON 9: USING DATABASE TOOLS

  • Setting, Modifying, Deleting a Database Password
  • Encrypting and Decrypting a Database
  • Replicating a Database
  • Splitting a Database
  • Converting a Database
  • Setting Startup Options

Contact us now ›

  • Course content customization
  • In-house training request
  • Available public program
  • Consultation services
  • Other inquiries
Contact Customer ServiceCall : +603-4270-3064, +6016-5488-336
Email Customer Service E-mail : [email protected]

Related Courses ›

Published by: ,