Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Access 2003 Essential Training

via LinkedIn Learning

Overview

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.

Syllabus

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

Taught by

Mark Swift

Reviews

Start your review of Access 2003 Essential Training

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.