Microsoft Word 2002/2003 Level 1
Make more informed decisions by effectively tracking, reporting, and sharing information with Microsoft Access.
With our extensive knowledge of the different software currently on the market, including all Microsoft and Adobe applications, ON-TRACK Computer Training Ltd. has a diverse and flexible schedule that can be customized to your needs – we offer group course (both public and corporate), one-on-one training, and on-site training options. We also have easily accessible on-line training videos available.
Duration: 1 Day
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
Prerequisites
- A thorough understanding of the Windows operating environment
- Strong mouse and keyboard ability
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