Microsoft Access Introductory/Intermediate - Version 2003 or 2007 (2 day course)

This course introduces you to the fundamentals of databases and database design. Using practical business examples you will set up your own Customer Relationship Management database to store common details such as customer contact details, stock control and customer interaction. These skills can then be applied to create your own customised database for your office. Microsoft Access is a powerful database application designed to save you time and make creating relational databases easier. Databases don't have to be confusing when you've had the right training.


» Course Outline

    Creating a New Database 
            Planning your database design
            Identifying your tables 
            Determining the fields for each table 
            Determining the primary keys 
            Determining relationships between tables 
            Optimising your database design

    Sorting Data Using Tables
            Creating a table
            Setting field properties
            Entering and manipulating data in tables 
            Querying tables
            Viewing and extracting data
            Testing and running your query
            Refining your data selection
            Operators and functions
            Expression examples
            Editing your query
            Simple calculations in a query 
            Simple functions in a query

    Forms
            Using the wizard to create forms for data entry
            Working with forms
            Creating simple forms

    Creating Reports
            Layout a report 
            Modify display attributes 
            Use calculated fields 
            Preview and print 
            Use the report wizard 

    Working with Forms 
            Modifying the design of your form 
            Inserting additional controls 
            Inserting a calculated control
    
    Working with Reports 
            Creating simple reports 
            Previewing and printing your report 
            Customising reports 
            Creating a switchboard 
            Automating start-up 
            Analysing your database 
            Database utilities 
            Formatting reports – create multi table reports, use graphics, create templates, create AutoForm entries, group data, use summary controls

    Adding an OLE Object to a Table 
            Adding a hyperlink to a table 
            Advanced select queries and calculations 
            Revisiting built-in functions 
            Using totals in queries

    Creating Crosstab Queries 
            Action queries 
            Update queries 
            Delete queries 
            Append queries 
            Duplicate records 
            Unmatched records 
            Using form wizards 
            Chart wizards

    Creating a Subform 
            Properties of forms 
            Creating a form template 
            Advanced reports 
            Sorting and grouping 
            Headers and footers with expressions   


» Prerequisites
None

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

» Duration
2 Days - 9:00am to 4:00pm.