100 megs data gift for every genuine quote requested

Having the basic skills required to interact with an MS Access 2010 database is essential for many roles in today’s business world. Knowing how to use this powerful software can improve your job opportunities and income potential.

The MS Access 2010 Beginner-Intermediate Training Course provides you with an understanding of the basic features of Access 2010, including database tables and joins, forms, data entry, SQL queries and generating reports. The course is designed to empower users to use Access 2010 to fulfil basic tasks.

This dynamic training course is now available in Gauteng, Durban and Cape Town.

Contact us today for a group quote.

Excel

Word

PowerPoint

Outlook

Access

Project

Who Should Attend

This course is for students with no prior knowledge of Microsoft Access or relational databases and is designed to teach you the concepts and structure for building an Access database.

During this course, you will learn how to build tables to store data, create forms for data entry, create and run queries to analyse data and produce printable reports.

If you have inherited an Access database that you have to learn how to manage and maintain or just need to know how to work with an Access database, then this course is for you.

At the completion of this course, students will gain an understanding of the concepts and terminology used throughout Microsoft Access.

Students will also be able to build a basic database, manipulate the data and create basic queries, forms and reports.

Learning Outcomes - Microsoft Access 2010 Beginner Training Course

  • Navigate within the Microsoft Access application environment and create a simple database.
  • Organise and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Create advanced queries, including action queries, parameter queries, Pivot Tables, and Pivot Charts.
  • Create and format custom reports.
  • Customise Access configuration options.
  • Use comparison operators & calculations in queries
  • Create & modify forms
  • Create reports
  • Group & summarise data in a report
  • Print a report

Course Content - Microsoft Access 2010 Beginner Training Course

Lesson 1: Getting Started with Access 2010
Topic A: Identify the Elements of the User Interface
Topic B: Identify the Tabs and Commands on the Ribbon
Topic C: Obtain Help in Access

Lesson 2: Identifying the Components of a Database
Topic A: Define Database Concepts
Topic B: Identify the Components of a Database
Topic C: Examine the Relational Database Design Process

Lesson 3: Organising Data in Tables
Topic A: Create a Table
Topic B: Modify Table Data and Properties
Topic C: Create a Table Relationship

Lesson 4: Viewing Data in Tables
Topic A: Sort Records
Topic B: Filter Records
Topic C: View Data from Related Tables

Lesson 5: Querying a Database
Topic A: Create a Query
Topic B: Add Criteria to a Query
Topic C: Add a Calculated Field to a Query
Topic D: Perform Calculations on a Record Grouping

Lesson 6: Designing Forms
Topic A: Create a Form
Topic B: View Data Using an Access Form
Topic C: Modify a Form

Lesson 7: Generating Reports
Topic A: View an Access Report
Topic B: Create a Report
Topic C: Add a Calculated Field to a Report
Topic D: Format the Controls in a Report
Topic E: Apply a Theme to a Report
Topic F: Prepare a Report for Print