Certificate In Access 2010 Essentials Online Course

Learn the Basic Features of Access 2010

Certificate In Access 2010 Essentials Online Course

NOW ONLY

RM799

Save RM300 (27%)
OFF RRP RM1099
Get Info Pack

Learn the Basic Features of Access 2010

Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. You will learn how to use the basic features of Access 2010.  Access is the world’s premier database software. You can use Access 2010 to create and edit databases, just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

By the end of this Access 2010 Essentials Online Short Course, you will be able to:

  • Understand common database terms
  • Open and close Access
  • Create a blank database or a database from a template
  • Understand the interface and the Ribbon tools
  • Understand the Backstage View
  • Use the Navigation Pane
  • Work with database objects
  • Sort and filter the view
  • Create a blank table from a template, in Datasheet view, and Design View
  • Use Lookup columns in a table
  • Add information to a table
  • Edit, delete and search records
  • Save a table
  • Create a Navigation Form
  • Create a form with the Wizard and in Layout View
  • Modify a form in Design View
  • Perform common formatting tasks on forms
  • Use Themes
  • Add or move controls on a form
  • Create reports using the Report Wizard
  • Understand the Report Design View
  • Add a Logo to a report
  • Create Queries using the Wizard
  • Execute a Query
  • Understand the Query Design View
  • Understand Access file formats and save a database as another file format
  • Print an Object
  • Back up the database
  • Email the database

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Other Microsoft Access Courses

Want to learn about Microsoft Access? Whether you're a beginner or an expert, Courses For Success has a range of Microsoft Access courses to suit your needs.

Please Note: We have included reviews from our Personal Success Program as we provide this free program with every course.

Module One: Getting Started

  • Course Objectives

Module Two: Getting Started With Access

  • Lesson One: Common Database Terms
  • Lesson Two: Opening Access
  • Lesson Three: Understanding the Access New File Screen
  • Lesson Four: Creating a Blank Access Database
  • Lesson Five: Creating a Blank Database from a Template

Module Three:  Using the Access Interface

  • Lesson One: Understanding Security Warnings
  • Lesson Two: Interface Overview
  • Lesson Three: Overview of the Ribbon Interface
  • Lesson Four: Working With the Backstage View
  • Lesson Five: Using the Navigation Pane

Module Four:  Working with Database Objects

  • Lesson One: Viewing Database Objects
  • Lesson Two: Exporting an Object
  • Lesson Three: Renaming an Object
  • Lesson Four: Sorting and Filtering Your View
  • Lesson Five: Understanding Application Parts

Module Five: Creating Tables

  • Lesson One: Understanding Data Types
  • Lesson Two: Creating a Blank Table in Datasheet View
  • Lesson Three: Understanding Lookup Columns
  • Lesson Four: Creating a Blank Table Using Design View
  • Lesson Five: Saving Your Table
  • Lesson Six: Key Table Tools

Module Six: Working with Tables

  • Lesson One: Adding Information to a Table
  • Lesson Two: Editing Records
  • Lesson Three: Deleting Records
  • Lesson Four: Searching for Records

Module Seven: Creating Forms

  • Lesson One: Types of Controls
  • Lesson Two: Creating a Form with the Wizard
  • Lesson Three: Creating a Form in Layout View
  • Lesson Four: Modifying Your Form in Design View
  • Lesson Five: Key Features on the Form Tools Tab
  • Lesson Six: Creating a Navigation Form

Module Eight: Working with Forms

  • Lesson One: Common Formatting Tasks
  • Lesson Two: Using Themes
  • Lesson Three: Adding Controls
  • Lesson Four: Moving Controls
  • Lesson Five: Deleting Records

Module Nine: Creating Reports

  • Lesson One: Using The Report Wizard
  • Lesson Two: Using Design View
  • Lesson Three: Adding a Logo
  • Lesson Four: Working with Controls
  • Lesson Five: Key Features on the Report Tools

Module Ten: Creating Queries

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Viewing the Query
  • Lesson Five: Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

  • Lesson One: Using Alternate File Formats
  • Lesson Two: Printing an Object
  • Lesson Three: Backing Up Your Database 
  • Lesson Four: Emailing Database Objects

Module Twelve: Wrapping Up
Words from the Wise

  • Store your data using Access tables.
  • Use forms to easily manage data collection tasks of adding, changing or deleting data one record at a time.
  • Create queries to see subsets of your data or to perform actions to your data.
  • Use reports to view table or query data in a polished format.

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

  • Adobe Acrobat Reader 

Customer Reviews

5 star
50%
4 star
31%
3 star
13%
2 star
5%
1 star
2%
(3367)
Average rating 4 out of 5 stars

20 October 2019 03:40:59 PM

very helpful!

19 October 2019 03:34:22 AM

Great Learning

18 October 2019 01:45:54 PM

very helpful to get a better understanding of concepts associated with Organisation.

18 October 2019 11:35:45 AM

quick and easy to follow

17 October 2019 01:08:10 AM

I am very happy to have done this course. very helpful information. Looking forward to the next course .

Tony Ashek

15 October 2019 03:53:09 PM

Lite and Easy

15 October 2019 02:21:24 PM

Can’t wait to use these skills to organize my business!

15 October 2019 12:17:08 PM

Went into this course thinking I already knew this subject. Wow was I surprised. Easy to listen to - made a person really think about goals and next steps. It was fantastic.

14 October 2019 05:12:39 AM

This course was most beneficial. I learned tips on becoming a more organized individual. The course was easily accessible. It offered opportunities to review materials and information that may have been unclear on a first read. The videos of case studies were excellent! The length of each video was great. I will use many of these organizational
tools in other areas of my personal life, such as creating a schedule for my pet. This course will help anyone who is willing to use the helpful hints and willing to exercise good organizational habits.

13 October 2019 03:56:37 AM

Enjoying learning this necessary information for personal success.

11 October 2019 05:42:28 PM

It has helped me learn self conr-wwwwwwwwwww'

10 October 2019 09:27:40 PM

The course is very informative and helped me to be more aware of goals,how to build confidence to achieve the goals and to be positive with every situation to get resolve.

9 October 2019 08:49:39 PM

It has helped me overcome procrastination and helped me get tasks done efficiently.

9 October 2019 01:40:08 PM

Excellent, Need I say any more.

5 October 2019 07:54:10 PM

I enjoyed this course, it is always good to look back and re-visit what was once learned and see where you can improve. Easy to follow and to the point.

5 October 2019 04:54:24 PM

The course helped me re-visit some forgotten techniques

5 October 2019 10:08:51 AM

great

5 October 2019 10:07:53 AM

awesome

5 October 2019 10:06:02 AM

awesome

4 October 2019 12:19:59 PM

excellent

Load more reviews Loading...
About this Course

Learn the Basic Features of Access 2010

Microsoft’s newest version of Access uses the new ribbon interface, and offers significant improvement to its database capability. You will learn how to use the basic features of Access 2010.  Access is the world’s premier database software. You can use Access 2010 to create and edit databases, just download a ready-made database template and start typing. It’s that easy. You can create a database of contacts, expenses, household and/or business inventory. In other words, if you have data, you can create a database of that data using Access.

By the end of this Access 2010 Essentials Online Short Course, you will be able to:

  • Understand common database terms
  • Open and close Access
  • Create a blank database or a database from a template
  • Understand the interface and the Ribbon tools
  • Understand the Backstage View
  • Use the Navigation Pane
  • Work with database objects
  • Sort and filter the view
  • Create a blank table from a template, in Datasheet view, and Design View
  • Use Lookup columns in a table
  • Add information to a table
  • Edit, delete and search records
  • Save a table
  • Create a Navigation Form
  • Create a form with the Wizard and in Layout View
  • Modify a form in Design View
  • Perform common formatting tasks on forms
  • Use Themes
  • Add or move controls on a form
  • Create reports using the Report Wizard
  • Understand the Report Design View
  • Add a Logo to a report
  • Create Queries using the Wizard
  • Execute a Query
  • Understand the Query Design View
  • Understand Access file formats and save a database as another file format
  • Print an Object
  • Back up the database
  • Email the database

Course Fast Facts:

  1. Easy to follow and understand
  2. Only 6 to 8 hours of study is required
  3. Unlimited, lifetime access to online course
  4. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  5. You can study from home or at work, at your own pace, in your own time
  6. Certificate of Completion

Course Delivery

Courses are accessed online via our learning management system by any device including PC, MAC, tablet or Smart Phone.

Recognition & Accreditation

This course is internationally recognized and accredited by the International Association of Online Training Standards (IAOTS). The courses offered by Courses For Success are unique as they are taught in a step by step process enabling students to complete them quickly and easily, so that you can obtain your qualification sooner. All students who complete the course receive a certificate of completion. Courses For Success is committed to high completion rates and therefore 100% student satisfaction.

Other Microsoft Access Courses

Want to learn about Microsoft Access? Whether you're a beginner or an expert, Courses For Success has a range of Microsoft Access courses to suit your needs.

Please Note: We have included reviews from our Personal Success Program as we provide this free program with every course.

Module One: Getting Started

  • Course Objectives

Module Two: Getting Started With Access

  • Lesson One: Common Database Terms
  • Lesson Two: Opening Access
  • Lesson Three: Understanding the Access New File Screen
  • Lesson Four: Creating a Blank Access Database
  • Lesson Five: Creating a Blank Database from a Template

Module Three:  Using the Access Interface

  • Lesson One: Understanding Security Warnings
  • Lesson Two: Interface Overview
  • Lesson Three: Overview of the Ribbon Interface
  • Lesson Four: Working With the Backstage View
  • Lesson Five: Using the Navigation Pane

Module Four:  Working with Database Objects

  • Lesson One: Viewing Database Objects
  • Lesson Two: Exporting an Object
  • Lesson Three: Renaming an Object
  • Lesson Four: Sorting and Filtering Your View
  • Lesson Five: Understanding Application Parts

Module Five: Creating Tables

  • Lesson One: Understanding Data Types
  • Lesson Two: Creating a Blank Table in Datasheet View
  • Lesson Three: Understanding Lookup Columns
  • Lesson Four: Creating a Blank Table Using Design View
  • Lesson Five: Saving Your Table
  • Lesson Six: Key Table Tools

Module Six: Working with Tables

  • Lesson One: Adding Information to a Table
  • Lesson Two: Editing Records
  • Lesson Three: Deleting Records
  • Lesson Four: Searching for Records

Module Seven: Creating Forms

  • Lesson One: Types of Controls
  • Lesson Two: Creating a Form with the Wizard
  • Lesson Three: Creating a Form in Layout View
  • Lesson Four: Modifying Your Form in Design View
  • Lesson Five: Key Features on the Form Tools Tab
  • Lesson Six: Creating a Navigation Form

Module Eight: Working with Forms

  • Lesson One: Common Formatting Tasks
  • Lesson Two: Using Themes
  • Lesson Three: Adding Controls
  • Lesson Four: Moving Controls
  • Lesson Five: Deleting Records

Module Nine: Creating Reports

  • Lesson One: Using The Report Wizard
  • Lesson Two: Using Design View
  • Lesson Three: Adding a Logo
  • Lesson Four: Working with Controls
  • Lesson Five: Key Features on the Report Tools

Module Ten: Creating Queries

  • Lesson One: Types of Queries
  • Lesson Two: Creating a Query with the Wizard
  • Lesson Three: Executing a Query
  • Lesson Four: Viewing the Query
  • Lesson Five: Key Features on the Query Tools Tab

Module Eleven: Managing Your Database

  • Lesson One: Using Alternate File Formats
  • Lesson Two: Printing an Object
  • Lesson Three: Backing Up Your Database 
  • Lesson Four: Emailing Database Objects

Module Twelve: Wrapping Up
Words from the Wise

  • Store your data using Access tables.
  • Use forms to easily manage data collection tasks of adding, changing or deleting data one record at a time.
  • Create queries to see subsets of your data or to perform actions to your data.
  • Use reports to view table or query data in a polished format.

Entry requirements

Students must have basic literacy and numeracy skills.

Minimum education

Open entry. Previous schooling and academic achievements are not required for entry into this course.

Computer requirements

Students will need access to a computer and the internet.

Minimum specifications for the computer are:

Windows:

  • Microsoft Windows XP, or later
  • Modern and up to date Browser (Internet Explorer 8 or later, Firefox, Chrome, Safari)

MAC/iOS

  • OSX/iOS 6 or later
  • Modern and up to date Browser (Firefox, Chrome, Safari)

All systems

  • Internet bandwidth of 1Mb or faster
  • Flash player or a browser with HTML5 video capabilities(Currently Internet Explorer 9, Firefox, Chrome, Safari)

Students will also need access the following applications:

  • Adobe Acrobat Reader 
(3367)
Average rating 4 out of 5 stars
5 star
50%
4 star
31%
3 star
13%
2 star
5%
1 star
2%

20 October 2019 03:40:59 PM

very helpful!

19 October 2019 03:34:22 AM

Great Learning

18 October 2019 01:45:54 PM

very helpful to get a better understanding of concepts associated with Organisation.

18 October 2019 11:35:45 AM

quick and easy to follow

17 October 2019 01:08:10 AM

I am very happy to have done this course. very helpful information. Looking forward to the next course .

Tony Ashek

15 October 2019 03:53:09 PM

Lite and Easy

15 October 2019 02:21:24 PM

Can’t wait to use these skills to organize my business!

15 October 2019 12:17:08 PM

Went into this course thinking I already knew this subject. Wow was I surprised. Easy to listen to - made a person really think about goals and next steps. It was fantastic.

14 October 2019 05:12:39 AM

This course was most beneficial. I learned tips on becoming a more organized individual. The course was easily accessible. It offered opportunities to review materials and information that may have been unclear on a first read. The videos of case studies were excellent! The length of each video was great. I will use many of these organizational
tools in other areas of my personal life, such as creating a schedule for my pet. This course will help anyone who is willing to use the helpful hints and willing to exercise good organizational habits.

13 October 2019 03:56:37 AM

Enjoying learning this necessary information for personal success.

11 October 2019 05:42:28 PM

It has helped me learn self conr-wwwwwwwwwww'

10 October 2019 09:27:40 PM

The course is very informative and helped me to be more aware of goals,how to build confidence to achieve the goals and to be positive with every situation to get resolve.

9 October 2019 08:49:39 PM

It has helped me overcome procrastination and helped me get tasks done efficiently.

9 October 2019 01:40:08 PM

Excellent, Need I say any more.

5 October 2019 07:54:10 PM

I enjoyed this course, it is always good to look back and re-visit what was once learned and see where you can improve. Easy to follow and to the point.

5 October 2019 04:54:24 PM

The course helped me re-visit some forgotten techniques

5 October 2019 10:08:51 AM

great

5 October 2019 10:07:53 AM

awesome

5 October 2019 10:06:02 AM

awesome

4 October 2019 12:19:59 PM

excellent

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only RM799 Save RM300 (27%)
OFF RRP RM1099
Delivery Method Online
Get Info Pack

Special Offer

 

Receive The Personal Success Training Program FREE, When You Purchase This Course - Limited Time Remaining!  (Value RM700)

 

The Personal Success Training Program Helps You Stay Focused To Achieve Your Goals!
Benefits:
  • How to layout a Success Plan.
  • Get where you want to be in life.
  • How to unclutter your mind to succeed.
  • Achieve your dreams using your imagination.
  • How to have faith in yourself.
Features:
  • 12 month online access,  24/7 anywhere.
  • Complement your individual course purchase.
  • Internationally recognized by the IAOTS.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Share this course

Course Summary

Course ID No.: 020A10ES
Delivery Mode: Online
Course Access: Lifetime Access
Time required: Study at your own pace
Course Duration: 6-8 Hours
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner