17749 Courses delivered Online

Communication is the exchange of information, ideas, and feelings effectively between individuals. It encompasses various forms, including verbal, written, and non-verbal (body) language. This course is designed to provide you with the essential skills necessary to communicate confidently.

Communication is the exchange of information, ideas, and feelings effectively between individuals. It encompasses various forms, including verbal, written, and non-verbal (body) language. This course is designed to provide you with the essential skills necessary to communicate confidently.

Communication is the exchange of information, ideas, and feelings effectively between individuals. It encompasses various forms, including verbal, written, and non-verbal (body) language. This course is designed to provide you with the essential skills necessary to communicate confidently.

Communication is the exchange of information, ideas, and feelings effectively between individuals. It encompasses various forms, including verbal, written, and non-verbal (body) language. This course is designed to provide you with the essential skills necessary to communicate confidently.

Our 2023 online courses work in the same way that our classroom courses do, but they are completed via the online platform Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone. As with our face to face driver CPC training, completion of this remote learning course will gain you 7 hours towards your CPC. To book your place on the course, simply click on the link below, and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Course cost includes upload fee and VAT. £69.95 including VAT and DVSA upload fees of £8.75 per day.

Our 2023 online courses work in the same way that our classroom courses do, but they are completed via the online platform Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone. As with our face to face driver CPC training, completion of this remote learning course will gain you 7 hours towards your CPC. To book your place on the course, simply click on the link below, and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Course cost includes upload fee and VAT. £69.95 including VAT and DVSA upload fees of £8.75 per day.

Our 2023 online courses work in the same way that our classroom courses do, but they are completed via the online platform Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone. As with our face to face driver CPC training, completion of this remote learning course will gain you 7 hours towards your CPC. To book your place on the course, simply click on the link below, and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Course cost includes upload fee and VAT. £69.95 including VAT and DVSA upload fees of £8.75 per day.

Our 2023 online courses work in the same way that our classroom courses do, but they are completed via the online platform Zoom. The course can be completed on any device that the Zoom app can be used on, such as a PC, laptop, tablet or smart phone. As with our face to face driver CPC training, completion of this remote learning course will gain you 7 hours towards your CPC. To book your place on the course, simply click on the link below, and complete the online booking form. These details will be used to produce a registration document and provide you with a course certificate on successful completion of the course. Course cost includes upload fee and VAT. £69.95 including VAT and DVSA upload fees of £8.75 per day.

Course Objectives At the end of this course you will be able to: Identify the common objects of an Access database Design and build the structure of a database Input and maintain data Design user-friendly data entry forms Search the database using queries Generate reports from your data 1 year email support service Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level. Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses. Tailored in company training courses: You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs. Introducing Microsoft Access The Access interface Database terminology Access database objects Fields and records Properties Designing a database Planning and designing a table Creating fields Setting common field properties Defining key fields Working with table data Entering and editing data Sorting and filtering table records Deleting records Relationships Why use table relationships? Relationship types Referential Integrity Working with table subdatasheets Querying a database Creating simple Select Queries Specifying query criteria Sorting query results Adding calculated fields Designing Forms Creating simple forms for data entry Designing custom forms Working with form sections Creating sub forms Designing Reports Creating basic list reports Working with grouping and sorting in a report Adding totals to a report Who is this course for? Who is this course for? This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data. Requirements Requirements Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills Career path Career path Microsoft Office know-how can instantly increase your job prospects as well as your salary. 80 percent of job openings require spreadsheet and word-processing software skills

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