MS Access 

 

Cyber Minds Bellville offers Microsoft Access training designed to help you understand and work with databases confidently—whether you are a beginner or looking to enhance your data-management skills.

 

MS Access Course Offers:

 

Creative Minds® Access – Level 1 (Unit Standard 116936) 

Learn the fundamentals of Microsoft Access and gain confidence in creating and managing simple databases. This level focuses on understanding the structure and purpose of databases and how to work with basic objects.

 

Course Requirements: Delegate must be able to operate a computer system and use basic functions such as copy and paste.

 

Duration: (±) 10 hours

 

  • Introduction to Microsoft Access
  • Understanding database concepts
  • Navigating the Access interface
  • Creating a new database
  • Working with tables
  • Fields, data types, and properties
  • Entering and editing records
  • Creating simple queries
  • Creating basic forms
  • Creating and printing reports
  • Saving and backing up databases

 

Creative Minds® Access – Level 2 (Unit Standards 117927)

Learn how to design more complex databases and use Access tools to organize, analyze, and present data efficiently. Ideal for users who want to improve their database-building skills.

 

Course Requirements: Basic Access knowledge (Level 1 or equivalent experience).

 

Duration: (±) 15 hours

 

  • Designing relational databases

  • Creating and managing relationships

    • Primary keys & foreign keys

  • Advanced table design

  • Creating and customizing advanced queries

    • Parameter queries

    • Crosstab queries

    • Action queries

  • Designing and enhancing forms

    • Combo boxes, navigation buttons, controls

  • Advanced reports

    • Grouping, sorting, calculations

  • Importing and exporting data

  • Using macros for automation

  • Database maintenance

    • Compact & repair

    • Splitting databases

 

Contact Us Now

Do you need more information? Just click here

Chat with us?