Access 2003 Workshop

Dynamic Web Training Pty Ltd.
Adelaide, Brisbane, Canberra, Melbourne, Sydney, Australia

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

Course Description:

'' 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 students are encouraged have a project in mind, to commence upon completion of the course, or are currently using an Access database and 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 also 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. Students will be encouraged to use their own database model / ideas during this session.


Learning outcomes:
Upon successful completion of this course, students 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 & 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.


After the course?
Each student will receive:
* Microsoft certificate of completion
* Microsoft Training Manual
* 12 months FREE email support
* FREE class re-sit (if necessary)
...''

Phone:1300 888 724, +61 2 9957 1366

School Address:

Level 11
32 Walker Street
North Sydney NSW 2060

Level 12
379 Collins Street
Melbourne VIC 3000

C/- Support Technology
Level 6, 371 Queen St
Brisbane QLD 4000

C/- Training Choice
Level 12, 15 London Circuit
Canberra ACT 2600

C/- Hire Intelligence
Level 4, 74 Pirie Street
Adelaide SA 5000

Jobs & Resumes: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Houses & Roommates: Adelaide, Brisbane, Canberra, Melbourne, Sydney
Travel Agencies: Brisbane, Melbourne, Sydney

Search other schools for Access 2003 training resources.

Photoshop CS3
Illustrator CS3
InDesign CS3
Excel 2007 Level 1
Excel 2007 Level 2
Excel 2007 Level 3
Excel 2003 VBA
Word 2007 Level 1
Word 2007 Level 2
Word 2007 Level 3
Access 2003 VBA
PowerPoint 2003 Level 1
PowerPoint 2003 Level 2
Outlook 2007 Level 1
Outlook 2007 Level 2
Microsoft Project 2003
Microsoft Office 2007
Fast Track to MYOB
MYOB Payroll

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: Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting.