Try our training for free.

Gain instant access to our entire IT training library for 1 week. Train anytime on your desktop, tablet, or mobile devices.

This Access video training with Tim Warner covers Microsoft’s powerful database application, including building tables, writing queries, and more....
This Access video training with Tim Warner covers Microsoft’s powerful database application, including building tables, writing queries, and more.

Related area of expertise:
  • Database administration

Recommended skills:
  • Experience using databases

Recommended equipment:
  • Microsoft Office Access 2010

Related certifications:
  • Microsoft Office Specialist (MOS): Access 2010

Related job functions:
  • User support professionals
  • Teachers/professors
  • Database users


In this Nugget training course, you'll learn to master Microsoft Access 2010. Access is a great database tool with deep integration potential between it and other desktop and enterprise Microsoft applications. So, whether you just want to learn how to create a database with Access, want to step your game up a notch with the 77-885 certification, or are an IT pro or programmer who wants a well-rounded introduction to the program's possibilities, you'll find what you need in this course.
Access expert Timothy Warner will cover all of the traditional end-user topics so that you know what you need to make Access work for you. In addition, Tim will cover pro- and developer-level topics for more advanced users. And, you'll find lots of useful tips, Web site references and supplemental information sprinkled throughout.
When you've finished with this training, you'll be prepared to pass the Access 2010 certification exam; be able to build, populate, optimize and maintain an Access 2010 databases, and get a head start on deploying data-driven Web databases.
1. Introduction (20 min)
2. Installing and Configuring Access (29 min)
3. Touring an Access 2010 Database (25 min)
4. Creating a New Database (27 min)
5. Building Tables I (50 min)
6. Building Tables II (49 min)
7. Building Forms I (41 min)
8. Building Forms II (36 min)
9. Writing Queries I (53 min)
10. Writing Queries II (36 min)
11. Using Application Parts and Expression Builder (39 min)
12. Generating Reports (28 min)
13. Advanced Data Analysis (20 min)
14. Macros and VBA Programming (36 min)
15. Integrating Access 2010 and SharePoint 2010 (40 min)
16. Integrating Access 2010 and SQL Server 2008 (24 min)
17. Importing and Exporting Data (40 min)
18. Customizing Access 2010 (40 min)
19. Database Security and Maintenance (36 min)
20. Packaging Access 2010 Applications (34 min)

Please help us improve by sharing your feedback on training courses and videos. For customer service questions, please contact our support team. The views expressed in comments reflect those of the author and not of CBT Nuggets. We reserve the right to remove comments that do not adhere to our community standards.

comments powered by Disqus
Entry 12 hrs 20 videos

COURSE RATING

Basic Plan Features


Speed Control
Included in this course
Play videos at a faster or slower pace.

Bookmarks
Included in this course
Pick up where you left off watching a video.

Notes
Included in this course
Jot down information to refer back to at a later time.

Closed Captions
Follow what the trainers are saying with ease.

NuggetLab
Included in this course
Files/materials that supplement the video training

Premium Plan Features


Practice Exams
These practice tests help you review your knowledge and prepare you for exams.

Virtual Lab
Use a virtual environment to reinforce what you are learning and get hands-on experience.

Offline Training
Included in this course
Our mobile apps offer the ability to download videos and train anytime, anywhere offline.

Accountability Coaching
Included in this course
Develop and maintain a study plan with assistance from coaches.