Topics included in this one day course are Introduction to Databases, Designing from Scratch, Database Relationships and Theory, Getting Started with Access, Tables, Forms, Queries, and Reports.
- Course Outline
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
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
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
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
Section 8 - Reports
What is a Report?
Creating Reports with Report Wizard
Reports Based on Queries
- Prerequisites & Certificates
* A thorough understanding of the Windows operating environment * Strong mouse and keyboard ability
Certificate of Completion
- Cancellation Policy
Should you postpone or cancel your course you must give 5 business days notice.
- Map & Reviews
On Track Computer Training
[ View Provider's Profile ]
This course currently does not have any dates scheduled. Please call 1-877-313-8881 to enquire about future dates or scheduling a private, in house course for your team.
This page has been viewed 2368 times.