Book Now Enquire Our Venue Brochure
Microsoft Access Beginner Microsoft Access Microsoft Access

Course Rating

Course Ratings

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 £199 (no VAT) Time 9:00am-2:00pm 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 instructors 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.


Course Dates 2024 - Access Beginner


June: 6th, 13th, 20th, 27th

July: 4th, 11th, 18th, 25th

August: 1st, 8th, 15th, 22nd, 29th

September: 5th, 12th, 19th, 26th

October: 3rd, 10th, 17th, 24th, 31st


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.


Microsoft Office - Case Study

Benefits

Gary had never used Microsoft Office before and needed to learn Microsoft Word and Excel as part of his new job role. Gary found the course very useful and said;


"The way in which the course is taught really opened my eyes to the power within Microsoft Office. The tutor was brilliant and the small class sizes were amazing. Microsoft Office has really modernised since I last used it back in 2005. It is always worth maintaining and improving your skills. I cannot think of any other company who teach as well as Computer Training Wales."


Gary, Manufacturing Administrator


Book Now Enquire Our Venue Brochure
Microsoft Access Intermediate Microsoft Access Microsoft Access

Course Rating

Course Ratings

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


Price £199 (no VAT) Time 9:00am-2:00pm 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.


Course Dates 2024 - Access Intermediate


June: 6th, 13th, 20th, 27th

July: 4th, 11th, 18th, 25th

August: 1st, 8th, 15th, 22nd, 29th

September: 5th, 12th, 19th, 26th

October: 3rd, 10th, 17th, 24th, 31st


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.

Choose us for exclusive face-to-face training with a remarkable two delegate on each session.


Our expert trainers in Microsoft Office, Engineering, and Design lead interactive workshops, ensuring personalised attention and a supportive atmosphere for your success.


Book Now Enquire Our Venue Brochure
Microsoft Access Advanced Microsoft Access Microsoft Access

Course Rating

Course Ratings

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


"The trainer's expertise and approachable style created a supportive learning environment, particularly beneficial for participants approaching advanced database concepts."

Ryan


Price £199 (no VAT) Time 9:00am-2:00pm 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.


Course Dates 2024 - Access Advanced


June: 6th, 13th, 20th, 27th

July: 4th, 11th, 18th, 25th

August: 1st, 8th, 15th, 22nd, 29th

September: 5th, 12th, 19th, 26th

October: 3rd, 10th, 17th, 24th, 31st


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

Our Clients