Fast Track To Microsoft Access 2003
People with no technical database experience can learn to use the powerful features of Microsoft Access 2003 create tables, queries, forms and reports.
Quick Facts
Duration: 3 Days
Class Size: 10
Level: Beg / Int
Times: 9.00am - 5.00pm approx
Other Microsoft Access 2003 Courses:
About the Course
During this 3 day course, participants will learn to use Microsoft Access 2003. A hands-on approach is taken, and emphasis is placed on good design practices and database design theory. Students will learn to design and create a basic database, apply validation, logic and relationships, and write queries and generate reports. At the conclusion of the training, practical workshop is undertaken and a database built from the ground up. Participants will be encouraged to use their own database model and ideas during this session.
Who should do this course?
This course is designed for people who need to know how to use Microsoft Access. To gain the most from the experience participants are encouraged have a project in mind, to commence upon completion of the course, or be currently using an Access database with a need to become more ‘hands on’.
Prerequisites
This course assumes no prior knowledge of Microsoft Access however a general understanding of personal computers and the Windows operating system is required.
Course Units
- Unit 1: Access Orientation
|
- Unit 2: Database Theory
- - Why Access
- - Excel vs Access
- - Avoiding Data Redundancy
- - Data Flow within Access
|
- Unit 3: Database Design
- - Designing an efficient database model - normalisation
- - Prepare a Spreadsheet for import into Access - Create tables to replicate this
- - Naming conventions – and why they are so important
|
- Unit 4: Building Tables
- - Create Tables
- - Lookup Wizards
- - Properties that are set
- - Data Type and Field Size Enforcement
- - Setting Default Values
- - Primary Key versus Foreign Key
- • What makes a good Primary Key
- • How to implement
- • Entering, Amending and Deleting Data
|
- Unit 5: Working with External Data
- - Importing/Exporting Data from
- • Excel
- • Text Files
|
- Unit 6: Setting Up Table Relationships
- - Setting Referential Integrity
- - Adding and Deleting Relational Records
- - Entering Data Manually
- • via Tables
- • via Forms (advantages of a form)
|
- Unit 7: a Quick Look at the Forms
- - Creating an AutoForm
- - Using the Form Wizard
- - Setting Basic Form Properties
|
- Unit 8: Introducing Access Select Queries
- - Relational Queries - How They Work
- - Viewing Data
- - Creating a Query Design
- - Using the Query Grid
- - Different Views of a Query
- - Adding More Tables to a Query
- - Modifying Fields in a Query
- - Creating AND and OR Queries
- - Selecting for Opposites
- - Using Range Expressions
- - Selecting for Specific Data Types (Numeric, Dates, Text, Yes/No)
- - Using Wildcards
- - Running a Query From the Database Window
- - Problem Queries - Cartesian Datasets
|
- Unit 9: Creating And Using Parameter Queries
- - What is a Parameter?
- - Creating a Parameter Query
- - Display a Range of Records
- - Nominating Data Types
- - Creating More Flexible Queries – the ‘Like’ Keyword
|
- Unit 10: Using Calculated Fields in Queries
- - String Concatenation
- - Renaming an Output Field
- - Creating Calculated Fields
- - Formatting Calculated Fields
- - Calculating with Dates
|
- Unit 11: Creating Combo Boxes
- - Via the Wizard
- - Creating Manually
- • On a table
- • On a form
- - Setting properties
- • Hiding/Showing Fields
- • Field Widths
- • Stored Column
|
- Unit 12: Forms Design - Beyond the Wizard
- - Setting Properties
- • Removing Dividing Lines
- • Min/Max/Close Buttons
- • Modal State
- • Scroll Bars
- • Border Styles etc
- • Controlling the Tab Order
- - Form Heading Versus Page Heading
- - Form Types
- • Single
- • Continuous
- • Datasheet
- • Sub Forms
- • Popup
- - Designing with Sub Forms
|
- Unit 13: Enhanced Form Design
- - Modifying Data Sources
- • Adding New Fields
- • Opening a form based on records in another
- - Resizing and Aligning Controls
- • Shift and Ctrl
- • Lasso
- - Option Group Wizard
- - Adding Images
- - Tab Controls
- - Adding Buttons to Forms
|
- Unit 14: Creating Simple Access Reports
- - Defining the dataset.
- - Creating Reports Using the Wizard
- - The Report Design View
- - Report Sections
- • Report Header/Footer
- • Page Header/Footer
- • Detail
- - Editing Controls
- - Adding Controls
|
- Unit 15: Modifying Access Reports
- - Grouping and Sorting
- • Showing Heading/Footer
- • Keep Together
- - Calculations
- • IIF
- • Adding Subtotals
- - Grouping and Formatting Techniques
- - Using Expressions in Reports
|
- Unit 16: Designing a Navigation System
- - User Interface Design Overview
- - Creating a Main Menu Form
- - Adding Command Buttons for:
- - Navigation
- • Delete
- • Duplicating Records
- • Printing
- • Closing
- • Saving and Quitting
|
- Unit 17: Controlling Access at Startup
- - Introducing Access Startup Options
- - Setting an Application Icon and Title
- - Hiding Access Components
- - Apply a Database Password
|
- Unit 18: Workshop
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
Date: upon demand
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
Date: upon demand
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen Street
Brisbane
View map
|
Date: upon demand
|
|
Canberra
C/O Atlas Business Services, 21 Barry Drive
Turner
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
|
Perth
C/- Lansen Consulting Pty Ltd, Level 1, 484 Albany Highway
Victoria Park
View map
|
Date: upon demand
|
Duration: 3 Days
Class Size: 10
Level: Beg / Int
Times: 9.00am - 5.00pm approx
