Microsoft Access 2010

Apply now for our Microsoft Access 2010 Course

Upgrade to Microsoft Access 2013


  • Getting Started with Access 2010
  • Building The Structure of a Database
  • Sharing Data Across Applications
  • Integrating Access into Your Business
  • Sharing Databases Using a SharePoint Site


Course Details and Pricing


Instructor Led Learning


  Duration: 3 Days

  Registration Open Now!

Video Learning


  Duration: 3 Days

  Registration Open Now!

Call us : 0861 111 460

Microsoft Access 2010 overview

Microsoft Access 2010 Courses | Online & Classroom Training

Manage your data after completing our Microsoft Access Training!
After completing our Microsoft Access 2010 Courses you will be able to use Microsoft Access to manage data including creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.Take control of your data with Microsoft Access relational database software training at New Horizons. Our courses will teach you basic to advanced features of Access.Whether you are new to Access or an advanced user, this training will cover what you need to know as efficiently as possible. New Horizons offers world-class training for several versions, including 2016, 2013, 2010, 2007 and earlier. And, of course, all classes are delivered by one of our Microsoft Certified Trainers.





Microsoft Access Course capetown south africa

What is Microsoft Access 2010?

Although perhaps not as widely used as Word or Excel, Access is, in some respects, the most powerful program in Microsoft Office 2010. Access is a flexible and relatively simple way to create databases to store, manage and enter data. It even exceeds the capabilities of Excel.Access provides a simple yet robust way to manage your data. Simple, of course, is a relative term. But these ten tips can make life with Access simpler.Access databases can range from a simple application like a mom & pop inventory tracker to an enterprise app that integrates with SQL servers and contains thousands of records. Access's power has increased significantly with the release of Access 2010.

Microsoft Project 2013 Course capetown south africa

Who should attend Microsoft Access Training?

Our Microsoft Access 2010 Courses has been designed for students who wish to learn the operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes.

Microsoft Access 2010 Beginners will assist organizations maintain and manage large amounts of information.Information can be sorted, linked and managed using a single relational database application and its associated tools.

When attending Microsoft Access 2010 Courses, you will examine the basic database concepts, and create and modify databases and their various object using the Microsoft Office Access relational database application.

What is the aim of our Microsoft Access 2010 Courses?

Microsoft Access Training - Level 1

This course is for the new user of Microsoft Access and assumes no experience with relational databases. The topics cover creating databases in Access and working with the data by using tables, queries, forms, and reports.


Microsoft Access Training - Level 2

In our Microsoft Access 2010 Courses, Students will learn how to use complex query techniques, create efficient forms and reports, and create macros to automate their forms.


Microsoft Access Training - Level 3

In our Microsoft Access 2010 Courses, 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.

3 Steps to Master Microsoft Access 2010

01

Take a
course

02

Write an
Exam

03

Get
Certified

What you will learn
Microsoft Access 2010 Training Course

    Access 2010 - Level 1

    • Orientation Lesson Welcome to MastergradeIT
    • Lesson 1: Getting Started with Access 2010
    • Lesson 2: Building The Structure of a Database
    • Lesson 3: Managing Data in a Table
    • Lesson 4: Querying a Database
    • Lesson 5: Designing Forms
    • Lesson 6: Generating Reports
    • Lesson 7: Controlling Data Entry
    • Lesson 8: Joining Tables
    • Lesson 9: Creating Flexible Queries
    • Lesson 10: Improving Forms
    • Lesson 11: Customizing Reports
    • Lesson 12: Sharing Data Across Applications

Access 2010 - Level 2

  • Lesson 1: Structuring Existing Data
  • Lesson 2: Writing Advanced Queries
  • Lesson 3: Simplifying Tasks with Macros
  • Lesson 4: Creating Effective Reports
  • Lesson 5: Maintaining an Access Database

Access 2010 - Level 3

  • Lesson 1: Integrating Access into Your Business
  • Lesson 2: Automating a Business Process with VBA
  • Lesson 3: Managing Switchboards
  • Lesson 4: Distributing and Securing Databases
  • Lesson 5: Sharing Databases Using a SharePoint Site

Full course outline
Microsoft Access 2010 Training Course

Microsoft Access 2010 Level 1

Lesson 1: Getting Started with Access 2010

  • Identify the Elements of the Access 2010 Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
  • Enter Text in a Document

Lesson 2: Building The Structure of a Database

  • Create a New Database
  • Create a Table Using Design View
  • Modifying the Table Structure
  • Establish Table Relationships

Lesson 3: Managing Data in a Table

  • Modify Table Data
  • Sort and Filter Records
  • Work with Sub datasheets

Lesson 4: Querying a Database

  • Create a Query
  • Add Criteria to a Query
  • Add Illustrations to a Document
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Lesson 5: Designing Forms

  • Create a Form
  • Modify the Design of a Form
  • View and Add Data Using an Access Form

Lesson 6: Generating Reports

  • Create a Report
  • View an Access Report
  • Add a Calculated Field to a Report
  • Format the Controls in a Report
  • Apply a Theme to a Report
  • Prepare a Report for Print
Lesson 7: Controlling Data Entry

  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field

Lesson 8: Joining Tables

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

Lesson 9: Creating Flexible Queries

  • Retrieve Records Using Select Queries
  • Retrieve Records Based On Input Criteria
  • Manipulate Data Using Queries

Lesson 10: 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 11: Customizing Reports

  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report

Lesson 12: Sharing Data Across Applications

  • Import Data into Access
  • Export Data
  • Analyze Access Data in Excel
  • Export Query Results
  • Mail Merge Access Data With a Word Document

Microsoft Access 2010 Level 2

Lesson 1: Structuring Existing Data

  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure

Lesson 2: Writing Advanced Queries

  • Create SubQueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro

Lesson 4: Creating Effective Reports

  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as PDF

Lesson 5: Maintaining an Access Database

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Microsoft Access 2010 Level 3

Lesson 1: Integrating Access into Your Business

  • Import XML Data into an Access Database
  • Export Access Data to the XML Format
  • Export Data to an Outlook Address Book
  • Collect Data Through Email Messages

Lesson 2: Automating a Business Process with VBA

  • Create a Standard Module
  • Develop Code
  • Call a Procedure from a Form
  • Run a Procedure

Lesson 3: Managing Switchboards

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set the Startup Options

Lesson 4: Distributing and Securing Databases

  • Split a Database
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature

Lesson 5: Sharing Databases Using a SharePoint Site

  • Export a Table to a SharePoint List
  • Import Data from a SharePoint List
  • Publish a Database to a SharePoint Site
  • Move a Database to a SharePoint Site
  • Work Offline

Got a question?




Live Chat     OR CALL     +27 21 419 3213

Are you ready to become a Access 2010 expert?