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
Troubleshooting and Proofing
- Debugging Macros and Queries: Identify and resolve errors in macros, queries, and forms.
- Proofing Tools: Use built-in tools to check data entry accuracy and resolve common database errors.
- Printing Setup: Adjust print settings for tables, forms, and reports, including margins and print preview.
CITY & GUILDS COURSES IN MAURITIUS
CITY & GUILDS COURSES IN MAURITIUS
The City & Guilds courses lead to Awards, Certificates and Diploma for IT Users.
You can choose from a wide array of IT subjects and topics to build up your Diploma. City & Guilds helped numerous of our students start a Career in Web Development, IT Officers, Graphic Designer, Customer Support and much more.
CITY AND GUILDS COURSES ORGANISATION & TIMING
We have created a schedule for this course to match with most availabilities.
Our unique methodology includes in-class lectures, practical sessions, online coaching, past-papers and state of the art testing tools ensure that students get the best preparation for the examinations, which are set and marked by the City & Guilds UK three times per year. Locally, the exams are organized under the supervision of the MES.
Pre-requisite: None
Duration: From 3 months to 2 years, depending on exit route – Certificate, Award or Diploma.
- At least 2 sessions per week
- Course Materials
- Practical Sessions
- Career Development
FAQs about this course
What is the main purpose of Microsoft Access?
Microsoft Access is a database management system (DBMS) that helps users store, organize, and manage large amounts of structured data. It allows you to create databases, build queries, design forms, and generate reports for business or IT needs. It’s especially useful for small to medium-sized organizations that require a cost-effective database solution.
What is the difference between Excel and Access?
Excel is mainly used for data analysis, calculations, and visualization (spreadsheets).
Access is designed for storing, managing, and relating structured data across multiple tables, making it better for database-driven solutions.
In short: Excel is great for numbers and analysis, while Access is better for managing relational data.
Is MS Access easy to learn?
Yes, for beginners it is relatively easy to learn, especially if you’re already familiar with Microsoft Office products. However, mastering its more advanced features (like SQL queries, relationships, and automation using VBA) may require practice and training.
What are the disadvantages of Access?
Not ideal for very large databases (limited to 2 GB per file).
Slower performance with many users or heavy data loads.
Limited scalability compared to enterprise solutions like SQL Server or Oracle.
Not cloud-native (though it can be connected to cloud databases).
Do companies still use Access?
Yes, many small and medium-sized businesses still use Access because it’s affordable, integrates with Microsoft Office, and is sufficient for departmental or project-level databases. However, larger enterprises often migrate to more robust solutions for scalability.
Is Microsoft Access free?
No, Microsoft Access is not free. It is part of the Microsoft 365 (Office) suite in the Professional and higher editions. A standalone license can also be purchased.
Can Microsoft Access be used on a Mac?
Not directly. Microsoft does not provide a native Mac version of Access. However, Mac users can run it through:
Virtualization software (e.g., Parallels, VMware Fusion).
Remote Desktop to a Windows PC.
Cloud-hosted solutions.
Can Microsoft Access be shared?
Yes, Access databases can be shared in different ways:
Split Database: Data is stored in a shared backend file (on a network), while each user has a local front-end file for forms and reports.
SharePoint Integration: Databases can be published to SharePoint.
Cloud Databases: Access can connect to SQL Server or Azure SQL Database for multi-user access.
RELATED ARTICLES
Embarking on a cybersecurity career requires structured learning and certifications. At INFOCLUB Training Centre, we have a plan to make
Building a Career in Cybersecurity
Embarking on a cybersecurity career requires structured learning and certifications. At INFOCLUB Training Centre, we have a plan to make
Unleash Your Child’s Digital Potential This Summer with Fun, Hands-On IT Courses! As the summer holidays roll around, it’s time
CONTACT US FOR MORE INFORMATION
Contact Us if you have any questions regarding this course. We are also available after hours for any requests.
- +230 241 1533 (During Office Hours only)
- +230 5941 9678 (If first number is not available)
- infoclubltd@yahoo.com
- infoclubtraining@gmail.com
- administration@infoclub.org
