35829 Design courses in Chippenham delivered Online

Learning Objectives Introduction , Designing Tables for Better Data Entry , Sharing Data with Other Applications , Working with Action Queries , Advanced Query Techniques , Automating Processes with Macros , Advanced Form Techniques , Advanced Report Techniques , Conclusion   Pre-Requisites Access 365 Beginner or equivalent experience.   Description This course is designed to teach students intermediate level skills in Microsoft Access 365. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques. This course prepares students for the Access 365 Advanced course.   Module 1: Design Tables for Better Data Entry Reviewing Table Design Principles 00:11:00 Setting Field Size, Formats, and Captions 00:11:00 Setting Default Values and Required Fields 00:05:00 Restricting Data Entry-Validation Rules 00:07:00 Restricting Data Entry-Input Masks 00:09:00 Module 2: Share Data with Other Apps Exporting Tables and Queries to Excel 00:05:00 Exporting Data to a SharePoint List 00:02:00 Importing Data from Excel 00:06:00 Importing Data from a SharePoint List 00:02:00 Linking External Data Sources 00:05:00 Using Word Merge 00:06:00 Module 3: Work with Action Queries What are Action Queries 00:04:00 Creating an Update Query 00:06:00 Creating an Append Query 00:04:00 Creating a Delete Query 00:04:00 Creating a Make Table Query 00:04:00 Changing Start Number of an Auto Number Field 00:04:00 Module 4: Advanced Query Techniques Modifying Query Joins 00:06:00 Using Self Joins to Combine Data 00:06:00 Creating Find Unmatched and Find Duplicate Queries 00:09:00 Creating Parameter Queries 00:05:00 Creating a Top X Query 00:02:00 Reviewing Calculated Query Fields 00:06:00 Summarizing Query Data with Totals 00:04:00 Creating Crosstab Queries 00:06:00 Module 5: Automate Processes with Macros Understanding Macro Basics 00:14:00 Creating Macros to Open Forms by Record 00:09:00 Validating Data Entry with Macros 00:10:00 Creating a Macro to Automate Data Entry 00:08:00 Advanced Data Entry Using Macros and DLOOKUP 00:11:00 Module 6: Advanced Form Techniques Using Conditional Formatting 00:04:00 Working with the New Label Name Property 00:03:00 Organizing Form Fields with Tab Controls 00:09:00 Creating an Option Group Control 00:06:00 Creating a Combo Box Control 00:04:00 Configuring a Combo Box Control to Show Search Results 00:04:00 Using a Subform to Show Data From a Related Table 00:06:00 Module 7: Advanced Report Techniques Inserting a Chart on a Report 00:07:00 Showing Data in Columns 00:07:00 Inserting a Subreport 00:05:00 Configuring Reports with Parameter Queries 00:03:00 Sending Reports 00:03:00 Resource Resource - Access 365 Intermediate 00:00:00 Final Exam Final Exam - Access 365 Intermediate 00:20:00

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 180 CPD Points | Lifetime Access

2 QLS Endorsed Course | CPD Certified | Free PDF + Hardcopy Certificates | 80 CPD Points | Lifetime Access

Fully Approved Course -  CPD and RoSPA Approved 100% online training, 260 minutes course Same Day Certificate Stop & start at anytime No time limit Course Description This course is designed for managers and supervisors to help them understand their essential day-to-day responsibilities. When a candidate passes this course, they will receive a certificate which demonstrates that they can supervise and train staff to handle food safely and hygienically.  This is a comprehensive course which starts with basic definitions of key words, then follows a logical path through other topics including the types of food hazards, personal hygiene, pest control, legislation, enforcement, and the design and cleaning of food premises and equipment. It also discusses how to implement a successful food safety management system. There's a wide range of topics because maintaining food safety and food hygiene is vital if you're to reduce the risk of food poisoning. The correct Food Safety Management System, professionally run, protects your customers, your staff, and the reputation of your company. Course Modules  Food Safety Legislation Hazards from Delivery to Service Risk Control (Prevention of Contamination) Pests, Premises and People Target Audience This course is aimed at supervisors and first line managers working in the food industry as well as small business owners responsible for running their premises and ensuring their staff are working safely and to the expected standards. It is also a natural progression from the level 2 courses in food safety and HACCP management for those who are taking on more responsibilities. Advantages Food business owners, supervisors and managers have legal duties in UK and EU law to ensure that they and their staff work and prepare food safely and in compliance with good practice. The course is approved by leading industry CPD Service in London and RoSPA. Dirextra is member of CPD Service. Online training is flexible, efficient and cost effective meaning the candidate can progress through the modules at their own pace and in their own time, so they can fit the training in around their work and personal life.

Discover the art of furniture restoration and interior decorating with our comprehensive course. Master wood finishing techniques, explore historical furniture periods, and develop skills in room analysis and decor selection. Perfect for aspiring restorers, decorators, and DIY enthusiasts.