< back You're Viewing:

Intermediate Microsoft Access 2010

$99 (USD)

Enroll Now View Demo
Intermediate Microsoft  Access 2010

Do you have experience building Microsoft Access 2010 databases, but want to take your skills to the next level? In this course, you'll build an entire database project from scratch. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.  

You'll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you'll add and update key fields that allow you to build relationships among the tables. Then you'll master the steps for building complex yet easy-to-use forms to manage table data.  

The course offers you tips and techniques for optimizing your database, including ways to build crosstab and summary queries so you can access information quickly and easily. You'll also learn about outer table joins that can make you queries more effective. 

Once you've built your database, you'll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you'll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.

 

About The Instructor

Ken  Cook

Ken Cook has built and managed a successful computer consulting business (now called Cook Software Solutions, LLC) since 1990. He began as a trainer specializing in Microsoft Office and has helped numerous users (too many to count!) master a variety of software packages. Currently, he continues to train, but his main focus is creating expert Microsoft Office solutions and Microsoft Access database solutions for Fortune 500 and small business clients. Ken is also co-author (with Laurie Ulrich Fuller) of Access 2007 for Dummies and Access 2010 for Dummies published by Wiley.

 Close Nav

Please click on a month to choose a session start date:

  • Learn a new skill or enhance existing skills for professional development or personal enrichment.
  • New sessions starting monthly with lessons and assignments released weekly.
  • 2-4 hours a week in a convenient six-week format.
  • Interactive learning environment. Classroom built around discussion areas where you can engage with classmates and instructors.
  • Expert instructors develop, lead, and interact with students in each course.
  • Award of completion from your learning institution with passing score.
  • Build industry skills or earn continuing education credits in a variety of fields.
  • Start Anytime. Access to all course material and assessments from day one.
  • Many tutorials can be completed in just a few hours.
  • Quick independent study. Learn something new or expand your knowledge while working at your own pace.
  • Material developed by industry leaders and student support offered.
  • Certificate of completion awarded with passing score.
  • Gain the knowledge needed to move forward with your education.
  • Start anytime. Access Granted upon registration.
  • Courses are designed to be completed within 6-12 weeks.
  • Interactive multi-media instruction with integrated assessment, allowing you to work at your own pace.
  • Professional instructors support you throughout your learning experience.
  • Confirmation of successful course completion.

Forgot Your Password?

Complete the form below and click the Reset Password button. If we find your password, we'll send password reset instructions to the e-mail address we have on record for you.



Forgot Password?