Certificate In Access 2013 Expert Online Course

Gain Skills to Become an Expert in Access 2013

Access 2013 Expert Online Short Course

NOW ONLY

₩167449

Save ₩56150 (25%)
OFF RRP ₩223599
Get Info Pack

Gain Skills to Become an Expert in Access 2013

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. This course is designed for the advanced users of Access 2013.

Access 2013 features a new framework that is designed for one purpose, to enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier for you.

This course covers everything from customizing your apps, to expert-level table, query, form, and report tasks. By the time you finish this course, you will be able to make the most out of Access 2013.

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

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

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

Module Two: Creating a Custom App

  • Lesson One: Creating a Custom Web App
  • Lesson Two: Adding a Template Table
  • Lesson Three: Adding a Blank Table
  • Lesson Four: Importing Access 2010 Tables

Module Three: Customizing App Actions

  • Lesson One: Adding a Custom Action
  • Lesson Two: Editing an Action
  • Lesson Three: Deleting a Custom Action

Module Four: Customizing Your App Views with Macros

  • Lesson One: About User Interface Macros
  • Lesson Two: Creating an Embedded Macro
  • Lesson Three: Creating a Standalone Macro
  • Lesson Four: Saving Your App as a Package

Module Five: Working with Validation Rules and Messages

  • Lesson One: About Restricting Data Input
  • Lesson Two: Creating a Field Validation Rule
  • Lesson Three: Creating a Record Validation Rule
  • Lesson Four: Testing Validation Rules

Module Six: Working with Macros

  • Lesson One: Creating Data Macros
  • Lesson Two: Creating a Named Macro
  • Lesson Three: Renaming or Deleting Macros
  • Lesson Four: Creating an AutoExec Macro

Module Seven: Advanced Query Tasks

  • Lesson One: Creating an Update Query
  • Lesson Two: Creating a Parameter Query
  • Lesson Three: About Joining Data Sources in a Query

Module Eight: Designing Forms

  • Lesson One: Modifying Your Form in Design View
  • Lesson Two: Working with Form Controls
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Adding Header and Footer Elements

Module Nine: Advanced Reporting Tasks

  • Lesson One: Using Report Design View
  • Lesson Two: Using Conditional Formatting
  • Lesson Three: Using the Group, Sort, and Total Pane
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Ten: Advanced Database Tools

  • Lesson One: Using the Database Documenter
  • Lesson Two: Analyzing Table Performance
  • Lesson Three: Analyzing Database Performance
  • Lesson Four: Compacting and Repairing a Database

Module Eleven:  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
  • Lesson Four: Setting Access Options

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. For students who do not have access to either a computer or 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%
(3153)
Average rating 4 out of 5 stars

15 August 2019 03:30:01 AM

I enjoyed this course, it was very empowering. Thank you David!

14 August 2019 12:29:27 AM

WONDERFUL!

13 August 2019 12:43:13 PM

Nice information

10 August 2019 02:00:35 PM

Love how details and encouraging it is

9 August 2019 04:19:38 PM

A good short course in the development of knowing thyself

8 August 2019 02:13:58 AM

I learned so much from this course

6 August 2019 08:57:48 PM

Awesome advice!! learnt alot from the videos very interesting facts also :)

1 August 2019 03:55:57 PM

A great learning experience

31 July 2019 05:56:14 PM

Great!

28 July 2019 04:42:44 AM

Very straight forward

27 July 2019 03:06:59 PM

Was sceptical when I received it, but it was amazing! everything my husband has been telling me and more, plus strategies to think about not only why I'm in the place I'm in now, but how to move forward and become successful in my own mind as well as my career.

Thank you

27 July 2019 11:46:53 AM

Great course!

26 July 2019 03:04:01 PM

great and informative

26 July 2019 12:48:40 PM

No Review

24 July 2019 07:27:38 PM

Great content

24 July 2019 12:31:45 AM

easy and straight forward

20 July 2019 10:26:23 PM

I thoroughly enjoyed this course. I found it easy to understand, gained confidence in applying it's advice in my daily life, and am always attempting to adopt the many great principles it teaches. Thank you very much David for delivering a very valuable course. And congratulations on the successes you and your family have had in business. And many more successes to you all in future. God Bless.

20 July 2019 12:19:49 PM

Great Course

19 July 2019 12:56:02 PM

Great Course

19 July 2019 09:08:54 AM

VERY USEFUL INFORMATION I LEARNED ALOT

Load more reviews Loading...
About this Course

Gain Skills to Become an Expert in Access 2013

This course is designed to teach you a deeper understanding of Access 2013 in a practical way. This course is designed for the advanced users of Access 2013.

Access 2013 features a new framework that is designed for one purpose, to enable users to create data-centric web applications. Taking the time to develop a deep understanding of Access 2013 will increase your knowledge on how databases work and make creating and managing an Access 2013 database easier for you.

This course covers everything from customizing your apps, to expert-level table, query, form, and report tasks. By the time you finish this course, you will be able to make the most out of Access 2013.

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

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

By the end of this course, you will be able to:

  • Create a custom app and use custom actions
  • Use macros in a custom app
  • Use validation rules and messages
  • Use macros in desktop databases
  • Perform advanced query tasks
  • Design custom forms
  • Perform advanced reporting tasks
  • Use advanced database tools
  • Customize the Access environment

Module Two: Creating a Custom App

  • Lesson One: Creating a Custom Web App
  • Lesson Two: Adding a Template Table
  • Lesson Three: Adding a Blank Table
  • Lesson Four: Importing Access 2010 Tables

Module Three: Customizing App Actions

  • Lesson One: Adding a Custom Action
  • Lesson Two: Editing an Action
  • Lesson Three: Deleting a Custom Action

Module Four: Customizing Your App Views with Macros

  • Lesson One: About User Interface Macros
  • Lesson Two: Creating an Embedded Macro
  • Lesson Three: Creating a Standalone Macro
  • Lesson Four: Saving Your App as a Package

Module Five: Working with Validation Rules and Messages

  • Lesson One: About Restricting Data Input
  • Lesson Two: Creating a Field Validation Rule
  • Lesson Three: Creating a Record Validation Rule
  • Lesson Four: Testing Validation Rules

Module Six: Working with Macros

  • Lesson One: Creating Data Macros
  • Lesson Two: Creating a Named Macro
  • Lesson Three: Renaming or Deleting Macros
  • Lesson Four: Creating an AutoExec Macro

Module Seven: Advanced Query Tasks

  • Lesson One: Creating an Update Query
  • Lesson Two: Creating a Parameter Query
  • Lesson Three: About Joining Data Sources in a Query

Module Eight: Designing Forms

  • Lesson One: Modifying Your Form in Design View
  • Lesson Two: Working with Form Controls
  • Lesson Three: Using the Property Sheet
  • Lesson Four: Adding Header and Footer Elements

Module Nine: Advanced Reporting Tasks

  • Lesson One: Using Report Design View
  • Lesson Two: Using Conditional Formatting
  • Lesson Three: Using the Group, Sort, and Total Pane
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Ten: Advanced Database Tools

  • Lesson One: Using the Database Documenter
  • Lesson Two: Analyzing Table Performance
  • Lesson Three: Analyzing Database Performance
  • Lesson Four: Compacting and Repairing a Database

Module Eleven:  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
  • Lesson Four: Setting Access Options

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. For students who do not have access to either a computer or 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 
(3153)
Average rating 4 out of 5 stars
5 star
49%
4 star
31%
3 star
13%
2 star
5%
1 star
2%

15 August 2019 03:30:01 AM

I enjoyed this course, it was very empowering. Thank you David!

14 August 2019 12:29:27 AM

WONDERFUL!

13 August 2019 12:43:13 PM

Nice information

10 August 2019 02:00:35 PM

Love how details and encouraging it is

9 August 2019 04:19:38 PM

A good short course in the development of knowing thyself

8 August 2019 02:13:58 AM

I learned so much from this course

6 August 2019 08:57:48 PM

Awesome advice!! learnt alot from the videos very interesting facts also :)

1 August 2019 03:55:57 PM

A great learning experience

31 July 2019 05:56:14 PM

Great!

28 July 2019 04:42:44 AM

Very straight forward

27 July 2019 03:06:59 PM

Was sceptical when I received it, but it was amazing! everything my husband has been telling me and more, plus strategies to think about not only why I'm in the place I'm in now, but how to move forward and become successful in my own mind as well as my career.

Thank you

27 July 2019 11:46:53 AM

Great course!

26 July 2019 03:04:01 PM

great and informative

26 July 2019 12:48:40 PM

No Review

24 July 2019 07:27:38 PM

Great content

24 July 2019 12:31:45 AM

easy and straight forward

20 July 2019 10:26:23 PM

I thoroughly enjoyed this course. I found it easy to understand, gained confidence in applying it's advice in my daily life, and am always attempting to adopt the many great principles it teaches. Thank you very much David for delivering a very valuable course. And congratulations on the successes you and your family have had in business. And many more successes to you all in future. God Bless.

20 July 2019 12:19:49 PM

Great Course

19 July 2019 12:56:02 PM

Great Course

19 July 2019 09:08:54 AM

VERY USEFUL INFORMATION I LEARNED ALOT

Load more reviews Loading...

We provide a 7 Day Money Back Refund on all Courses

Now Only ₩167449 Save ₩56150 (25%)
OFF RRP ₩223599
Delivery Method Online
Get Info Pack

Special Offer

 

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

 

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.: 020A13EX
Delivery Mode: Online
Course Access: Lifetime Course 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