Complete Access 2003 Package
This package is designed for anybody who wants to become proficient in Access 2003 with no prior experience. Participants will learn the basics of Microsoft Access 2003 databases and then become proficient in advanced database design and development, including use of VBA programming.
Quick Facts
$2,200 incl GST
Save $1320.00
Download Course Brochures
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
|
Courses Units: Microsoft Access 2003 - Visual Basic for Applications
- Unit 1: Development Basics
- - The Access Development Environment
- - The Importance of Splitting Databases
- - Maintaining Links
- - Using the Database Splitter
- - Using Queries for Reports And Forms
- - Access Run-Time
- - Understanding Client/Server
- - Development Basics Quick Reference
- - On your Own
|
- Unit 2: Macros And VBA
- - Macro Overview
- - Creating Macros
- - Assigning Macros
- - Creating More Complex Macros
- - Converting Macros to VBA Code
- - Macros Versus VBA
- - Macros and VBA Quick Reference
- - On your Own
|
- Unit 3: VBA Essentials
- - Programming Environment Overview
- - The Role of Forms
- - Creating a Startup Form
- - Understanding Modules
- - Code Behind Forms
- - Standard Code Modules
- - Standard Vs Class Modules
- - Naming Conventions
- - VBA Essentials Quick Reference
|
- Unit 4: VBA Subroutines
- - Understanding Modules in Access
- - The Anatomy of a Module
- - Creating a Subroutine
- - Creating a Function
- - Calling Procedures
- - Passing Parameters
- - Returning Values
- - Scoping Procedures
- - VBA Subroutines Quick Reference
|
- Unit 5: Variable VBA
- - Overview of Variables
- - Creating String Variables
- - Option Explicit
- - Working with Numbers
- - Dealing with Overflows
- - Working with Decimals
- - Working with Dates
- - Default Values
- - Scoping Variables
- - Local Variables
- - Module-Wide Variables
- - Passing Parameters
- - Passing Parameters By Value
- - Variable VBA Quick Reference
|
- Unit 6: Interactive VBA
- - The Act of Communicating
- - Creating a Simple Input Box
- - Creating More Elaborate Input Boxes
- - Global Positioning
- - Simple Message Boxes
- - Creating Larger Messages
- - Breaking a Message Line
- - Customising Icons And Buttons
- - Message Box Functions
- - Responding to Different Buttons
- - Interactive VBA Quick Reference
|
- Unit 7: Decisive VBA
- - Decisions Overview
- - Creating an in-line If
- - Creating a Block If
- - Multiple If
- - Multiple If Using Text
- - Using Case Statements
- - Value Ranges in Case Statements
- - Case Statements with OR
- - Asking Yes/No Questions
- - Decisive VBA Quick Reference
|
- Unit 8: Looping VBA
- - Program Loops
- - Creating a While Loop
- - Taking Care of Counters
- - Creating an Until Loop
- - For Each Loops
- - Exiting From Loops
- - For Next Loops
- - Looping VBA Quick Reference
|
- Unit 9: the DoCmd Object
- - Overview of DoCmd
- - Navigating with DoCmd
- - Moving through Records
- - Filtering Records with DoCmd
- - Opening a Form with DoCmd
- - Opening a Report with DoCmd
- - Closing a Form
- - Creating Variable Reports
- - The DoCMD Object Quick Reference
|
- Unit 10: ActiveX Data Objects - Tables
- - Overview of ADO
- - Setting References Using VBA
- - Creating a Table with ADO
- - Removing a Table Using ADO
- - Populating a Form Using ADO
- - Dealing with an Empty Table
- - ActiveX Data Objects Quick Reference
|
- Unit 11: ADO Forms and Recordsets
- - Overview of ADO with Forms and Recordsets
- - Navigating Records in a Form
- - Finding a Record
- - Updating a Record
- - Deleting a Record
- - Adding a New Record
- - ADO Forms and Recordsets Quick Reference
|
- Unit 12: Debugging VBA
- - Overview of Debugging
- - Setting a BreakPoint
- - Setting Additional Breakpoints
- - Stepping through a Procedure
- - Viewing the Call Stack
- - Using the Locals And Immediate Windows
- - Adding a Watch
- - Deleting a Watch
- - Debugging VBA Quick Reference
|
- Unit 13: Handling Errors in VBA
- - Error Handling Overview
- - Understanding Common Errors
- - Creating a Simple Error Handler
- - Understanding the Error Object Model
- - More Elegant Error Handling
- - Resuming From Errors
- - Forcing an Error
- - Creating Custom Errors
- - Handling Errors Quick Reference
|
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.
$2,200 incl GST
Save $1320.00
