Access 2003 Package
This package is designed for people who want to create and maintain a relational database. With no prior technical experience required, participants will learn to create tables, queries, forms and reports in a well-designed, secure multi-user database using Microsoft Access 2003.
Quick Facts
$1,650 incl GST
Save $825.00
Download Course Brochures
About the Package
This package introduces students to the fundamentals of Microsoft Access 2003, such as database creation and basic queries and reporting, then moves on to advanced skills such as advanced validation, splitting and other functions. At the conclusion of the package, participants should be able to effectively design a secured, multi-user database.
The Access 2003 package includes the following courses:
Fast Track To Microsoft Access 2003 (3 days)
Advanced Microsoft Access 2003 - Masterclass (2 days)
Prerequisites
To ensure that the prerequisites for the courses within this package are met, participants should follow the sequence of courses listed above. More details on prerequisites can be found within individual course descriptions.
Subject to prerequisites being met, one or more participants can book into a package. Review training package conditions .
Courses Units: Fast Track To Microsoft Access 2003
- 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
|
Courses Units: Advanced Microsoft Access 2003 - Masterclass
- Unit 1: Data Validation
- - Using Expressions to Validate Data
- - Limitations of Data Validation
|
- Unit 2: Normalising a Database
- - First Normal Form
- - Second Normal Form
- - Third Normal Form
- - Bryce-Codd Normalisation
- - Breaking Normalisation Rules
|
- Unit 3: Splitting a Database
- - Why Split a Database?
- - Using the Database Splitter
- - Linking Tables Manually
- - Updating Links
- - Using Multiple Linked Tables
|
- Unit 4: Action Queries
- - Make Table Queries
- - Append Queries
- - Update Queries
- - Delete Queries
|
- Unit 5: Aggregate Queries
- - Grouping Data
- - Analysing Data
- • Sum and Average
- • Count, Min, Max
|
- Unit 6: Cross tab Queries And Pivot Tables
- - Analysis Periodic Data Using Pivot Tables
- - Using Pivot Tables
- - Using Pivot Charts
|
- Unit 7: Table And Query Relationships
- - Cascading Updates and Deletes
- - Searching for Orphan Records
- - Join Types
- • Inner Joins
- • Left and Right Joins
- • Union
- - Understanding Access SQL
|
- Unit 8: Database Security
- - Database Passwords
- - User Level Security
- - Creating a Custom Login Page
|
- Unit 9: Introducing Access VBA
- - VBA Fundamentals
- • Msgbox and InputBox
- • IF Statement
- • Reacting to User Input
|
- Unit 10: Advanced Form Design
- - GUI Design
- • Developing a Standard GUI
- • Screen Size / Resolution Issues
- - Applying and Clearing Form Filters
- - Modifying where Clause’s
- • AND and OR
- • Including String Delimiters
- - Cascading Combo Boxes
- - Validating Form Data
|
- Unit 11: Building a Reporting System
- - Passing Parameters
- • Via Forms
- • Via Objects
- - Parameter Fields
- • Combo Boxes
- • Text Boxes
- • Check Boxes
- • Option Groups
|
- Unit 12: Advanced Reporting System
- - Hiding Sections
- - 'On NoData’ Event
- - Report Formatting Techniques
- • Shading Alternate Lines
- • Custom Numbering Techniques
|
- Unit 13: Extending Beyond Access
- - Access ADP Format
- - Moving to a Server Model
- • SQL Server 2005
- • MySQL
- - Using XML Data within Access
- - Using Access Data on the web
|
Upcoming Dates
You’ll need to check the dates for each of the individual courses within this Package.
Check our Course Dates, or contact us to discuss your specific needs.
$1,650 incl GST
Save $825.00
