IT Training South Afica

Microsoft Access 2010 Training Courses South Africa - Optimize your job skills.

Complete this form for the Latest Pricing Information and Dates!

Course in CBD to study classroom instructor led beginners to advanced.Logo

Available Study Methods:

1. Classroom Instructor Led
2. Online Courses
3. On-site Training for 5-15 people attending

Overview:
Take control of your data with Microsoft Access relational database software training. Our Access courses will teach you basic to advanced   features.
Whether you are new to Access or an advanced user, our training will cover what you need to know as efficiently as possible.    

Prerequisite Comments:
Students should be familiar with using personal computers and have used a mouse and keyboard.
Specifically, students should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.

Cape Town Instructor led training Contact us


 

New Features of Microsoft Access 2010 With this training, the student will learn:
 - New Data Type Gallery                                                 - Creating and designing database solutions
 - Reporting themes  - Working with  tables, relationships, keys and constraints
 - Table macros - similar to table triggers  - Querying data
 - Improved  macro functionality  - Managing and designing interfaces with Forms
 - Web-ready database format  - Create basic to advanced  Reports

 

Level 1 - Class Outline

Level 2 - Class Outline

Level 3 - Class Outline


ACCESS 2010 - Level 1 - Class Outline

Duration - 2 Days

Traditional Instructor Led Learning

Overview:
Students will create and modify new databases and their various objects. Students will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2010 with other applications.

Who Should Attend:
This training is designed for students who wish to learn the basic 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. This is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance applications.

 

Lesson 1: Getting Started with Access 2010  Lesson 7 Controlling Data Entry     
  • Identify the Elements of the Access 2010 Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process
  • Constrain Data Entry Using Field Properties
  • Establish Data Entry Formats for Entering Field Values
  • Create a List of Values for a Field
 Lesson 2: Building The Structure of a Database  Lesson 8: Joining Tables
  • Create a New Database
  • Create a Table Using Design View
  • Modifying the Table Structure
  • Establish Table Relationships
  • Create Query Joins
  • Join Unrelated Tables
  • Relate Data Within a Table
 Lesson 3: Managing Data in a Table  Lesson 9: Creating Flexible Queries
  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets
  • Retrieve Records Using Select Queries
  • Retrieve Records Based On Input Criteria
  • Manipulate Data Using Queries
Lesson 4: Querying a Database Lesson 10: Improving Forms
  • Create a Query Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
  • 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: Designing Forms Lesson 11: Customizing Reports
  • Create a Form
  • Modify the Design of a Form
  • View and Add Data Using an  Form
  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
Lesson 6: Generating Reports Lesson 12: Sharing Data Across Applications
  • Create a Report
  • View an 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
  • Import Data 
  • Export Data
  • Analyze  Data in Excel
  • Export Query Results
  • Mail Merge  Data With a Word Document

ACCESS 2010 - Level 2 - Class Outline

Duration: 2 Days

Traditional Instructor Led Learning 

Overview:
Students will create complex databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Who Should Attend:
This is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

 

Lesson 1: Structuring Existing Data  Lesson 4 : Creating Effective Reports
  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as PDF
Lesson 2: Writing Advanced Queries Lesson 5: Maintaining an Access Database
  • 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
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database
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

 

ACCESS 2010 - Level 3 - Class Outline

Duration: Traditional Instructor Led Learning - 1 Day

Overview: 
Students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases. 

Who Should Attend:
This course is designed for students who have a thorough understanding of the basic and advanced user features of the Microsoft® Office Access® 2010 application, and are interested in learning introductory level administrator skill sets. The course is also for students who may be working in a web-based environment and may need to adapt Access applications to the environment.

Prerequisite(s) or equivalent knowledge:

Access 2010 - Level 1
Access 2010 - Level 2

Lesson 1: Integrating Access into Your Business  Lesson 4: Distributing and Securing Databases
  • 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
  • Split a Database
  • Implement Security
  • Set Passwords
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
Lesson 2: Automating a Business Process with VBA Lesson 5: Sharing Databases Using a SharePoint Site
  • Create a Standard Module
  • Develop Code
  • Call a Procedure from a Form
  • Run a Procedure
  • 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
Lesson 3: Managing Switchboards
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set the Startup Options

 

 

IT courses Cape Town to study full time or part time. Access Database Administrator jobs will always require the skills gained in this course. Consider adding this to your CV. Cape Town