Microsoft Access Manuals
Access Basic
Suggested 1 day course
SAQA US ID 116936 – Work with a simple database
(NQF Level 3 – 3 Credits)
Overview on a database - understand what tables, queries, forms and reports are. Format data in a table’ Sort information; Filter information; Hide columns; Freezing of Columns; Print information; Using the Advanced Filter on a table; Designing of tables; Using fields in tables; Setting the properties for fields in a table; Entering new records in a table; Insert/delete a field in a table. Relationships between tables.
Access Intermediate
Suggested 1 day course
SAQA US ID 116936 – Work with a simple database
(NQF Level 3 – 3 Credits)
SAQA US ID 117927 – Solving a given problem with using a database
(NQF Level 4 – 6 Credits)
Working with queries; Grouping data in queries; Summarize data in queries; Using criteria in queries; Using date criteria in queries; Calculated fields in a query; Using parameter queries (prompting the user for input); Create simple reports on queries/tables; Compact and Repair a database; Backups of a database.
Access Advanced
Suggested 2 day course
SAQA US ID 117927 – Solving a given problem with using a database
(NQF Level 4 – 6 Credits)
Advanced Table Design; Set a combination of fields as unique; Use Advanced Queries to update; append; delete data; Make table queries; Cross Tab Queries; Find Duplicates queries; Find Unmatched queries; Using Forms for input or user interaction; Form and Report Design; Use controls on forms to search for specific information or to filter information. Use unbound textboxes on Forms or Reports for calculations; Use macros to automate processes; Change the Design on report to group data in specific ways; Show Totals on Reports; Use Menus to automate the database; Link to other sources
Access Power User
Suggested 2 day course
SAQA US ID 117927 – Solving a given problem with using a database
(NQF Level 4 – 6 Credits)
Design and plan on paper a database solution to a given specification; Relationships – solve integrity errors; Normalization – (splitting tables in smaller tables); Importing Excel information into an Access database, without losing data; Union Queries; Automate in a macro to run various action queries to do updating, appending; etc; Using the autoexec macro; Securities and passwords; Database passwords; Advanced Form design- using the events in combination with macros or visual basic to update data, populate data, etc. Advanced report design – running totals; opening a report with macros; Filtering a specific Report to print, e.g. a specific Invoice No; Linked table manager.