Microsoft Access is a powerful relational database management tool, ideal for storing, analysing and organizing data efficiently. This course introduces the essential skills for creating, managing and optimizing databases, including designing user-friendly forms, generating detailed reports and automating workflows. With expert guidance, participants will learn how to enhance existing databases or build new ones tailored to business needs, gaining the confidence to streamline operations and improve data management.

Course Code: ITDA01 | Duration: 1 Day

The Introduction course provides a solid foundation in database management, guiding users through the basics of creating and understanding Access databases. Learn the key differences between flat and relational databases, the role of primary and foreign keys and how to build linked tables, queries, forms and reports. Whether you're new to Access or looking to enhance your skills, this course offers practical, hands-on training to help you confidently manage and organize data.

Who Should Attend Microsoft Access Training?

• Data Entry Professionals
• IT Professionals
• Office Managers
• Small Business Owners

Course Requirements:

No previous experience of Microsoft Access is required however the delegate should have knowledge in basic computer skills.

Course Content

• Relational Databases: Understand relationships between tables (1-1 / 1-Many)
• Creating: Build and manage lists and combo boxes, including combo box queries
• Forms: Design and customize forms (Tabular / Columnar / Sub Forms)
• Importing & Exporting: Import and export data from Excel and other databases
• Queries: Create forms using queries for enhanced functionality
• Reports: Generate professional reports using queries and grouping features
• Switchboard: Develop custom switchboards using the wizard or PCS Switchboard
• Professional Database: Create user-friendly databases with popup forms and toolbars

Course Code: ITDA02 | Duration: 1 Day

This course is aimed at users that have been on the previous stage or for the more experienced user who wishes to further their knowledge of this program. On completion of this course, delegates will be able to make use of more advanced formatting techniques, for example, being able to work with tables and using bulleted and numbered lists. The course also introduces the idea of mail merge, with a view to students producing letters, emails or address labels.

Who Should Attend Microsoft Access Training?

• Data Entry Professionals
• IT Professionals
• Office Managers
• Small Business Owners

Course Requirements:

The delegate needs to have attended the previous stage of the Word course at Pringle PCS or at least, have the equivalent working knowledge.

Course Content

• Type: Perform various queries (Select / Delete / Append / Make Table Query / Crosstab)
• Total Command: Utilize functions such as Group, Average, Sum, Count, Max, and Min
• Find Duplicates & Amending: Identify duplicates and fix broken queries effectively
• Multiple Table Queries: Convert into a flat file for mail merge purposes
• Reports: Generate reports using multiple tables and queries
• Summarise Reports: Group data and calculate totals for summarised reports

Course Code: ITDA03 | Duration: 1 Day

The advanced course builds on your existing knowledge, covering advanced document management, styles for automatic tables of contents, enhanced mail merge with filters and database links, and Word customization with menus, buttons, and an introduction to macros (VBA).

Who Should Attend Microsoft Access Training?

• Data Entry Professionals
• IT Professionals
• Office Managers
• Small Business Owners

Course Requirements:

The delegate needs to have attended the previous stage of the Word course at Pringle PCS or at least, have the equivalent working knowledge.

Course Content

• Relational Databases: Work with 1-1, 1-Many, and advanced working relationships
• Sub Forms: Create and manage standard and query-based sub forms
• Advanced Queries: Handle multiple tables and embed complex SQL queries
• Expression Builder: Utilize the expression builder for queries and custom commands
• Problem Solving: Tackle Access limitations and find creative ways to overcome restrictions
• Introducing Macros: Execute commands, set values, open forms, and run macros effectively
• PCS Development Tricks: Focus on documentation and understanding database

No Problems, Just Solutions...