MASTERING MICROSOFT ACCESS (2 DAYS) - DLS CONSULTING

Subject

• Increasing effectiveness in developing and manipulating databases

Unit Standards

• Not available

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
• Use a Graphical User Interface (GUI)-based database application to work with simple databases 
• Use a Graphical User Interface (GUI)-based database application to solve a given problem 

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

• Relationships
• Creating Relationships
• Referential Integrity
• Specifying Relationship Options
• Setting the Join Type
• Editing a relationship
• Viewing Relationships

Customising Tables

• Data Types
• Field Properties
• Field Size
• Formats
• Custom Formats
• Input Masks
• Data Validation
• Indexed property
• Primary Key
• The Lookup Property Window

Working with Queries

• Queries
• Select Queries
• Entering Criteria
• Calculations in Queries
• Using the Expression Builder

• Aggregate functions
• Parameter Queries
• Append Queries
• Delete Queries
• Update Queries

Working with Forms

• Using Forms
• Design View
• The Form Design toolbars
• Selecting, Moving and Sizing Controls
• Formatting Controls
• Working with the Toolbox
• Working with Controls
• Setting the tab order on Forms
• Creating a Combo Box on a Form
• Combo Box Properties
• Creating a Calculated Text box
• Using Properties to format calculation results
• Conditional Formatting on Controls

Working with Reports

• Report Design View
• The Toolbox and Toolbars
• Print Preview
• Page Setup
• Printing

Managing the Database

• Compact and Repair
• Database password
• Importing Data
• Exporting Data