Computer Training

Polar Solutions

ooooo

Microsoft Access 365

Each level covers one day of training you can pick subjects from each level to make a custom course to save covering areas already known. Level 1 Level 2 Level 3
PDF Download
Microsoft Access 365 Level 1 Course Description Most organisations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access 365 relational database application. Course Objective You will create and modify new databases and their various objects. Pre-Requisites Students should have completed the following courses or possess equivalent knowledge before starting this course: Microsoft Windows 7 or Microsoft Windows 10. Course Content Module 1 - Starting Access Exploring the Environment Exploring the Database Objects Customising the Environment Accessing the Help Files Module 2 - Designing a New Database Understanding a Relational Database Define the Purpose of the Database Reviewing Existing Data that can be used Determine Field Types Group Fields into Tables Normalise Data Using Primary and Foreign Keys Understanding Table Relationships Module 3 - Building a Database Creating a New Database Creating a Table Managing Tables Creating Relationships between Tables Saving a Database as a Previous Version Modifying Table Data Sorting Records Working with Subdatasheet Module 4 - Creating Queries Filtering Records Creating a Query Adding Criteria to Queries Creating Calculated Fields to a Query Calculating a Record Group Module 5 - Creating Forms Using Forms to View Data Creating a Form Modifying the Design of a Form Module 6 - Creating Reports Viewing Reports Creating a Report Adding a Calculated Field to a Report Formatting Controls in a Report Apply an AutoFormat Style to a Report Printing a Report Top of Page
Microsoft Access 365 Level 2 Course Description You have the basic skills needed to work with Microsoft Office Access 365 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customise database components, and how to share Access data with other applications. Course Objective You will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft Office Access 365 with other applications. Pre-Requisites To ensure the successful completion of Microsoft Office Access 365: Level 2, the completion of the Microsoft Office Access 365: Level 1 course, or equivalent knowledge, is recommended. Course Content Module 1 - Managng Data Entry Restricting Data using Field Properties Creating Input Masks Creating Lookup Lists Module 2 - Crating Table Reiationships Creating Joins in Queries Joining Unrelated Tables Relate Data within a Table Module 3 - Advanced Queries Working with Query Properties Creating Parameter Queries Creating Action Queries Module 4 - Advanced Forms Design a Form Layout Enhance the Appearance of a Form Restrict Data Entry in Forms Adding a Command Button to a Form Creating a Subform Module 5 - Advanced Forms Managing Report Information Formatting a Report using AutoFormats Formatting a Report using Colour Controlling the Paragraph setting of a Report Summarising Report Information Creating Subreports Creating Mailing Labels Module 6 - Advanced Forms Importing Data into Access Exporting Data from Access Analysing Access Data in Excel Exporting Access data to a Text File Merge Access Data with Word Top of Page
Microsoft Access 365 Level 3 Course Description Your training in and use of Microsoft Office Access 365 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access 365. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialised and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database. Course Objective You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, making effective use of forms and reports, and performing database maintenance. Pre-Requisites To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following courses or equivalent knowledge are recommended: Microsoft Office Access 365 Level 1 and Microsoft Office Access 365 Level 2. Course Content Module 1 - Organisng Access Analysing Table Create a Junction Table Improve a Table Structure Module 2 - Writing Advanced Queries Creating Subqueries Finding Unmatched and Duplicated Records Group and Summarising Records Creating Crosstab Queries Module 3 - Developing Macros Creating a Macro Creating a Macro Button Creating Conditional Macros Creating Validation Macros Automate Data using a Macro Module 4 - Creating Efective Forms Creating Tab Pages on Forms Summarising Data in a Form Module 5 - Efective Reports Creating a Chart in Reports Grouping Data into Columns in a Report Prevent Printing Blank Reports Create a Report Snapshot Module 6 - Database Managment Tools Linking Tables to External Data Sources Manage a Database Determine Object Dependency Document a Database Analyse the Performance of a Database Top of Page