If you're interested in learning how to use Access 2010, take a look at these very helpful MS Access 2010 tutorials for beginners. These videos are from Access 2010 Essential Training from lynda.com. In this course, Microsoft Certified Expert Alicia Katz Pollock gives a comprehensive overview of creating databases in Access 2010. You'll learn how to build an Access database from scratch - including tables, queries, reports, and macros. Whether you're new to Access or have been using it for years, you'll learn some excellent tips and strategies for effective database design. The videos below are just a few of the videos from the training course. To access the entire course, you can sign up for a lynda.com membership or you can try it out first with a free 7-day trial pass. The trial pass gives you full access to the entire lynda.com training library of over 1000 courses.
Access 2010 Essential Training by
START LEARNING TODAY!
or
WATCH THESE 7 FREE VIDEO TUTORIALS FROM THE COURSE
Backstage view - How to use Access 2010 - Tutorials for Beginners
Exploring ribbons - How to use Access 2010 - Tutorials for Beginners
Creating relationships and enforcing referential integrity - How to use Access 2010 - Tutorials for Beginners
Creating data-entry forms - How to use Access 2010 - Tutorials for Beginners
Using the Report Wizard - How to use Access 2010 - Tutorials for Beginners
Formatting reports in Layout view - How to use Access 2010 - Tutorials for Beginners
Creating macros - How to use Access 2010 - Tutorials for Beginners
START LEARNING TODAY!
or
Course Information
Training Provider: Lynda.com Title: Access 2010 Essential Training Author: Alicia Katz Pollock Duration: 3hrs 30mins Date of release: 10 June 2010
Chapter 1: Access Basics Database concepts and terminology Starting Access Creating a new file Trusting a file The Quick Access toolbar Backstage view Exploring ribbons Using the Navigation pane Getting help
Chapter 2: Creating a First Database and Using the Tools Planning and designing your database Creating tables using Application Parts Creating tables in Layout view with Quick Start Creating and editing tables in Design view Setting a primary key Creating a lookup field Creating multi-value fields Using calculated fields
Chapter 3: Setting Up the Data Setting field properties Setting input masks Setting validation rules
Chapter 4: Building Structure Creating relationships and enforcing referential integrity Viewing subdatasheets
Chapter 5: Formatting and Appearance Entering data into your tables Formatting tables Finding, sorting, and filtering records
Chapter 6: Forms Creating data-entry forms Using the Form Wizard Modifying a form in Layout view Using Design view Setting tab stops Adding buttons to a form Using navigation forms
Chapter 7: Queries Introduction to queries Using the Query Wizard Creating a query in Design view with criteria Creating wildcard queries Creating reusable parameter queries Creating yes/no queries Creating "and" and "or" queries Building calculation queries Creating statistical queries Using update queries Using delete queries Creating crosstab queries
Chapter 8: Reports Introduction to reports Using the Report Wizard Formatting reports in Layout view Identifying report structure in Design view Adding group and sort capabilities to a report Adding existing fields from other tables Adding totals and subtotals to a report Adding conditional formatting and data bars to a report Creating multi-table reports Creating mailing labels Printing reports
Chapter 9: Putting Data to Work PivotTables PivotCharts
Chapter 10: Automating with Macros Creating macros Attaching macros to objects Using data macros
Chapter 11: Using Other Applications with Access Importing Excel and text data Exporting data into Excel Exporting to PDF Exporting into a Word Mail Merge Publishing to a web browser in HTML or XML Sharing via email Collecting data over email Using Package and Sign Publishing to SharePoint Importing and exporting with SharePoint
Chapter 12: Advanced Tools in the Database Compacting and repairing a database Using data analysis tools Encrypting a database and setting a password Splitting a database
Chapter 13: Customization Customizing the ribbons Setting Access options
About Lynda.com
Lynda.com is an online video training provider with over 1000 courses covering a wide array of topics - 3D, video, business, the web, graphic design, programming, animation, photography, and more. They produce top quality video tutorials with the best industry experts as your instructors. With a subscription, you can log-in at any time, and learn at your own pace. New courses are added each week, and you will receive a certificate of completion for each course that you finish.
Start learning today! If you enjoyed the sample videos above and want to access the entire Access 2010 Essential Training course, you can sign up for a lynda.com membership. Your membership will allow you to access not only this course, but also the entire lynda.com library for as low as $25 for 1-month. Their training library has over 1000 courses with 50,000+ video tutorials. No long-term commitment required. You can cancel your membership at any time.
Not yet convinced? Try a FREE 7-day trial. As a special promotion, visitors of this site can get a FREE 7-day trial to lynda.com. This free trial gives you access to their entire training library of over 1000 courses.
I hope you found these free MS Access 2010 tutorials helpful. If you'd like to view this entire course on how to use Access 2010, sign up for a lynda.com membership today. Your membership gives you access to the entire lynda.com training library of over 1000 courses.
- Learn Digital Audio Production - Training Course For Beginners
In Digital Audio Principles by lynda.com, let commercial composer, sound designer, and recording engineer Dave Schroeder take you through the basics of digital audio production. In this digital audio production training course for beginners, you'll...
- How To: Ableton Live 8 Video Tutorials For Beginners
Start learning Ableton Live 8 with these free how to - Ableton Live 8 video tutorials for beginners. These videos are from Ableton Live 8 Essential Training by lynda.com. The entire course is 7 hours in length and teaches you what you need to know to...
- Developing Iphone Games Using Flash Cs5 | Iphone Game Development Course
Interested in developing iPhone games using Flash CS5? Then check out this iPhone game development course from lynda.com. The course is entitled Flash Professional CS5: Creating a Simple Game for iOS Devices, and you will find some sample videos below....
- Learn Revit Architecture 2011 - Video Tutorials For Beginners
Learn Revit Architecture 2011 in the Revit Architecture 2011 Essential Training Course by lynda.com - one of the best software training sites on the web today. You'll find free video tutorials below about: introducing the Building Information Modeling...
- How To Use Wordpress 3 - Video Tutorials For Beginners
If you want to learn how to use WordPress 3, then check out these free WordPress 3 video tutorials for beginners from the WordPress 3 Essential Training Course by lynda.com - one of the best software training sites on the web today. The free WordPress...