City & Guilds Courses in Mauritius

Microsoft Access Course in Mauritius

City & Guilds Courses - Microsoft Access Course in Mauritius

Our Microsoft Access Course equips you with essential skills for efficient data management and organization. From building databases to advanced data handling and reporting, this course provides practical knowledge to help you streamline workflows, manage large data sets, and improve productivity in the workplace.

This course is offered at Levels 1, 2 and 3 with typing speed ranging from 24 wpm to 50 wpm.

The course contents below will correspond to the level which you are studying.

Microsoft ACCESS course in mauritius

DATABASES

Understand: Database fundamentals, structures, and types
Learn: Differences between relational, NoSQL, and cloud databases

Working with Tables and Queries

Table Management: Create and format tables, set field properties, and understand relationships between tables.
Query Basics: Use Select, Append, Update, and Delete queries to manage and manipulate data.
Advanced Queries: Work with Parameter Queries, Calculated Fields, and Aggregate Functions to analyze data effectively.

Forms and Reports

Creating Forms: Design user-friendly forms for data entry, apply layout customization, and add form controls.
Form Properties and Subforms: Customize form properties and use subforms to display related data.
Report Generation: Develop professional reports, apply formatting, and add calculated fields.

Advanced Database Functions

Macro Basics: Automate tasks by creating and running macros for repetitive actions.
Data Import and Export: Transfer data to and from external sources like Excel, CSV files, and SQL databases.
Data Validation: Implement validation rules and error-checking to maintain data accuracy.

Database Maintenance and Security

Data Backup and Recovery: Learn methods for database backup, recovery, and protection against data loss.
Database Security: Apply security settings, set permissions, and restrict access to sensitive data.
Database Performance: Optimize database performance using indexes and regular maintenance tasks.

Merging and Sharing Data

Mail Merge: Merge Access data with Microsoft Word documents to create personalized letters, labels, and envelopes.
Sharing Options: Set up shared database access and manage linked tables for multiple users.

Styles and Content

Using Build- in Styles, Modifying Styles
Creating Styles, Creating a list style
Table of contents and references
Adding internal references
Adding a Footnote
Adding Endnote