Access 2007 is the database software in the Microsoft 2007 Office Suite. It allows you to order, manage, search, and report large amounts of information. This tutorial will show you how you might plan and build a database from scratch, including how to set up tables, create and use forms to enhance data integrity, design and run meaningful queries, and produce useful and attractive reports.
Topics Covered Include:
- Understanding Database Concepts
- Why Do I need a database
- Exploring an Access Database
- Thinking about Database Design
- Building the database
- Setting up tables and fields
- Building table relationships
- Entering and editing Data in tables
- Creating and Using Forms
- Making forms more usable with controls
- Making forms attractive
- Analyzing and reporting Data
- Sorting Records
- Filtering recods
- Using queries to make data meaningful
- Using reports to make data meaningful to others