MICROSOFT ACCESS ESSENTIALS (2 DAYS) - DLS CONSULTING

Subject

• Using Microsoft Access to work with a database

Unit Standards

• 116936 Use a Graphical User Interface (GUI)-based database application to work with simple databases  (3 Credits) Level 3

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 GUI-based spreadsheet application to solve a given problem 

The estimated course duration may not be met should the learner not have achieved these prerequisites

Level

• Basic

Modules

Database Concepts

• What is a Database
• Database concepts
• Database objects

Working with a Database

• Starting the Access Programme
• The Access Startup screen
• Understanding the database window
• Working in a datasheet
• Working with records in the datasheet
• Editing records in a datasheet
• Close a database

Working with a Database Table

• Creating a new database
• Creating a new table
• Field names
• Data Types
• Field Properties
• Primary Key and Indexes
• Delete a database table
• Modifying a database table in design view

Database relationships

• Understanding relationships
• Create a relationship using the Lookup Wizard
• Display Relationships
• Creating relationships in the Relationships window

Working with Forms

• Understanding forms
• Creating Forms with Form Wizards
• Changing the Design of a Form
• The Form Design toolbars
• Selecting, Moving and Sizing Controls
• Formatting Controls
• Working with the Toolbox and Controls

Working with Queries

• Understanding Queries
• Creating a Select Query
• Selecting fields for a query
• Sorting the Display
• Entering Criteria
• Using the Expression Builder
• View Query results
• Action Queries

Working with Reports

• Creating Reports with the Report Wizard
• Modifying a Report Design
• Working with the Toolbox
• Printing Reports
• Page Setup
• Printing