Complete Access 2007 Package
This package is designed for anybody who wants to become proficient in Access 2007 with no prior experience. Participants will learn the basics of Microsoft Access 2007 databases and then become proficient in advanced database design and development, including use of VBA programming.
Quick Facts
$2,560 incl GST
Save $1400.00
Download Course Brochures
Courses Units: Fast Track To Microsoft Access 2007
- Unit 1: Access Orientation
- - Data vs Information
- - Why Access
- - Excel vs. Access
- - Database Windows
- - Access Architecture
|
- Unit 2: Using the Ribbon, Introducing Access Options
- - Ribbon Tabs
- - Navigation Pane
- - Office Button
- - Access Options
|
- Unit 3: Database Theory
- - Database Fundamentals
|
- Unit 4: Database Design
- - Design Fundamentals
- - Review Existing Business Practices
- - Develop a Project Plan
- - Planning your Database
- - Identify Core System Users
- - Identify Tasks
- - Document Data Flow
- - Identify Data Elements
- - Design and Create Tables
- - Review Tables
- - Design a Prototype User Interface
- - User Testing of Interface
- - Finalise User Interface/Underlying Queries
- - Design Reports
- - Build the Application, including start-up routines
- - User Testing of System
- - Sign off and Release for general use
- - Naming conventions – and why they are so important
|
- Unit 5: Building Tables
- - Designing an efficient database model - normalisation
- - 1st Normal Form
- - 2nd Normal Form
- - Designing Tables
- - Using Field Properties
- - Lookup Wizards
- - Manually Creating a single Table Lookup
- - Other Field Properties – Specifying Date Formats
- - Other Field Properties – Phone Number Input Masks
- - Breaking Normalisation Rules
- - Primary and Foreign Keys
- - Compacting and Repairing the Database
- - Navigation Pane Options
|
- Unit 6: Working with External Data
- - Importing Data into Access
- - Text Files
- - Data Import Errors
- - Importing unmatched data into Access
|
- Unit 7: Setting Table Relationships
- - What is Referential Integrity?
- - Establishing Referential Integrity
- - Edit an Existing Relationship
|
- Unit 8: a Quick Look at the Forms
- - Creating a Standard Access Form – using an AutoForm
- - Using the Form Wizard
- - Setting Basic Form Properties
|
- Unit 9: Configuring Access Display Options
- - Trusting the Current Database
- - Setting Default Field Properties
- - Changing Display Format from Tabbed to Overlapping
|
- Unit 10: Introducing Access Select Queries
- - Relational Queries - How They Work
- - Viewing Data
- - Different Views of a Query
- - Pivot Table and PivotChart View
- - Creating a Single Table Query
- - Using the Query Design Grid
- - Selecting ALL Fields from One Table
- - Adding More Tables to a Query
- - Manually Forming Links
- - Moving Fields Within a Query
- - Deleting Fields From a Query
- - Applying a single criteria to a Field
- - Selecting for Specific Data Types (Numeric, Dates, Text, Yes/No)
- - Using AND and OR Criteria
- - Creating AND Criteria
- - Creating OR Criteria
- - Combining AND and OR Criteria
- - Using Range Expressions
- - Selecting for Exclusions
- - Using Wildcards
- - Using Queries for Table Lookups
|
- Unit 11: Creating and Using Perameter Queries
- - Creating a Parameter Query
- - Creating More Flexible Queries – the 'Like' Keyword
- - Display a Range of RecordsNominating Parameter Data Types
|
- Unit 12: Using Calculated Fields in Queries in Queries
- - String Concatenation and Field Renaming
- - Creating Calculated Fields
- - Using Numeric Fields in Calculations
- - Formatting Calculated Fields
|
- Unit 13: Form Design - Beyond the Forms
- - Uses of Forms
- - Form Element Overview
- - Form View Styles
- - Form Properties
- - Full Summary of Form Properties
- - Creating a New Form (without the aid of a Wizard)
- - Editing Labels
- - Field Properties
- - Repositioning Form Controls
- - Aligning Form Controls
- - Controlling the Tab Order
- - Adding the Finishing Touches to the Form
- - Designing with Sub Forms
- - Finalise Parent Form – Add the Sub Form
|
- Unit 14: Enhanced Form Design
- - Form/Report Toolset
- - Reviewing the Current Forms
- - Creating Required Additional Tables
- - Changing From a Text Box to a Combo Box
- - Adding an Unbound Text Box
- - Working with Concatenated Combo Boxes
- - Adding Calculated Text Boxes
- - Modifying the SubForm
- - Using Sub Forms Fields in Calculations
- - Adding Buttons to Forms
- - Tab Controls
- - Adding Hyperlinked Fields
|
- Unit 15: Creating Simple Access Reports
- - Defining the Dataset
- - Creating Reports Using the Wizard
- - Designing Reports to display Numeric Information
- - The Report Design View
- - Editing Controls
- - Resizing Text Labels and Fields
- - Deleting Report Elements
- - Setting Report Margins
|
- Unit 16: Modiying Access Reports
- - Grouping and Sorting
- - Forcing Page Breaks
- - Report Header/Footer vs. Page Header/Footer
- - Using the Keep Together Options
- - Adding Controls
- - Modifying the Record Source
|
- Unit 17: Designing a Navigation System
- - User Interface Design Overview
- - Creating a Main Menu Form
- - Adding Command Buttons
- - Navigation Buttons
- - Aligning Buttons
- - Adding Boxes and Labels
- - Delete Buttons
- - Printing
|
- Unit 18: Controlling Access at Startup
- - Setting an Application Icon and Title
- - Defining the Initial Form
|
Courses Units: Advanced Microsoft Access 2007 - Masterclass
- Unit 1: Using the Navigation Pane
- - Tables and Related Views
- - Navigation Pane Objects
- - Custom Groups
|
- Unit 2: Validating and Standardising Table Data
- - Setting Default Values
- - Defining Field Validation
- - Requiring a Field to be Completed
- - Adding Date Picker to Date Fields
- - Using Rich Text Formatting (Memo Fields)
- - Table Validation Rules
|
- Unit 3: Setting Table Relationships
- - Locating Orphan Records
- - Cascading Updates and Deletes
- - Join Types
|
- Unit 4: Introducing Access SQL
- - Commonly used SQL Keywords
|
- Unit 5: Advanced Select Queries
- - Using Left
- - Using Mid
- - Using the LEN Function
- - Using IIF Functions
- - Using LCASE Functions
- - Using TRIM Functions
|
- Unit 6: Action Queries
- - Make Table Queries
- - Update Queries
- - Append Queries
- - Delete Queries
- - Action Query Workflow Example
- - Maintaining Record History via Append Only Memo Fields
|
- Unit 7: Aggregate Queries
- - Grouping Data
- - Adding Criteria to Aggregate Queries
|
- Unit 8: Cross Tab Queries
- - Creating CrossTab Queries
- - Modifying a CrossTab
|
- Unit 9: Using Pivot Table in Access (And Via Excel)
- - Creating Pivot Tables Within Access
- - Using Access Pivot Tables
|
- Unit 10: Introducing Access Macros and VBA
- - Just what is a Macro?
- - Macro Review
- - Creating and Editing Macros
- - Enhancing Macros with TempVars
- - Adding Conditions to Macros
- - Introducing Access VBA
- - Adding Conditions to Macros
- - Introducing Access VBA
|
- Unit 11: Advanced Form Design
- - GUI Design
- - Designing a Standardised User Interface Model
- - Working with Form Filters
- - Validating Form Data
- - Cascading Combo Boxes
|
- Unit 12: Designing with Layout View
- - a Quick Look at Layout View
- - Creating a Form Using the Quick Form Tool
|
- Unit 13: : Advanced Reports
- - NoData Event
- - Show/Hide Report Sections based on User Selections
- - Add Running Sums to Report Sections
- - Add a Watermark to a Report
|
- Unit 14 : Reporting Systems
- - Reviewing Methods to Run Reports
- - A Fully Featured Reporting Module
|
- Unit 15 : Database Security
- - Logging Users into the System
- - Restricting User Access to Design Elements
- - Converting to ACCDE Format
|
- Unit 16 : Splitting the Database
- - Why Split a Database
- - Using the Database Splitter
- - Relinking Tables
- - Manually Linking and Using Multiple Linked Table
|
Courses Units: Microsoft Access 2007 - Visual Basic for Applications
- Unit 1: VBA Essentials
- - Understanding The Programming Environment
- - Exploring The Object Model
- - Navigating With Forms
- - Creating A StartUp Form
- - The VBA Editor Window
- - Working With The Project Explorer
- - Working With The Properties Window
- - Understanding Modules
- - Viewing The Code Behind Forms
- - Standard Code Modules
- - Understanding Naming Conventions
|
- Unit 2: VBA Subroutines
- - Understanding Modules In Access
- - Understanding Procedures
- - Anatomy Of A Module
- - Creating A Subroutine
- - Creating A Function
- - Calling Procedures
- - Passing Parameters
- - Returning Values
- - Scoping Procedures
|
- Unit 3:Using Variables
- - Understanding Variables
- - Understanding Data Types
- - Creating And Using Variables
- - Implicit And Explicit Declarations
- - Working With Numbers In VBA
- - Dealing With Overflows
- - Working With Decimals In VBA
- - Working With Dates In VBA
- - Default Values
- - Understanding The Scope Of Variables
- - Procedure Level Scoping
- - Module Level Scoping
- - Passing Variables By Reference
- - Passing Variables By Value
|
- Unit 4: Making Decisions
- - Understanding The If Statement
- - Creating A Single-Line If Statement
- - Creating A Block If Statement
- - Creating Multiple If Statements
- - Assignment: Creating If Statements
- - Using If For Multiple Text Conditions
- - Understanding The Select Case Statement
- - A Simple Select Case Statement
- - Value Ranges In Select Case Statements
- - Using Select Case Statements With OR
|
- Unit 5: Interacting with users
- - Understanding Input Boxes
- - Using The InputBox Function
- - Using InputBox Function Arguments
- - Understanding Message Boxes
- - Creating A Simple Message Box
- - Creating A Longer Message
- - Breaking A Message Line
- - Displaying Buttons And Icons
- - Using The Message Box Function
- - Responding To Different Buttons
|
- Unit 6:The DoCmd Object
- - Understanding DoCmd
- - Navigating With DoCmd
- - Moving Through Records
- - Filtering Records With DoCmd
- - Opening And Closing A Form With DoCmd
- - Opening A Report With DoCmd
- - Creating Variable Reports
|
- Unit 7: Looping in VBA
- - Understanding Loops
- - Understanding For Loops
- - Creating A While Loop
- - Working With Counters
- - Creating An Until Loop
- - For…Each Loops
- - Exiting From Loops
- - For...Next Loops
- - Assignment: Creating Loops
|
- Unit 8: Debugging VBA
- - Understanding Debugging
- - Setting A Breakpoint
- - Setting Additional Breakpoints
- - Stepping Through A Procedure
- - Viewing The Call Stack
- - Using Locals And Immediate Windows
- - Adding A Watch
|
- Unit 9 : Form Validation
- - Data Validation Overview
- - Validating Between Fields
- - Highlighting the Current Field
- - Highlight ALL Required Fields
- - Adding to Combo Boxes using the NotInList Event
- - Value Lists
- - Table/Query Lists (Single Selection in ComboBox)
- - Table/Query Lists (Multiple Columns in ComboBox)
- - Requesting a Change (via Email)
|
- Unit 10: Controlling User Access Level
- - Retrieving User Roles
- - Using the Allow… Properties
- - Disable / Enabling Controls and Menu Options
- - Using OpenArgs
- - The Tag Property
- - The Form Timer Event
|
- Unit 11: Setting References
- - Setting References
- - Available References
- - Locating Other Libraries
- - Late Vs. Early Binding
- - Using Outlook – Early Binding
- - Using Outlook – Late Binding
|
- Unit 12: Using an External Reference - File Dialogs
- - FileDialog Object Members
- - Creating a File Dialog
- - Selecting a Single File Only
- - Creating a File Type Filter
- - Selecting Multiple Files
- - Creating a Generic File Dialog module
- - Defining the File Types (as optional arguments)
- - Storing the returned file path
- - Storing Multiple Values – using an Array
- - Extending the Project
|
- Unit 13: Working with Files and Folders
- - Features of the Microsoft Scripting Runtime Library
- - Using the FileSystemObject
- - Working with Folders
- - Creating Folders
- - Deleting Folders
- - Checking for Contents of a Folder
- - Consolidating the Create/Delete/Review Routines
- - Copy Folder
- - Move Folder
- - Next Steps
- - Working with Files
- - Adding Files
- - Writing To a Text File
- - Copying and Moving Files
- - Deleting Files
|
- Unit 14: Audit Logging Routines
- - Capturing User Login/Logout Details
- - User Login Routine
- - User LogOut Routine
- - Logging Form/Report Interaction
- - Logging the Opening Time
- - Logging the Closing Time
- - Retaining Full Data History
- - Further Considerations
|
- Unit 15: Error Handling
- - VBA Error Handling
- - Error Handling Logic
- - Creating a Standard Error Handling Routine
- - Logging Errors
- - Extending Error Handling
- - Keeping the User Informed of the System State
|
- Unit 16: Code Commenting & Template Creation
- - Adding Detailed Comments – A Structured Approach
- - Creating a Database Template
- - Importing Objects into the Template DB
- - Exporting Objects as Text Files
|
- Unit 17: Using the Access Developer Tools
- - Creating a Database Template
|
- Unit 18: Access Recordsets
- - ADO
- - The Connection Object
- - Command Object
- - RecordSet Object
- - Removing References to SET Variables
- - DAO
- - Creating a DAO Recordset
- - Working with DAO Recordsets
- - Bound Forms & SubForms (Using Queries)
- - Change From Bound To UnBound (Using RecordSets)
- - Creating The Forms RecordSet
- - Completing the Navigational Elements
- - Adding New Records
- - Editing Records
- - Deleting Records
- - Completing The Unbound Form
- - Adding Error Trapping
- - Dealing with Code Duplication
|
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,560 incl GST
Save $1400.00
