MICROSOFT ACCESS EXPERT (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 
• Mastering Access to create and modify an Access database

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

Level

• Advanced

Modules

Database Design

• Database Normalization
• Relational Database structure
• Understanding relationships

Expert Form Design

• Size and position of a Form
• Modifying the record source for a form
• Setting or changing the tab order on Forms
• Creating an Option group using a wizard.
• Creating Sub forms
• Create a sub form and add it to a form
• Forms with a tab control
• Forms with page breaks
• Pivot Table Forms
• Command buttons on a form

Expert Queries

• Query types
• Append Queries
• Delete Queries
• Update Queries
• Make Table Queries
• Query Joins and Join properties
• Types of joins
• Cross tab Queries
• Unmatched and Duplicates Queries

Expert Reports

• Creating a report with sub reports
• Create a calculated control
• Add Charts to Reports (or Forms)
• Creating a Report Snapshot

Working with Macros

• Macros
• Creating a macro
• To run a macro

Expert Database Tools

• Importing Data
• Exporting Data
• Linking Data
• Linked table manager
• Compact and Repair
• Startup Options
• Document a database
• Analyse a Table
• Analyse Database Performance
• Improving the performance of an Access database
• Editing data in a shared database
• Database password security
• User Level Security