|
Description: Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
Objectives
- Be 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
Outline
Section 1 - Introduction to Databases
- What is a Database
- What can I do with a Database?
- The six components of an Access Database
- How is all of this possible?
- Concepts and Terminology
Section 2 - Designing from Scratch
- Deciding what to track - The first step in Design
Section 3 - Database Relationships and Theory
- Flat File Databases
- Relational Databases
- The Primary Key
- Types of relationships
- Grouping fields into tables
Section 4 - Getting Started with Access
- The Application Window
- The Database Window
Section 5 - 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
Section 6 - Forms
- What is a Form?
- Creating Forms with Form Wizard
- Using and Editing an Existing Data Form
Section 7 - Queries
- What is a Query?
- Designing a Query
- Relational Operators
- Wildcard Characters
Section 8 - Reports
- What is a Report?
- Creating Reports with Report Wizard
- Reports Based on Queries
Pre-Requisites: A thorough understanding of the Windows operating environment
Strong mouse and keyboard ability
Certificates offered: Certificate of completion
Duration Details: 1 day
8:30am - 4:30pm
Facility Location: On Track Computer Training Center
1600 - 650 West Georgia Street
Vancouver
British Columbia
Canada
V6B 4N7
| 
