Certificate In Access 2010 Expert Online Course

Acquire Expert Skills in Access 2010

Certificate In Access 2010 Expert Online Course

NOW ONLY

AU$199

Save AU$70 (26%)
OFF RRP AU$269
Get Info Pack

Acquire Expert Skills in Access 2010

You will learn how to use the advanced features of Access 2010. This course is designed to go beyond a basic understanding and to explore the more advanced features of Access 2010 in a practical way.

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with queries, and publish a Web database among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro.

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

  • Work with Database Properties
  • Encrypt a database with a password
  • Save an object
  • Set general, current database, datasheet, object designers, proofing, and language options
  • Customize the Ribbon and the Quick Access toolbar
  • Hide/unhide and freeze/unfreeze fields in a table
  • Modify field descriptions and properties
  • Append records to an existing table
  • Import data as a linked table
  • Understand linked table errors
  • Create a select query
  • Create a make table query
  • Create an append query
  • Create a cross tab query
  • Show or remove tables on the query designer window
  • Create an update query
  • Create a parameter query
  • Compare two tables using a join
  • Create a blank form
  • Use form controls
  • Create headers and footers on forms or reports
  • Use Form Design, Report Design, and Macro Design tools
  • Use background images
  • Use themes
  • Use conditional formatting
  • Create a navigation form
  • Create a blank report
  • Use the Property Sheet
  • Create a user-interface or a data macro
  • Understand the Action catalog
  • Understand the use of Visual Basic for Applications to extend Access functionality

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

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: Working with the Access Environment

  • Lesson One: Working with Database Properties
  • Lesson Two: Encrypting a Database with a Password
  • Lesson Three: Using Save Object As

Module Three: Working with Access Options (I)

  • Lesson One: Setting General Options
  • Lesson Two: Setting Application Options
  • Lesson Three: Setting Navigation and Other Options
  • Lesson Four: Setting Datasheet Options

Module Four: Working with Access Options (II)

  • Lesson One: Setting Object Designers Options
  • Lesson Two: Setting Proofing and Language Options
  • Lesson Three: Setting Client Settings Options
  • Lesson Four: Customizing the Ribbon
  • Lesson Five: Customizing the Quick Access Toolbar

Module Five: Working with Tables

  • Lesson One: Hiding and Unhiding Fields
  • Lesson Two: Freezing and Unfreezing Fields
  • Lesson Three: Modifying Data Types
  • Lesson Four: Modifying Field Descriptions
  • Lesson Five: Modifying Field Properties

Module Six: Importing Table Data

  • Lesson One: Appending Records to an Existing Table
  • Lesson Two: Importing Data as a Linked Table
  • Lesson Three: About Linked Table Troubleshooting

Module Seven: Working with Queries (I)

  • Lesson One: Creating a Select Query
  • Lesson Two: Creating a Make Table Query
  • Lesson Three: Creating an Append Query
  • Lesson Four: Creating a Cross Tab Query

Module Eight: Working with Queries (II)

  • Lesson One: Showing or Removing Tables
  • Lesson Two: Creating an Update Query
  • Lesson Three: Creating a Parameter Query
  • Lesson Four: Comparing Two Tables by Using a Join

Module Nine: Working with Forms

  • Lesson One: Creating a Blank Form
  • Lesson Two: Using Form Controls
  • Lesson Three: Creating a Header and Footer
  • Lesson Four: Using the Form Design Arrange and Format Tools
  • Lesson Five: Using a Background Image
  • Lesson Six: Using Themes
  • Lesson Seven: Using Conditional Formatting
  • Lesson Eight: Creating a Navigation Form

Module Ten: Using Reports

  • Lesson One: Creating a Blank Report
  • Lesson Two: Creating a Header and Footer
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Using the Report Layout Tabs

Module Eleven: Using Macros and Code

  • Lesson One: About Macros
  • Lesson Two: Creating a User-Interface Macro
  • Lesson Three: Creating a Data Macro
  • Lesson Four: Working With the Macro Tools Design Tab
  • Lesson Five: Working with the Action Catalog
  • Lesson Six: About Visual Basic
  • Lesson Seven: About Modules

Module Twelve: Wrapping Up

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
49%
4 star
31%
3 star
13%
2 star
5%
1 star
2%
(3313)
Average rating 4 out of 5 stars

23 October 2019 12:16:51 PM

Great course. made a lot of sense. Useful for me.

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

Load more reviews Loading...
About this Course

Acquire Expert Skills in Access 2010

You will learn how to use the advanced features of Access 2010. This course is designed to go beyond a basic understanding and to explore the more advanced features of Access 2010 in a practical way.

You can use advanced forms and tasks to do even more in Access than you have previously learned. For example, you can use Access to create mailing labels, work with queries, and publish a Web database among other things. By the time you finish this course, you will be able to navigate Access 2010 and create reports like a pro.

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

  • Work with Database Properties
  • Encrypt a database with a password
  • Save an object
  • Set general, current database, datasheet, object designers, proofing, and language options
  • Customize the Ribbon and the Quick Access toolbar
  • Hide/unhide and freeze/unfreeze fields in a table
  • Modify field descriptions and properties
  • Append records to an existing table
  • Import data as a linked table
  • Understand linked table errors
  • Create a select query
  • Create a make table query
  • Create an append query
  • Create a cross tab query
  • Show or remove tables on the query designer window
  • Create an update query
  • Create a parameter query
  • Compare two tables using a join
  • Create a blank form
  • Use form controls
  • Create headers and footers on forms or reports
  • Use Form Design, Report Design, and Macro Design tools
  • Use background images
  • Use themes
  • Use conditional formatting
  • Create a navigation form
  • Create a blank report
  • Use the Property Sheet
  • Create a user-interface or a data macro
  • Understand the Action catalog
  • Understand the use of Visual Basic for Applications to extend Access functionality

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

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: Working with the Access Environment

  • Lesson One: Working with Database Properties
  • Lesson Two: Encrypting a Database with a Password
  • Lesson Three: Using Save Object As

Module Three: Working with Access Options (I)

  • Lesson One: Setting General Options
  • Lesson Two: Setting Application Options
  • Lesson Three: Setting Navigation and Other Options
  • Lesson Four: Setting Datasheet Options

Module Four: Working with Access Options (II)

  • Lesson One: Setting Object Designers Options
  • Lesson Two: Setting Proofing and Language Options
  • Lesson Three: Setting Client Settings Options
  • Lesson Four: Customizing the Ribbon
  • Lesson Five: Customizing the Quick Access Toolbar

Module Five: Working with Tables

  • Lesson One: Hiding and Unhiding Fields
  • Lesson Two: Freezing and Unfreezing Fields
  • Lesson Three: Modifying Data Types
  • Lesson Four: Modifying Field Descriptions
  • Lesson Five: Modifying Field Properties

Module Six: Importing Table Data

  • Lesson One: Appending Records to an Existing Table
  • Lesson Two: Importing Data as a Linked Table
  • Lesson Three: About Linked Table Troubleshooting

Module Seven: Working with Queries (I)

  • Lesson One: Creating a Select Query
  • Lesson Two: Creating a Make Table Query
  • Lesson Three: Creating an Append Query
  • Lesson Four: Creating a Cross Tab Query

Module Eight: Working with Queries (II)

  • Lesson One: Showing or Removing Tables
  • Lesson Two: Creating an Update Query
  • Lesson Three: Creating a Parameter Query
  • Lesson Four: Comparing Two Tables by Using a Join

Module Nine: Working with Forms

  • Lesson One: Creating a Blank Form
  • Lesson Two: Using Form Controls
  • Lesson Three: Creating a Header and Footer
  • Lesson Four: Using the Form Design Arrange and Format Tools
  • Lesson Five: Using a Background Image
  • Lesson Six: Using Themes
  • Lesson Seven: Using Conditional Formatting
  • Lesson Eight: Creating a Navigation Form

Module Ten: Using Reports

  • Lesson One: Creating a Blank Report
  • Lesson Two: Creating a Header and Footer
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Using the Report Layout Tabs

Module Eleven: Using Macros and Code

  • Lesson One: About Macros
  • Lesson Two: Creating a User-Interface Macro
  • Lesson Three: Creating a Data Macro
  • Lesson Four: Working With the Macro Tools Design Tab
  • Lesson Five: Working with the Action Catalog
  • Lesson Six: About Visual Basic
  • Lesson Seven: About Modules

Module Twelve: Wrapping Up

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 
(3313)
Average rating 4 out of 5 stars
5 star
49%
4 star
31%
3 star
13%
2 star
5%
1 star
2%

23 October 2019 12:16:51 PM

Great course. made a lot of sense. Useful for me.

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

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only AU$199 Save AU$70 (26%)
OFF RRP AU$269
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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.: 020A10EX
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