Fast Track To Microsoft Access 2007
Who should do this course?
This course is designed for people who need to know how to use Microsoft Access. This course assumes no prior knowledge of Microsoft Access however a general understanding of personal computers and the Windows operating system is required.
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'.
About the course:
The skills and knowledge covered in this course are sufficient for creating the tables, queries, forms and reports required for use in a relational database system. Emphasis is placed on good design practices and database design theory.
At the completion of the formal sessions a workshop is conducted and a database built from the ground up. Participants will be encouraged to use their own database model and ideas during this session.
Learning outcomes:
Upon successful completion of this course, participants will be able to:
- Start and exit Access and understand the role of each of the seven component parts of Access work.
- Be able to apply elementary database theory to effectively design and create a single user database system.
- Create effective tables, including:
- Correctly defined data types
- Application of business logic (data validation)
- Establish formal relationships between tables
- Manage entry into tables, including:
- Adding data to relational tables
- Import and export data from/to external sources (Excel, text etc)
- Design queries to extract meaningful data from the database tables
- Understand the role of form and be able to:
- Design a form using the Form Design Wizard
- Modify a form manually using the form design toolsets
- Understand the role of the different form types
- Understand the role of Access tables and be able to:
- Design a form using the Report Design Wizard
- Make adjustment to reports using the report design toolsets
- Create a switchboard manager using standard access forms
- Control the way that Access behaves upon startup, and in doing so create a small 'database application' as opposed to a simple Access file.
Quick Facts
| Level: |
Beg / Int |
Price: |
$1485.00 incl GST |
You will receive: |
| Duration: |
3 Days |
Discounts*: |
2 Students - 10% |
- Certificate of completion |
| Size: |
10 |
|
3 Students - 15% |
- Training Manual |
| Times: |
9.00am - 5.00pm approx |
|
4 Students - 20% |
- 12 months FREE email support* |
| Pre-requisites: |
Refer to course description |
Bonus: |
2 FREE |
- FREE class re-sit (if necessary)* |
| |
|
|
Movie Tickets |
Course Brochure: |
| |
|
|
|
Access2007_FT.pdf |
| |
|
|
|
|
| * Conditions apply. |
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 12-14 Apr 10
- 09-11 Aug 10
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 07-09 Jun 10
|
|
Brisbane
C/- Support Technology, Level 6, 371 Queen St
Brisbane
View map
|
- Date:
- 17-19 May 10
|
|
Canberra
C/- Training Choice, Level 12, 15 London Circuit
Canberra
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
For more information on dates or locations, please call
1300 888 724 or
enquire online.
Course Units
- 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
|
