Access 2007 Introduction to Database Design
Course Information
This two-day course is designed to introduce delegates to the concepts and functionality of a relational database exploring the advantages of electronic data storage.
Attendees will be confident in recognising the uses for a database and the concepts of database design. Delegates will be able to produce forms and reports and utilise the advanced query facilities.
Pre-requisites
Those attending this course should have a basic understanding of the Windows environment and be comfortable with using a mouse.
Course Objectives
By the end of the course delegates will be able to:
- Recognise the advantages of storing a database electronically rather than on a paper based system
- Create and manage simple database tables
- Create relationships between tables in order that data may be extracted from more than one table
- Navigate the database and records within the database
- Perform simple database queries to extract or select records from the database according to specified criteria
- Produce reports from tables and queries
- Build cutomised forms using additional controls such as lists and option buttons to make data entry quicker and more user friendly
- Create graphs and charts from databases
- Create summary tables or crosstabs from numeric data
- Perform more advanced queries using the built in queries within Access
What you will learn:
Day One
Lesson 1 – Advantages of a Database
Getting Started with Access
Built-in Templates
Ribbons
Database Terminology
Identifying Fields
Identifying Records
Database Properties
Lesson 2 – Create and Manage Tables
Create Tables in Access
Field Types
Setting Field Properties
Creating Input Masks
Inputting Data
Lesson 3 – Navigating & Querying a Table
Navigating the database
Finding Data
Sorting Data
Appending Data
Lesson 4 – Table Relationships
Types of Relationships
Referential Integrity
Indentifying the Primary Key
Joining Tables
Day Two
Lesson 5 – Producing Reports
Create a query
Queries that Concatenate
The Query Wizard
Lesson 6 – Using Forms
Form Layout
Format Forms
Split Forms
Lists & Option Buttons
Lesson 7 – Graphs & Charts
Create a chart from your database
Lesson 8 – Analysing Data
Summary Tables
Cross Tabs
Lesson 9 – Advanced Queries
Built-in Queries
