Saturday, January 7, 2012

How to use Access 2010 - Tutorials for Beginners

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.



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.

START LEARNING TODAY!
or

No comments:

Post a Comment