Computer Science 12

Tutorials on

Microsoft Access 2007

• Week 7: Introduction to databases
• Week 10: Access 2010 tutorials

Week 7: Introduction to databases

Preliminary introductions to databases (in general, not just Access):

• Database Basics on About.com, including Databases for Beginners, in which see especially What is a Database? and Database Software Options. (Note: The latter article says that server databases are more expensive than desktop databases, but this isn't necessarily true. There is a free version of MySQL.)
• Databasics I: Records and queries and keys, oh my! and the first 25% or so of Databasics II: Creating your first database, in Geekgirl's Plain-English computer tutorials. (Note: The author seems unaware of the existence of other kinds of databases besides relational and flat file. There are others.)
• Database basics on Digital Online Tutorial at McMaster. (Describes single-table databases only, from a librarian's perspective.)
• What are relational databases? on HowStuffWorks
• Introduction to Database Normalization. (Note: You will not be expected to learn the normal forms for this course. Just read the first three pages of this tutorial to get a general idea of some of the issues that would be involved in designing a large relational database, and to learn some database terminology.)
• Basic Database Tutorial, Introduction and RDBMS Definition on The Computer Technology Documentation Project

Preliminary introductions to database concepts, using Access:

• Microsoft Access Database Fundamentals in Building an Access Database From the Ground Up on About.com.
• In LearnFree.org's tutorial: (1) Why Do I Need a Database?, (2) Exploring an Access Database, and (3) Thinking about Database Design
• Database basics and Crabby demystifies Access terms in Microsoft Office Access: Getting Started - Microsoft Office Online

Tutorials on Microsoft Access 2007:

• Microsoft Office Access: Getting Started (including Getting started with Access 2007 and Learn the structure of an Access database) and Access 2007 Courses - Microsoft Office Online
• Microsoft Access 2007 - Practical Learning Series
• Access 2007 Tutorial by Justin Farrell
• Microsoft Office Access 2007 Lessons - FunctionX
• Access 2007 in Computer Training on LearnFree.org

To all information for Week 7  |  To all tutorials about Access

Week 10: Access 2010 tutorials

Access 2010 tutorials:

• Access 2010 - LearnFree
• Microsoft Access 2010 Tutorial: Basic Help Creating Database
• Allen Browne's tips for Microsoft Access. (For next week, see especially Relationships between Tables.)

To all information for Week 10  |  To all tutorials about Access