Microsoft Access

Overview

This course guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables. It also covers more advanced features of Access, and how to make different types of data queries, work with forms and link data to other databases. Finally, more complex aspects of working with data using Access are covered.

Course Contents

Remember, You can complete this Microsoft Access course within 6 to 9 months of enrolling. So take your first step by contacting us today !

Detailed Content

Unit 1: Creating Content

• Structuring Databases
• Create Microsoft Access databases
• Create and modify tables
• Define and modify field types
• Modify field properties
• Create and modify one-to-many relationships
• Enforce referential integrity
• Create and modify queries
• Create forms
• Add and modify form controls and properties
• Create reports
• Add and modify report control properties
• Create a data access page

Unit 2: Entering Data

• Enter, edit, and delete records
• Find and move among records
• Import data to Access

Unit 3: Organizing Data

• Create and modify calculated fields and aggregate functions
• Modify form layout
• Modify report layout and page setup
• Format datasheets
• Sort records
• Filter records

Unit 4: Managing Databases

• Identify object dependencies
• View objects and object data in other views
• Print database objects and data
• Export data from Access
• Back up a database
• Compact and repair databases

Frequently asked questions

Right away if you wish! This is the great advantage of home study.

The minimum system spec required to run any of our CD-ROMs is: A PC with Microsoft Windows 98 or later. For audio, a sound card with speakers or headphones.

Earning Microsoft Office Specialist(MOS) certification acknowledges that you have the expertise to work with Microsoft Office programs. Office Specialist certification sets you apart in today's competitive job market, bringing employment opportunities, greater earning potential and career advancement, in addition to increased job satisfaction.

Our course involves 15 to 20 hours learning time, depending on previous knowledge, and is designed to equip you with the right skills to perform real work. This preparation course is provided on our unique Skill Builder software which tailors each course to your individual needs. On all our NETg SkillBuilder courses, you can begin by doing a short skills assessment (called a Pre-assessment) which will give you a clearer idea of what you already know. The courseware will then create a learning path tailored to your own needs so you can spend time only on those areas that you have not yet mastered.

Office Specialist exams are administered at authorised testing centres.

Delivery Method:
1. CBT

Duration: 6 to 9 months