Call  086 999 0497

TTC

Microsoft Access courses

Microsoft Access

  Access Level 1 Course

Course Description

Microsoft Office Access Beginners will assist organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing date is by using relational databases. Information can be sorted, linked and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various object using the Microsoft Office Access relational database application.

 

Prerequisites

Good working knowledge of the Windows Operating System

This course is suitable for trainees new to Microsoft Access. After this Access course you will have a very good working knowledge of Microsoft Access, including how to design and build an efficient relational database, construct data fields and tables, run queries, design forms and build reports.

COURSE SCHEDULE

21 Oct   R2900 Book Quote
Request a Private Course

Hours are 08:30 to 16:00 unless specified otherwise

COURSE OUTLINE

Simple Database Techniques

1. Explore an Access 2010 Database

  • Working in Access 2010
  • Understanding Database Concepts
  • Exploring Tables
  • Exploring Forms
  • Exploring queries
  • Exploring Reports
  • Previewing and Printing Access Objects

 

2. Create Database and Simple Tables

  • Creating Databases from Templates
  • Creating Databases and Tables manually
  • Manipulating Table Columns and Rows
  • Refining Table Structure
  • Creating Relationships Between Tables

 

3. Create Simple Forms

  • Creating Forms by Using the Form Tool
  • Changing the Look of Forms
  • Changing the Arrangement of Forms

 

4. Display Data

  • Sorting Information in Tables
  • Filtering Information in Tables
  • Filtering Information by Using Forms
  • Locating Information That Matches Multiple Criteria

 

5. Create Simple Reports

  • Creating Reports by Using a Wizard
  • Modifying Report Design
  • Previewing and Printing Reports

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

  Access Level 2 Course

Course Description

Microsoft Office Access Intermediate will provide the basic skills needed to work with Microsoft Office Access database, including creating and working with Access tables, relationships, queries, forms and reports. But so far you have been focusing only on essentials database user skills. In this course, you will consider how to maintain data consistency, how to customize database components and how to share Access data with other applications.

 

Prerequisites

Microsoft Office Access: Beginners training or equivalent working knowledge

COURSE SCHEDULE

Request a Private Course

Hours are 08:30 to 16:00 unless specified otherwise

COURSE OUTLINE

Relational Database Techniques

1. Maintain Data Integrity

  • Restricting the Type of Data
  • Restricting the Amount of Data
  • Restricting the Format of Data
  • Restricting Data by Using Validating Rules
  • Restricting Data to Values in Lists
  • Restricting Data to Values in Other Tables

 

2. Create Custom Forms

  • Modifying Forms Created by Using a Wizard
  • Adding Controls
  • Adding Subforms
  • Using E-Mail forms to Collect Data

 

3. Create Queries

  • Creating Queries by Using a Wizard
  • Creating Queries Manually
  • Using Queries to Summarize Data
  • Using Queries to Perform Calculations
  • Using Queries to Updated Records
  • Using Queries to Delete Records

 

4. Create Custom Reports

  • Creating Reports Manually
  • Modifying Report Content
  • Adding Sub-reports

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

  Access Level 3 Course

Course Description

Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access . You have worked with the various Access objects, such as tables, queries, forms and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database.

 

Prerequisites

Microsoft Office Access: Beginners and Microsoft Office Access: Intermediate training or equivalent working knowledge

Sorry, we currently do not have any MS Access level 3 courses scheduled at this time. Please contact us to see if we can put one on the schedule for you.

COURSE OUTLINE

Database Management and Security

1. Import and Export Data

  • Importing Information
  • Exporting Information
  • Copying o and from Other Office Programs

 

2. Make Database User Friendly

  • Creating Navigation Forms
  • Creating Custom Categories
  • Controlling which Features are Available

 

3. Project Database

  • Assigning Passwords to Database
  • Splitting Databases
  • Securing Databases for Distribution
  • Preventing Database Problems

 

4. Customize Access

  • Changing Defaults Program Options
  • Customizing the Ribbon
  • Customizing the Quick Access Toolbar

 

Our outlines are a guide to the content covered on a typical course. We may change or alter the course topics to meet the objectives of a particular course.

Private Training?

Would you prefer to take a private Access course with one of our certified trainers?

We offer Access training:

From 1 to 100 delegates, On-site at your offices.

Group rates, Flexible dates, Customised courses & Ongoing support for Adobe Access

Private Course Request


Virtual Classroom

Live, Online instructor-led Access training.
Flexible dates and times to suit. All taught in real time wherever you are to individuals or groups.


Testimonials

If you would like to see our Access Testimonials, please either contact us directly or view our client list and their experiences with our company.

Microsoft Access courses
ACCESS COURSE INFORMATION

Which Access Course do I take?

We offer 3 Access courses. A beginner, intermediate and advanced. Each is 1-day. Please read the course outlines above to determine which is best for you. We recommend taking the next level course if you are knowledgable of at least 70% of the beginner course.

Microsoft Access Onsite Course Options

Wherever your office is located, we can come to you and deliver a private custom Access course. The larger the group the bigger the discount. However we also offer Access training for individuals, either at your offices or your home.

For on-site courses, you will need to have a computer with Access and if there are 3 or more delegates, a projection system is required for our Access instructor.

Microsoft Access Public Courses

Currently we offer Public Access courses in the Johannesburg, Cape Town, Durban, Gqeberha and Bloemfontein areas. We can however provide a private onsite course or of course an online Access course is also available

Access Online Courses

If you are unable to attend a public Access course, or simply prefer the convenience of an online course, these are regularly offered. For online Access courses you will need Access installed, an internet connection of 5MB/s or faster and a headset with a mic or use your laptop's built in mic and speakers. All Access course materials are provided digitally. The course is of course, live and fully interactive with engaging teaching.

Microsoft Access Private Course

Access users tend to use the product for specific purposes. We can tailor a course to meet your specific goals.

What else should I learn after my Access course?

Firstly, get the basics done. It is absolutely essential for you to have a good working knowledge of relational databases and Access. If you organization is using large amounts of data, you should consider moving to Microsoft SQL Server or MYSQL. If Access can handle all your data needs then taking the Access level 2 and level 3 courses is highly recommended.

Access training courses are available for all versions

Whether you are using the most recent Access version, or earlier releases such as Access 2010,2013,2016 or 2019, our Access training courses will help you learn the tools you use. When attending a public Access course, we will use the most recent versions for your Access course. If you wish to use an older version of Access for your training, simply let us know and we will work with you on that version. Our Access instructors have been teaching and developing courses for over 15 years, and are happy to address questions and deliver training on all versions of Access.

Access Training Courses from TTC

Microsoft Access is installed on most windows PC's where databases are required in small office environments. It is the least expensive and most accessible Database for windows. Our instructors have been using and teaching Access for over 20 years. Whether you are a beginner or advanced we can assit you.

Prerequisites for enrolling in Access public courses

For the beginner course, no previous experience is required. For the intermediate and advanced Access courses, we recommend using Access for at least 3 months or having attended the beginner course. If you are not sure which level would benefit you, please have a look at the course descriptions for each level. Most of our classrooms, are equipped with Windows computers for use during your Access training class. If you are an Access mac user, you are welcome to bring your Mac with with you. It is strongly recommended that you have a personal installation of Access to use directly after your training

Course materials for Access classes

All delegates receive digital materials which are the official Microsoft training manuals. Our instructors may provide addtional training lessons and information especially for custom courses

Access Certification Training

These Access courses are the perfect preparation to become a Microsoft Office Specialist

Access Class Reviews and Testimonials

Microsost Access is used by many small businesses. We will be happy to put in you in touch with some of our clients who have taken our Access courses.

Microsoft Logo
MS Access Logo
Access Logo

Access World Class Instructors

You can rely on the expertise of our Access instructors who have been teaching Access Training Classes over 15 years. Our trainers are developers too. It is essential to learn from professionals.

Access Course Support

When you attend our Access Training Course, all students receive class materials, a certificate on completion and 3 months support from our certified instructors.

Your Access Course is Guaranteed

We guarantee your Access Course and offer a full refund if you are not satisfied with your training experience. Just let us know within the first 2 hours of your Access class.