Microsoft Access Advanced - Version 2003 or 2007

Participants will be able to use their advanced skills to create and implement Access database processes, security systems, manage records, create macros and practise the applications. Time allowed to consolidate the content covered in the prior 2 courses and answer any one on one queries attendees may have.


» Course Outline

    
    Structured Query Language
        *    Writing SQL Commands
        *    Writing SQL Queries
        *    Writing SQL Subqueries
        *    Writing SQL Joins
        *    Inserting Data
        *    Updating Data
        *    Deleting Data
        *    Writing SQL Queries in Access 2003
    
    Working with Macros
        *    Automating Tasks
        *    Introducing the Macro Design Toolbar
        *    Creating Macros
        *    Testing and Debugging Macros
        *    Modifying Macros
        *    Conditional Programming In Macros
        *    Adding Macros to Forms
        *    Adding Macros to Reports
        *    Filtering Data
        *    Documenting Macros
    
    Using Visual Basic
        *    Using Macros Versus Visual Basic
        *    Understanding Visual Basic Concepts
        *    Using the Visual Basic Editor Window
        *    Getting Help with Visual Basic
    
    Using Data Access Pages
        *    Creating Data Access Pages
        *    Modifying Data Access Pages
        *    Sorting Data in Data Access Pages
        *    Summarising Data in Data Access Pages
        *    Editing Data in Data Access Pages
        *    Protecting Data in Data Access Pages
    
    Converting Access Database
        *    Converting Databases to Access 2003
        *    Converting from Access 2003 to Access 97
        *    Converting from Access 2003 to Access 2000
    
    Customising Access 2003
        *    Configuring Access 2003 Options
        *    Configuring Autocorrect Options
        *    Customising Menus and Toolbars
    
    Managing and Maintaining Databases
        *    Optimising Databases with Table Analyser
        *    Optimising Databases with Performance Analyser
        *    Documenting Databases with Documenter Analyser
        *    Avoiding Errors with the Object Dependencies Task Pane


 » Prerequisites
 Participants are recommended to have already completed Microsoft Access Introductory/Intermediate or have skills to that level.

 » Assessment
 On completion of this course, attendees will be provided with a Certificate of Participation.

» Duration
1 Day - 9:00am to 4:00pm.

» Cost
$299.00 (Inc GST) per person - Attend this course and Microsoft Access Introductory/Intermediate for only $699.00!

» Dates
Please visit our timetable for current dates by clicking here

» Registration
To register for this course please click here.

» More Infomation
If you require more infomation please don't hesitate to contact us.