Microsoft Office And Access 2010 Advanced Online Bundle, 3 Certificate Courses

Learn Advanced Skills in Access 2010

Microsoft Office And Access 2010 Advanced Online Bundle, 3 Certificate Courses

NOW ONLY

£225

Save £449 (67%)
OFF RRP £674
Get Info Pack

Get Access 2010 Advanced, Access 2010 Essentials and Access 2010 Expert in this Bundle

1. Access 2010 Advanced: Learn Advanced Skills in Access 2010

You will learn how to use the advanced features of Access 2010. This course is designed to teach you a basic understanding of Access 2010 in a practical way. This course incorporates a hands-on approach to learning.

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 SQL, 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 Advanced Online Short Course, you will be able to:

  • Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
  • Add, move, remove and format both regular and calculated controls
  • Set the Primary Key
  • Create a subform, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
  • Group and sort data
  • Understand, view and edit relationships
  • Understand and establish referential integrity
  • Sort and filter a query
  • Add calculated fields
  • Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
  • Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
  • Use the Database Documenter, analyze table and database performance and repair and compact a database

2. Access 2010 Essentials: 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

3. Access 2010 Expert: 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

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

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.

Receive Lifetime Access to Course Materials, so you can review at any time.

Microsoft Office And Access 2010 Advanced Bundle, 3 Courses includes the following courses, below is a summary of each course: 

Course 1 - Access 2010 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: Advanced Table Tasks

  • Lesson One: Using the Quick Start Group
  • Lesson Two: Using the Property Sheet
  • Lesson Three: Adding, Moving, and Removing Controls
  • Lesson Four: Formatting Controls
  • Lesson Five: Setting the Primary Key
  • Lesson Six: Using Table Macros

Module Three: Advanced Form Tasks

  • Lesson One: Creating a Sub Form
  • Lesson Two: Creating a Web Form
  • Lesson Three: Creating a Split Form

Module Four: Advanced Reporting Tasks 

  • Lesson One: Using Report Sections
  • Lesson Two: Using Conditional Formatiting
  • Lesson Three: Grouping & Sorting Data
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Five: Understanding Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Editing Relationships
  • Lesson Four: About Referential Integrity
  • Lesson Five: Establishing Referential Integrity

Module Six: Advanced Query Tasks

  • Lesson One: Sorting and Filtering a Query
  • Lesson Two: Adding Calculated Fields
  • Lesson Three: Using the Expression Builder

Module Seven: Working with SQL

  • Lesson One: What is SQL?
  • Lesson Two: Basic SQL Syntax

Module Eight: Linking Data

  • Lesson One: Linking to an Excel Spreadsheet
  • Lesson Two: Linking to an Access Database
  • Lesson Three: Linking to a SharePoint List

Module Nine: Importing Data

  • Lesson One: Importing From an Excel Spreadsheet
  • Lesson Two: Importing From an Access Database
  • Lesson Three: Importing from a SharePoint List

Module Ten: Exporting Data

  • Lesson One: Saving an Object as a PDF
  • Lesson Two: Exporting To an Excel Spreadsheet
  • Lesson Three: Exporting to a SharePoint List

Module Eleven: Advanced Database Tools

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

Module Twelve: Wrapping Up

Course 2 - Access 2010 Essentials

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

Course 3 - Access 2010 Expert

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

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

About this Course

Get Access 2010 Advanced, Access 2010 Essentials and Access 2010 Expert in this Bundle

1. Access 2010 Advanced: Learn Advanced Skills in Access 2010

You will learn how to use the advanced features of Access 2010. This course is designed to teach you a basic understanding of Access 2010 in a practical way. This course incorporates a hands-on approach to learning.

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 SQL, 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 Advanced Online Short Course, you will be able to:

  • Use the Quick Start group, Property Sheet, table macros, report sections, conditional formatting, Expression Builder and logical functions.
  • Add, move, remove and format both regular and calculated controls
  • Set the Primary Key
  • Create a subform, Web form, split form, modal dialog, PivotChart, PivotTable and mailing labels
  • Group and sort data
  • Understand, view and edit relationships
  • Understand and establish referential integrity
  • Sort and filter a query
  • Add calculated fields
  • Understand what SQL is, what SQL statements are, basic SQL syntax and the uses for SQL within Access 2010
  • Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports
  • Use the Database Documenter, analyze table and database performance and repair and compact a database

2. Access 2010 Essentials: 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

3. Access 2010 Expert: 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

Receive Lifetime Access to Course Materials, so you can review at any time.

For comprehensive information on units of study click the units of study tab above.

This is an incredible opportunity to invest in yourself and your future, sharpen your training skills and learn what it takes to create your own success with Courses For Success Today!

Course Fast Facts:

  1. All courses are easy to follow and understand
  2. Only 6 to 8 hours of study is required per course
  3. Unlimited lifetime access to course materials
  4. Study as many courses as you want
  5. Delivered 100% on-line and accessible 24/7 from any computer or smartphone
  6. You can study from home or at work, at your own pace, in your own time
  7. Certificates

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.

Receive Lifetime Access to Course Materials, so you can review at any time.

Microsoft Office And Access 2010 Advanced Bundle, 3 Courses includes the following courses, below is a summary of each course: 

Course 1 - Access 2010 Advanced

Module One: Getting Started

  • Course Objectives

Module Two: Advanced Table Tasks

  • Lesson One: Using the Quick Start Group
  • Lesson Two: Using the Property Sheet
  • Lesson Three: Adding, Moving, and Removing Controls
  • Lesson Four: Formatting Controls
  • Lesson Five: Setting the Primary Key
  • Lesson Six: Using Table Macros

Module Three: Advanced Form Tasks

  • Lesson One: Creating a Sub Form
  • Lesson Two: Creating a Web Form
  • Lesson Three: Creating a Split Form

Module Four: Advanced Reporting Tasks 

  • Lesson One: Using Report Sections
  • Lesson Two: Using Conditional Formatiting
  • Lesson Three: Grouping & Sorting Data
  • Lesson Four: Adding Calculated Controls
  • Lesson Five: Creating Labels

Module Five: Understanding Relationships

  • Lesson One: Types of Relationships
  • Lesson Two: Viewing Relationships
  • Lesson Three: Editing Relationships
  • Lesson Four: About Referential Integrity
  • Lesson Five: Establishing Referential Integrity

Module Six: Advanced Query Tasks

  • Lesson One: Sorting and Filtering a Query
  • Lesson Two: Adding Calculated Fields
  • Lesson Three: Using the Expression Builder

Module Seven: Working with SQL

  • Lesson One: What is SQL?
  • Lesson Two: Basic SQL Syntax

Module Eight: Linking Data

  • Lesson One: Linking to an Excel Spreadsheet
  • Lesson Two: Linking to an Access Database
  • Lesson Three: Linking to a SharePoint List

Module Nine: Importing Data

  • Lesson One: Importing From an Excel Spreadsheet
  • Lesson Two: Importing From an Access Database
  • Lesson Three: Importing from a SharePoint List

Module Ten: Exporting Data

  • Lesson One: Saving an Object as a PDF
  • Lesson Two: Exporting To an Excel Spreadsheet
  • Lesson Three: Exporting to a SharePoint List

Module Eleven: Advanced Database Tools

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

Module Twelve: Wrapping Up

Course 2 - Access 2010 Essentials

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

Course 3 - Access 2010 Expert

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

1.  Who are Courses For Success?

Courses For Success is a global course platform that started in 2008 with 5 courses, since then we have grown to over 10,000 online courses. As our courses are delivered online via the internet, we sell our courses worldwide.

Our courses span across many categories including Academic, Animal, Beauty, Business, Career, Counseling, Creative & Media, Health & Therapy, Hobbies & Trades, IT, Personal Development, Sports & Fitness.

Some of the companies we work with include Groupon, Living Social, CNN, Entrepreneur, Mashable, Reed UK, Stack Social and many more.

2.  Is there a refund/cancellation policy?

Yes, we have a 7-day money-back refund guarantee. Just send us an email to email/info)(coursesforsuccess.com with the subject Courses For Success Refund so we can accommodate your request.

3.  What is the FREE Personal Success Training Program?

The Personal Success Training Program was developed by Courses For Success to help our customers achieve success. Currently, we are offering this program for FREE with every course or bundle purchase this month. This is a limited time offer! We have received thousands of reviews for this program, please see: Personal Success Training Program Reviews

4.  Are there any requirements to study this course?

No, anyone who has an interest in learning more about this subject matter is encouraged to take our course. There are no entry requirements to take this course.

5.  Do I require to have finished high school to complete this course?

No, you do not require a High School Diploma or to have finished school to study this course, this course is open to anyone who would like to take this course.

6.  What if English is not my first language?

This course is provided in English, however, due to the digital nature of our training, you can take your time studying the material and make use of tools such as google translate and Grammarly.

7.  Is this course online or conducted in person?

All our courses are accessible online on any device. You may complete them at your own pace and at your own time.

8.  How do I receive my course?

After you have completed the payment, you will receive a confirmation email and tax receipt. You will also receive an email containing your course login details (username and password), as well as instructions on how to access and log in to your course via the internet with any device, please check your junk/spam folder in the event that you do not receive the email.

9.  When does this course start?

Providing you have internet access you can start this course whenever you like, just go to the login page and insert your username and password and you can access the online material.

10.  What is online learning like?

Online learning is easy, if not easier than a traditional academic situation. By studying an online course, the usual boundaries caused by location and time constraints are eliminated, meaning you are free to study where and when you want at your own pace. Of course, you will need to be able to self-manage your time and be organized, but with our help, you’ll soon find yourself settling into a comfortable rhythm of study.

11.  What computer skills do I need for my course?

You don't need to be a computer expert to succeed with our online training, but you should be comfortable typing, using the internet and be capable of using common software (such as Microsoft word).

12.  How long will you have access to the online course?

There is no time limit for completing this course, it can be studied in your own time at your own pace. Once you have purchased this course you will have unlimited lifetime access, meaning you can access this course whenever you want.

13.  How long will my course take?

Individual courses are designed to be completed within 6-8 hours.

If you choose a course bundle, simply multiply the above hours by the number of courses included in the bundle.
For example:

  • 2 course bundle is 2 x 6-8 hours = 12-16 hours
  • 3 course bundle is 3 x 6-8 hours = 18-24 hours
  • 5 course bundle is 5 x 6-8 hours = 30-40 hours
  • 10 course bundle is 10 x 6-8 hours = 60-80 hours
14.  Do I need to buy textbooks?

All the required material for your course is included in the online system, you do not need to buy anything else.

15.  Is the course interactive?

Yes, all our courses are interactive.

16.  Is there an assessment or exam?

Yes, you will be required to complete a multiple-choice test online at the end of your course, you can do this test as many times as you require.

17.  What type of certificate will I receive?

You will receive a Certificate of Completion that is applicable worldwide, which demonstrates your commitment to learning new skills. You can share the certificate with your friends, relatives, co-workers and employers. Also, include it in your resume/CV, professional social media profiles and job applications.

Wendy Sue Hunt - 5 STAR REVIEW
"If you are considering taking any “Courses for Success”, I would highly recommend it. I have always been a firm believer it’s important to always sharpen your skills. You are never too old to learn more. I found the courses very helpful, interesting and easy to understand.
The term “Courses for Success” helped me in my current position to succeed. After completing the courses, I gave my manager the completion certificates. Recently I received a promotion too."
Valencia Marie Aviles - 5 STAR REVIEW
"I had a very good experience with my course. It has helped me to get multiple jobs and prepared me for almost everything I would need to know. The course was very informative and easy to understand and broken up perfectly to be done in a short amount of time while still learning a good amount! I would recommend Courses for Success to anyone trying to get abs certifications for job advancements, it is well worth it!"
ELENA GRIFFIN - 5 STAR REVIEW
"I have absolutely enjoyed the materials from Courses for Success. The materials are easy to understand which makes learning enjoyable. Courses for Success have great topics of interest which make you come back for more.
Thank you Courses for Success for being part of my learning journey and making education affordable!"

Our completion certificates are very valuable and will help you progress in your work environment and show employers how committed you are to learn new skills, you might even get a promotion.

18.  Will this course be credited by universities?

No, it is not equivalent to a college or university credit.

19.  Am I guaranteed to get a job with this certificate?

This course will give you the skills you need to help you obtain employment, but it’s up to you if you get the job or not.

20.  How will this course assist me with my career?

Studying and completing this course will show employers that you have the knowledge in this field, additionally you will gain more confidence in this area of expertise.

21.  How long is the certificate valid for?

The Certificates are valid for life and do not need renewing. 

22.  Can I take more than one course at a time?

Courses are studied online at your own pace and you are free to study as many or as few courses as you wish, we also offer online course bundles that allow you to save on additional courses so that you may get all the topics related to your training goals in one go.

23.  What are the Payment Methods available? Is there a payment plan?

We accept payments via PayPal, Credit Card, Bank Transfer and Amazon Pay for the USA. For payment plans, we offer Sezzle for USA & Canada, Afterpay for Australia & New Zealand. *For faster transaction Credit Card payments are preferred. Please purchase online via our website course product page or contact us at email/info)(coursesforsuccess.com, to pay via bank transfer.

24.  Can I purchase for multiple people?

Yes, you can do this by purchasing individually via website or send us a request via email at email/info)(coursesforsuccess.com

25.  Can I request for an invoice before purchase?

Yes, you can request for an invoice via email at email/info)(coursesforsuccess.com

26.  Purchase for a gift?

Yes, you can purchase this course as a gift, simply send an email to email/info)(coursesforsuccess.com, with the course details and we can accommodate this.

27.  Can I create my own course bundle?

Yes, you can customize your own bundle. Please send us the complete list with the exact course link of the courses you'd like to bundle up via email email/info)(coursesforsuccess.com and we will create them for you. *Each course access, time of completion and certification varies depending on the course type.

28.  How will I contact Courses For Success if I have any questions?

You can contact our support team, at any time through live chat on our website, or email at email/info)(coursesforsuccess.com, or by calling one of our phone numbers depending on which country you are in.  

We provide a 7 Day Money Back Refund on all Courses

Special Offer

 

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

 

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.
  • Thousands of positive reviews.
  • Limited Time Offer - Ends Soon.
 

Training 2 Or More People?


Empower your business with access to 500+ job & soft skills online training courses.

SUCCESS PRO - For Business

Course Summary

Course ID: CFS02A10AD3CB
Delivery Mode: Online
Access: Unlimited lifetime access to course material
Time: Study at your own pace
Duration: 18-22 Hours
Assessments: Yes
Qualification: Certificate

Learn More With Course Bundles

Popular Courses and Bundles

Get a FREE Career Planner