This two-day course is designed to help delegates create a basic database and create links between the various tables.
English
Course is facilitated by a competent & experienced subject matter trainer, who utilises the following techniques to ensure that the session is practical and experiential:Â Questions; Discussion; Exercises & Assessments.
Any person who need to design an internal database system for their staff. This will ensure that data is captured correctly.
2 Days
Module 1 | What is Microsoft Access? What is a Database? Database Terminology Creating a Blank Database Creating a database using the Database Templates The Ribbon Saving, Closing & Opening a Database Understanding the Database Window Operating Modes Object Properties |
Module 2 | Creating Tables using the Table Wizard Creating a Table from Scratch Understanding Data Types & Formats Setting the Primary Key Editing Tables Working in the Datasheet Finding Records Using the Find & Replace Filter & Sort Tables Create Attachment Fields Create Hyperlink Fields |
Module 3 | Understanding Field Formats Editing Field Attributes Setting Value Limits using Validation Rules Setting Default Values Creating Required Fields Understanding & using Input Masks Defining Indexes Creating Lookup (Drop-down) Fields |
Module 4 | Understanding & Creating Forms Creating a Standard Form Creating a Multiple Items Form Creating a Split Form Using the Form Wizard to create Customised Forms Editing Forms Changing the Tab Order Searching & Filtering Data in the Form Using Calculated Fields in a Form |
Module 5 | Understanding & Creating Queries Creating Queries using the Query Wizard Viewing Query Results Creating a Select Query Sorting Query Results Use Criteria in a Query to Filter Data Using Multiple Criteria in a Query to Filter Data Understanding the AND OR Filter Criteria Creating Calculation Queries Understanding & Creating Action Queries Create Parameter Queries to Prompt for Filter Criteria |
Module 6 | Importing & Exporting Data Exporting Data to Excel Importing Data from Excel Exporting Data to a Text File or to Microsoft Word Importing Access Objects from other Access Databases |
Module 7 | Understanding Database Relationships Understanding Primary & Foreign Keys Creating Simple Relationships Creating Complex Relationships Understanding Referential Integrity Viewing Subdatasheets |
Module 8 | Creating Reports Creating AutoReports Creating Reports using the Report Wizard Modifying the Layout of a Report Adding Subtotals to a Report Using Calculated Fields Printing Reports |