Duration: 2 Days
Objectives
- Become familiar with the various objects in Access
- Explain the difference between flat file and relational databases
- Create a table design for a relational database
- Establish relationships between tables
- Work in and edit tables
- Design Forms using Form Wizard
- Design basic queries
- Design basic reports
Introduction to Databases
- What is a Database
- What can I do with a Database?
- The six components of an Access Database –
- Concepts and Terminology
Building the Database
- Deciding what to track – The first step in Design
- Setting Up The Tables
- Relationships Review
- Establishing Relationships and Referential Integrity
- Single Field Indexes
- Multiple Field Indexes
- Checking Database Integrity and Entering Sample Data
Database Relationships and Theory
- Flat File Databases
- Relational Databases
- The Primary Key
- Types of relationships
- Grouping fields into tables
Getting Started with Access
- The Application Window
- The Database Window
Tables
- Creating a Table – Fields and Datatypes
- Field Properties
- Adding and Deleting Fields
- Working in a Table
- Adding and editing records
- Navigating a Table
- Creating relationships between tables
Forms
- What is a Form?
- Creating Forms with Form Wizard
- Using and Editing an Existing Data Form
- The Toolbox
- Creating an Invoice
- The ‘Drop Down’ Combo Box
Queries
- What is a Query?
- Designing a Query
- Relational Operators
- Wildcard Characters
- Building Expressions With Queries
- Operators, Literals, Identifiers, and Functions in Expressions
Reports
- What is a Report?
- Creating Reports with Report Wizard
- Reports Based on Queries
- Report Design