Microsoft Access

Microsoft Access Training

Register for Microsoft Access training today! Doing your database tasks will be never be the same again.

Microsoft Access is an easy-to-use tool for creating browser-based database applications to help you run your business. Through our course, you will learn how to keep all your corporate data organized and secure, with easy-to-use, customizable applications.

 

By the end of your training, you will be able to not only use Access to keep track of your data, but tailor-make applications to suit the growth of your business.

Elevate Your Data

Acceleratia Microsoft Access Course Malaysia
Course Duration

2 Days

  • Who Should Attend

    • Accounts Clerks
    • Accounts Assistants
    • Accounts Supervisors
    • Office Administrators
    • Administrative Assistants
    • Secretaries
    • Accounting Personnel
    • For Managers, or potentially to be managers, across all business units who have little or no formal education in organizational finance and accounting for a better understanding and how to support and enhance revenue generation in their businesses

COURSE OUTLINE

Getting comfortable in Access 2013
  • Starting Access 2013
  • Looking at the desktop database window
  • Exploring the Web App window
  • Displaying results in a browser
  • Discovering what’s new in Access 2013
Understanding Access 2013 databases
  • Creating a desktop database
  • Importing and exporting data
  • Navigating the user interface
  • Working with data in a datasheet
  • Copying and pasting from a datasheet
  • Configuring Access options
  • Linking Access to external data
  • Compacting, repairing, and encrypting a database
Creating basic tables and queries
  • Creating tables for your data
  • Creating a table in Datasheet view
  • Choosing a field data type
  • Adding validation and calculated fields to your tables
  • Adding a table validation rule
  • Adding a calculated field
  • Indexing a table
  • Linking tables together with relationships
  • Creating a manual relationship
  • Creating a select query
  • Creating a query by selecting specific fields
  • Joining multiple tables in a query
  • Working with query criteria
  • Filtering and sorting a field
  • Adding multiple criteria to a query
  • Adding parameters to queries
  • Working with totals and crosstab queries
  • Cross tabulating data
Designing forms and reports
  • Creating a continuous form
  • Working with a form in Layout view
  • Creating a datasheet with conditional formatting
  • Creating a single record form
  • Creating a single record form by using the Split Form template
  • Creating a parent/child form
  • Creating a parent/child pop-up form by using the Form Wizard
  • Tying your forms together with a navigation form
  • Creating a single record report
  • Creating a tabular report with grouping
  • Creating a continuous report with conditional formatting
  • Creating a parent/child report
Creating and sharing a Web App
  • Signing in to Office 365
  • Creating a blank Web App
  • Opening an existing Web App
  • Importing data from a spreadsheet
  • Importing data from an Access desktop database
  • Navigating a Web App with the table selector
  • Navigating a Web App with the Navigation pane
  • Launching a Web App
  • Opening a database in Access from Team Site
  • Working with views
  • Working with a Datasheet view
  • Working with a List Details view
  • Adding a new blank table
  • Creating a lookup
  • Creating a summary view
  • Creating a Web App from a template

Individual

RM1500

/perpax

Corporate

RM2500

/perday*

*5 pax & below

Interested in this Course?

Do you have any enquiries?

Register with Acceleratia Academy Now!

SIGN-UP EARLY TO AVOID DISAPPOINTMENT!

    Please skip the corporate form fields if you are an individual
  • For ALL Types of Course Registration

  • This field is for validation purposes and should be left unchanged.