Course Description

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 will get a chance to practice some of the advanced features right on a computer. 



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. Sit back, relax, and have fun. You are in for a thrilling ride!

Learning Outcomes

By the end of this 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 sub-form, 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
•    Link to, import and export an Excel spreadsheet, Access database, SharePoint list, text or XML file and other types of links, imports and exports

Course Features

Request Course Information

I am interested in Microsoft Access 2010 Advanced Course


MODULES
Module One: Getting Started
Module Two: Advanced Table Tasks
Module Three: Advanced Form Tasks
Module Four: Advanced Reporting Tasks
Module Five: Understanding Relationships
Module Six: Advanced Query Tasks
Module Seven: Working with SQL
Module Eight: Linking Data
Module Nine: Importing Data
Module Ten: Exporting Data
Module Eleven: Advanced Database Tools
Module Twelve: Wrapping Up

Subscribe to the Free Plan and take this course for Free for 7 days or Subscribe to any of our premium plans and access all courses

Premium One Course

$11.99

  • Unlimited Access to One Course
  • Unlimited Access to All Course Videos
  • Unlimited Access to All Course Case Studies
  • 365 Days Duration of Access
  • Download PDF Certificate
  • Access Assessments
  • Premium email support 24x7
Premium Three Courses

$29.99

  • Unlimited Access to All Three Courses
  • Unlimited Access to All Three Courses Videos
  • Unlimited Access to All Three Courses Case Studies
  • 365 Days Duration of Access
  • Download All Three Courses Certificates
  • Access Assessments
  • Premium email support 24x7
Premium Certificate Program

$49.99

  • Unlimited Access to All Certificate Courses
  • Unlimited Access to All Certificate Videos
  • Unlimited Access to All Courses Case Studies
  • 365 Days Duration of Access
  • Download All Five Courses Certificates + Main Certificate
  • Access Assessments
  • Premium email support 24x7
Premium Mini MBA

$129.99

  • Unlimited Access to All Mini MBA Courses
  • Unlimited Access to All Mini MBA Videos
  • Unlimited Access to All Mini Case Studies
  • Mini-MBA Certificate included
  • 365 Days Duration of Access
  • Download All Thirteen Courses Certificates + Mini MBA Course Certificate
  • Access Assessments
  • Premium email support 24x7

Testimonials

From the Our community