Access 2003 Essential Training

Discusses database concepts, design methodology, features, and tools.

Access 2003 Essential Training with Mark Swift is a movie-based tutorial that will enable new and existing database designers to develop an understanding of the latest version of Microsoft Access. This training begins with an introduction to database concepts and a design methodology that will help new designers organize the data being stored, and quickly advances to cover many of the features and tools needed to design exceptional database applications. This training also looks at features that are new or improved in Microsoft Access 2003. Exercise files are included, allowing you to follow along and learn at your own pace.

Introduction

• welcome

1. Database Fundamentals

• what is a database?
• understanding database design
• system overview
• analyze current system
• define data elements
• normalization
• establish relationships
• testing and review
• naming conventions

2. The User Interface

• exploring the interface

3. Creating Databases

• creating a new database
• Office Online

4. Creating Tables

• creating tables
• design view
• the table wizard
• tables by inputting data
• data types
• setting field properties
• propagating field properties
• object descriptions

5. Working with Table Records

• editing records
• display settings
• the find feature
• sorting and filtering
• copying tables

6. Creating Relational Databases

• keys
• table relationships
• object dependencies

7. Using Select Queries

• what are queries?
• creating select queries
• using the query wizard
• working with results
• query criteria

8. Calculations in Your Queries

• performing calculations
• duplicate records

9. Creating Forms and Controls

• AutoForm
• form wizard
• working with controls
• control properties
• form properties
• printer forms
• adding a subform
• adding headers & footers

10. Creating and Using Reports

• AutoReport
• using the report wizard
• report sections
• controls & properties

11. Enhancing Forms and Reports

• using AutoFormat
• special effects
• opening a form on startup
• adding graphics
• AutoCorrect & error checking
• switchboards

12. Working with External Data

• exporting data
• importing external data
• linking to external data

13. Adding Security

• passwords
• encryption & decryption
• using the security wizard

14. Access and the Web

• dynamic vs. static data
• data access pages
• hyperlinks
• importing & linking html

15. Speed Up a Database Application

• modules & call trees
• tuning your computer
when it's useful
• repair
• backing up
Conclusion
• goodbye