Learning Access 2010

I worked with a student yesterday on a synthesis project.  She asked me to consider writing a textbook on Access.  I wish I had the time.  It is so difficult to use textbooks that do not have healthcare examples.  It is so difficult for clinicians to see the relevance to their practice without concrete examples.  This morning I researched for resources that I could use in conjunction with data sets such as those from the Centers for Disease Control and Prevention (CDC).  I found a great resource in GCF Learning!!   It includes concise lessons on Access 2010.  Each of the four categories shown below have instructional videos.  The tutorial also includes a sample Access file that users can download.  The tutorial can be accessed from http://www.gcflearnfree.org/access2010

Access Basics

• 1: Introduction to Databases
• 2: Introduction to Objects
• 3: Getting Started in Access
• 4: Managing Databases and Objects

Working With Data

• 5: Working with Tables
• 6: Working with Forms
• 7: Sorting and Filtering Records

Running Queries and Reports

• 8: Designing a Query
• 9: More Query Design Options
• 10: Creating Reports
• 11: Advanced Report Options

Database Design Tips

• 12: Modifying Tables
• 13: Creating Forms
• 14: Formatting Forms
• 15: Designing Your Own Database