Microsoft Access 2010 Advanced Course

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

Free - 7 DAYS $0.00
Access over 80 courses Access Videos Access Case Studies - 7 Days Free Access - Access Assessments - No commitment required - START NOW
Premium - 1 DAY $35.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 1 Day Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 - - START NOW
Premium - 7 DAYS $50.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 7 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
MOST POPULAR Premium - 1 MONTH $100.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 31 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
Premium - 3 MONTHS $180.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies - 93 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
BEST VALUE Premium - 1 YEAR $400.00
Unlimited Access to All Courses Unlimited Access to All Videos Unlimited Access to All Case Studies Mini-MBA Certificate included 365 Days Duration of Access Download Unlimited Certificates Access Assessments Premium email support 24x7 OR skip trial START NOW
Testimonials
“The courses has been very enjoyable, easy to conceptualize. The contents are well placed and the notes are well summarized. The knowledge I gained was very useful in my organization’s Enterprise Resource Planning (ERP) project of which I was a key member. I recommend CIB courses to others across the globe. Looking forward to doing more courses with CIB”.

Geofrey OumaIT Software Developer/ERP Project IT Lead (Kenya)

"I have a first degree in Geology and Mining and an M Phil in Environmental Management. I have worked as an administrator most of my life and needed certification in the field. Thank you for a wonderful training experience in the CIB Advanced Human Resource Certificate Program. Not only have you given me a certificate but most importantly opened my eyes to things I never knew, at my own pace and convenience. Looking forward to acquiring more certifications. #IAmSpreadingTheWord”

Vivian Ozoekwe Assistant General Manager, Havilah Group (Nigeria)

"Wow, I am excited to be a part of CIB. Your courses are wonderful and affordable! CIB is helping people get jobs with these certificates. You are light years better. That's why you are music to my ears".

Hassan O.Information Technology and Health Professional (USA)

"I am in the transition phase of my career from a technical to a management role. After studying with CIB I can safely say I am now ready to take on my new role. CIB courses are simplified and straight to the point. Instead of attending physical classes, I now study any time and anywhere. I am so grateful to be part of the institution”.

Mandla MahlanguAnalyst Developer (South Africa)