Course Rating
Out of 72 verified reviews
Recent Feedback
"I did excel and access training with Computer Training Wales, both courses were very enjoyable and interactive. I learned a host of new skills which will make my workload easier."
Pete - Welsh Government
"Fantastic course, was nervous at first but the trainer really put me at ease. Training was done in small group which was great."
Katie - NHS
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Access Beginner
Welcome to our one-day Microsoft Access for Beginners course in Bridgend. This comprehensive course is specifically designed for individuals who are new to Microsoft Access and eager to unlock the power of this user-friendly database management tool. Throughout this engaging course, we will take you on a step-by-step journey to explore the fundamental concepts of database management and how to effectively leverage Microsoft Access to organise, store, and retrieve your data.
The day will begin with an introduction to Microsoft Access, familiarising you with its intuitive interface and key functionalities. You will gain a solid understanding of database concepts, including tables, queries, forms, and reports, laying a strong foundation for your database management journey. Through hands-on exercises and practical examples, you will learn how to create and manage tables, design effective queries to extract specific information from your database, and build user-friendly forms for data entry. Additionally, you will master the art of generating professional reports to present your data with clarity and precision.
Our experienced trainers will guide you through establishing relationships between tables, ensuring the integrity and efficiency of your database. You will also be introduced to the basics of database security to protect your valuable data.
Available Course Dates 2024/25 - Access Beginner
December 2024: Fully Booked
January 2025: 17th, 24th, 31st
February 2025: 12th, 19th, 26th
March 2025: 12th, 19th, 26th
April 2025: 2nd, 9th, 16th, 23rd, 30th
May 2025: 7th, 14th, 21st, 28th
June 2025: 4th, 11th, 18th, 25th
Course Content - Access Beginner
- Introduction to Microsoft Access
- Understanding Database Concepts
- Navigating the Access Interface
- Creating and Managing Tables
- Designing Effective Queries
- Building Forms for Data Entry
- Generating Professional Reports
- Establishing Relationships between Tables
- Creating Simple Macros for Automation
- Importing and Exporting Data
- Introduction to Database Security
- Real-World Applications and Practical Exercises
Who is this course for?
This Access Beginner course will then progress towards learning how to create relational databases to exploit the full potential of Microsoft Access training. Here you will create more complex forms based on multi-table queries. Save time by developing different types of queries to find information quickly and efficiently.
Course Rating
Out of 57 verified reviews
Recent Feedback
"Today I completed Access intermediate with Chris at Computer Training Wales and it was a very informative course. Really enjoyable and I learned a lot of things that I will be able to use on a daily basis. Very good training and I will recommend to others."
Phillip - Warburtons
"Wrapping up the Access Intermediate course, I'm not just armed with database skills, but I've had a blast along the way, thanks to an awesome trainer who made learning as enjoyable as it was enlightening."
Dan, Administrative Assistant
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Access Intermediate
Welcome to our one-day Intermediate Microsoft Access course in Bridgend. This dynamic course is designed for individuals who already have a basic understanding of Microsoft Access and want to take their database management skills to the next level. Throughout the course, you will build upon your existing knowledge and explore advanced features of Microsoft Access. You will learn how to create complex queries with multiple criteria, utilise calculated fields, and implement parameter queries for dynamic data retrieval.
In addition, we will delve into form customisation and advanced form design techniques, enabling you to create professional and user-friendly interfaces for data entry and manipulation. The course will also cover advanced reporting functionalities, including grouping and summarising data, creating subreports, and implementing conditional formatting for data visualisation. Furthermore, you will discover the power of database macros for automation, streamlining repetitive tasks and enhancing your productivity.
Available Course Dates 2024/25 - Access Intermediate
December 2024: Fully Booked
January 2025: 17th, 24th, 31st
February 2025: 12th, 19th, 26th
March 2025: 12th, 19th, 26th
April 2025: 2nd, 9th, 16th, 23rd, 30th
May 2025: 7th, 14th, 21st, 28th
June 2025: 4th, 11th, 18th, 25th
Course Content - Access Intermediate
- Advanced Query Techniques
- Utilising Calculated Fields
- Parameter Queries for Dynamic Data Retrieval
- Customising and Designing Forms
- Advanced Form Controls and Subforms
- Enhancing User Experience with Navigation Forms
- Advanced Reporting Functionalities
- Grouping and Summarising Data
- Creating Subreports
- Conditional Formatting for Data Visualisation
- Database Macros for Automation
- Streamlining Repetitive Tasks
- Improving Productivity with Macros
- Real-World Application Projects
- Database Optimisation Techniques
Who is this course for?
To gain maximum benefit from this course, delegates should understand all of the elements in the Beginners course, or demonstrate the basic concepts of Microsoft Access.
Course Rating
Out of 38 verified reviews
Recent Feedback
"Embarking on the Access journey with our lively and experienced trainer was like going on a database adventure."
Jean-Paul, Office Manager
"The trainer's expertise and approachable style created a supportive learning environment, particularly beneficial for participants approaching advanced database concepts."
Ryan, HR Assistant
Price £195 (no VAT) Duration 1 Day Venue Llynfi Enterprise Centre, Bridgend County, CF34 0BQ
Course Overview - Access Advanced
Welcome to our one-day Advanced Microsoft Access course in Bridgend. This intensive course is designed for individuals who have a solid understanding of Microsoft Access and want to become power users of this versatile database management software. Throughout the course, you will explore the most advanced features of Microsoft Access, empowering you to design and manage complex databases with precision. The day will start with advanced query techniques, including SQL queries and action queries, to manipulate and update data efficiently.
You will gain proficiency in creating dynamic and interactive forms with subforms, navigation forms, and advanced form controls for an enhanced user experience. Additionally, you will learn how to design sophisticated reports with grouping and sorting, calculated fields, and advanced formatting options. The course will also cover database optimisation techniques, indexing, and performance tuning to ensure smooth and efficient data retrieval. Furthermore, you will master the art of database automation using Visual Basic for Applications (VBA), creating custom functions, and automating complex tasks.
Available Course Dates 2024/25 - Access Advanced
December 2024: Fully Booked
January 2025: 17th, 24th, 31st
February 2025: 12th, 19th, 26th
March 2025: 12th, 19th, 26th
April 2025: 2nd, 9th, 16th, 23rd, 30th
May 2025: 7th, 14th, 21st, 28th
June 2025: 4th, 11th, 18th, 25th
Course Content - Access Advanced
- Advanced Query Techniques: SQL Queries and Action Queries
- Dynamic and Interactive Forms with Subforms
- Enhanced User Experience with Navigation Forms
- Sophisticated Report Design with Grouping and Sorting
- Calculated Fields and Advanced Formatting Options
- Database Optimisation: Indexing and Performance Tuning
- Database Automation with Visual Basic for Applications (VBA)
- Custom Functions and Advanced Automation
- Handling Complex Database Challenges
- Unleashing the Power of Microsoft Access
- Real-World Application Projects and Case Studies
- Mastering Database Management with Confidence
- Expanding Data Management Capabilities
- Best Practices for Efficient Database Management
- Optimising Workflow and Productivity
Who is this course for?
To gain the maximum benefit from this course an attendee should have attended Beginners and Intermediate courses or have a thorough knowledge of the information contained within those courses.
Our Clients
