Access 2003 Advanced

Access 2003 is a database management program that makes it easy to store and find information, analyse data and create accurate reports. This course takes you step by step through advanced database tasks using Access 2003.

You'll learn how to:

• identify, set and modify data types
• understand field properties and create input masks
• use data validation rules, create field lookups and set default data values
• create and manage table relationships
• create simple and advanced queries
• work with forms and subforms
• create and format reports
• import and export data and use external data sources

Modules:

There are 16 modules in this course:

• Data Types
• Field Properties
• Table Relationships
• Queries
• Action Queries
• Advanced Query Options
• Form Basics
• Adding Controls
• Subforms
• Expressions and Tab Sequence
• Creating Reports in Design View
• Report Wizard and Page Breaks
• Calculated Report Controls
• Macros
• Importing and Exporting
• Linking External Data

Course features:

• Simulation training replicates the software you're learning, providing a realistic learning experience.
• Learn how to perform tasks at your own pace and interactively by following easy step-by-step actions.
• Reinforce your knowledge at the end of each lesson by completing interactive and multiple choice quiz questions.
• Lessons can be completed within 30 minutes so you can do your training in bitesize pieces.
• Bookmarking allows you to dip in and out, so you can learn whenever suits you.
• Course navigation features allow you to jump directly to specific topics of interest quickly and easily.
• Designed for people who require initial and refresher training activities.

You'll have access to this course for six months from the date of purchase - giving you plenty of time to finish your course.

How this course can help your business:

• Make the most of your investment in IT
• Use databases to store, manage, sort and analyse information
• Make sound business decisions based on accurate information
• Store customer records securely
• Improve communication by providing staff with better access to information
• Capitalise on and manage the knowledge, experience and information contained within your business

Course Code: 104461BT001