Access 2003 Advanced

Two Rivers Software Training
Gold Coast, QLD, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This Advanced Microsoft Access course is designed for experienced Access users who need to learn advanced concepts to handle multi-user environments, security principles and how to customise and integrate the Access interface. This course is suitable for anybody considering a move into Database Administration.

TOPICS :
Queries

Null vs blank fields
Changing the join type
Advanced calculations
Using date functions in a query
Creating a Crosstab query manually and using the wizard
Applying criteria to Crosstab queries
Sub-forms and sub-reports

Sub-forms in datasheet view
Totalling data in a subform
The Locked and Enabled property
Advanced Form Design

The Tab Page control
Inserting extra tabbed pages
Formatting tab controls
Changing the page index
Adding pictures to a page tab
Changing Tab Control properties
ActiveX Controls
Using the ActiveX Calendar control
Creating navigation buttons
Creating a ’Find’ button
Finding data using a combo box
Advanced Report Design

Using parameter queries in reports
Changing the Record Source
Grouping data on text fields
Grouping data on date/time fields
Grouping data on multiple sections
Adding graphics to a report
Custom Toolbars

Creating a custom toolbar
Creating a custom menu item
Adding a command to a menu
Docking a floating toolbar
Linking a toolbar to a report
Creating a shortcut menu
Linking a custom shortcut menu to a form
Add, remove and re-arrange buttons on a custom toolbar
Changing a button image Switchboards

Creating a switchboard manually
Adding buttons to a switchboard
Setting the Start-Up Options
The Switchboard Manager
Integrating with other applications

Mail merging with Word
Analysing data with Excel
Creating Charts
Using the Chart Wizard
Resizing and moving a chart
Exploring the components of a chart
Applying a fill colour, pattern or texture
Legends
Changing the chart type
Adding a chart to a report
Multi-user applications

Exploring issues regarding multiple users
Sharing data
Splitting a database
Locking files
Editing shared data
Database Maintenance

Compacting and repairing a database
Database administration
Adding a password to a database
User level security
Creating and joining a workgroup file
Groups and users
Group permissions
Logon procedures
Adding users to a workgroup
Creating additional workgroups
Database object ownership
Using the Security Wizard to add users and groups
Replication

Why replicate a database?
Creating a database replica
Synchronisation
Resolving conflicts between replica set users
...''

Phone:0405 760 820

School Address:

PO Box 1354, Southport BC, QLD 4215, Australia

Jobs & Resumes: Gold Coast
Houses & Roommates: Gold Coast

Windows XP
Excel 2003 Introduction
Excel 2003 Advanced
Access 2003 Introduction
Powerpoint 2003
Publisher 2003
Microsoft Project 2003
Dreamweaver
MYOB

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.