Understand the concepts of a Windows-based relational database management system. Learn how to create a database that really works for you. Access Fundamentals begins by showing you how to break up your data into manageable, logical units. The course then takes you through the basics of data relationships, tables and design. You'll understand how to lay out a database that is sensibly structured, easily manipulated and customized for your needs.
Note: This course covers versions 2000, 2002, XP and 2003.
Learning Objectives
Introduction to Access databases
- Design the database structure
- Create and edit tables
- Set field properties
- Find, filter and print data
Queries, Forms and Reports
- Create relationships
- Set referential integrity
- Use simple queries
- Create basic forms
- Create and print basic reports
Prerequisite:Understanding Windows