Microsoft Access 2010 Intermediate

Microsoft Access 2010 Intermediate Courses in Cape Town

 

Subject
Increasing effectiveness in developing and manipulating databases.
2KO International Group provides IT & business training courses for learners of all levels, and is also a top-rated, certified supplier of online IT courses, enabling 2KO students the opportunity to study courses online world-wide, to ensure the best training possible.

Unit Standards
117927 - Use a Graphical User Interface (GUI)-based database application to solve a given problem.

Pre-requisites
Prior knowledge and skills to:
Read, write, communicate and comprehend at least at GET level.
Competent in mathematical fundamentals at least at NQF level 2
Operate a personal computer system.
Use generic functions in a Graphical User Interface (GUI)-environment.
Use a Graphical User Interface (GUI)-based database application to work with simple databases.
The estimated course duration may not be met should the learner not have achieved these prerequisites

Level
Intermediate

Modules
Database Basics
Database planning
Database normalization
Relational database structure
Understanding relationships

Relationships
Using relationships
Creating relationships using the Lookup Wizard
Understanding the relationships window
Creating relationships in the relationship window
Editing a relationship
Print the database relationship
Customising Tables

Customising tables
Changing data type
Using Data Type Gallery
Applying field properties
Creating Lookups
Setting the field size property
Setting the format property
Creating custom formats
Using input masks
Setting data validation
Setting the indexed property
Setting the primary key
Working with the lookup property window

Working with Queries
Understanding queries
Creating select queries
Entering criteria
Using the Expression builder
Summarising query values
Creating parameter queries
Creating append queries
Creating delete queries
Creating update queries

Working with Forms
Creating new forms
Form views
Understanding controls
Working with control layouts
Resizing controls
Formatting controls
Understanding the property sheet
Sections in the Design view
Creating calculated controls
Creating summary calculations on a form
Creating a combo box on a form
Setting the tab order on a form
Applying conditional formatting on controls

Working with Reports
Creating new reports
Working with Report views
Modifying a report design
Print preview reports
Printing reports
Send the report as an e-mail message

Managing the Database
Compact and repair
Database password
Importing data
Exporting data