Computer Training

Polar Solutions

ooooo

Microsoft Access 2016

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 2016 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 2016 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 - Introduction to Databases Database concepts Database layout Launching access. The access menu system Dialog boxes Getting help Creating a new database Closing a database (vs exit access) Opening a database Module 2 - Tables Database Design. Creating Tables Using the Table Wizard Creating Tables In The Datasheet View Creating Tables in the Design View Data Types Field Properties Data Display Format Vs Input Mask The Input Mask Data Entry Problems Moving and Copying Records Module 3 - Working with Tables Pasting Records Sorting the Table Deleting a Table Table Layout Changes Find Replace Wildcards Module 4 - Queries The Simple Query Wizard The Design View Modifying the Query Using Basic Criteria Additional Criteria Parameters Multiple Object Queries Custom Calculations in a Query Calculating Fields continued Grouping Fields Module 5 - Introduction to Reports Reports The Report Wizard Top of Page
Microsoft Access 2016 Level 2 Course Description You have the basic skills needed to work with Microsoft Office Access 2016 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 2016 with other applications. Pre-Requisites To ensure the successful completion of Microsoft Office Access 2016: Level 2, the completion of the Microsoft Office Access 2016: Level 1 course, or equivalent knowledge, is recommended. Course Content Module 1 - Queries Action Queries Types of Query The Crosstab Query The Make Table Query The Append Query The Delete Query The Update Query Module 2 - Customising forms Forms Manipulating Data in the Form Creating a New Form Using the Form Wizard Creating a Form with a Subform Modifying and Redesigning the Form. Modifying and Redesigning the Form Continued. Module 3 - Reports Reports The Report Wizard Creating a Report with Calculated Totals Using the Chart Wizard Altering the Chart Using the Label Wizard Modifying and Redesigning the Report. Publishing Access Data on the Web Module 4 - Database replication What is Database Replication? Creating and Maintaining a Replicated Database To use Briefcase to Create a Replica Changes made to a Replicated Database Synchronization Resolving Synchronisation Conflicts Convert a Replica set to Access 2016 (from Access 97) Top of Page
Microsoft Access 2016 Level 3 Course Description Your training in and use of Microsoft Office Access 2016 has provided you with a solid foundation in the basic and intermediate skills of working in Microsoft Office Access 2016. 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 2016 Level 1 and Microsoft Office Access 2016 Level 2. Course Content Module 1 - Managing Relational Databases Database Concepts. Database Design Normalisation Database Integrity Types of Relationship Creating Table Links Referential Integrity Module 2 - Advanced Forms Customising List and Combo Boxes Check Boxes, Option & Toggle Buttons. Option Groups Command Buttons Calculated Fields. Using Form’s Input Values Create a Form With Multiple Pages or Tabs Tab Order Inserting Graphics in Forms or Reports AutoFormat Module 3 - Optimising and Administering Access Optimising Performance The Performance Analyzer The Add in Manager Compacting Your Database The Database Documentor The Database Splitter Recovering Damaged Databases Importing and Linking Tables Module 4 - Advanced Forms Customising List and Combo Boxes Check Boxes, Option & Toggle Buttons. Option Groups Command Buttons Calculated Fields. Using Form’s Input Values Create a Form With Multiple Pages or Tabs Tab Order Inserting Graphics in Forms or Reports AutoFormat Module 5 - Database Security Securing a Database Adding a Database Password Setting User Level Security Workgroups Activating the Logon Procedure Creating and managing security accounts Creating a Security Group Account The Security Wizard Changing Ownership Assigning and Removing Permissions Encrypting and Decrypting a Database Top of Page