Microsoft Access
Course Overview:
Prerequisites
Participants should have a good level of PC and windows skills, but do not need prior experience with Access
Course Objectives
This course gives those who have little or no experience of working with MS Access a detailed introduction to this database software. During the course you will learn how to create a database with tables, forms, reports and queries. You also gain an understanding of the advantages that using an Access Database can bring to your job role or business.
Course Duration
Duration: 1 Day Classroom Training or Online
Course Contents
The subjects listed below are an outline. If there are any additional subjects you wish to cover, please feel free to call us prior to the course date. All of our courses can be tailored to meet your business needs.
Getting Started With Microsoft Access
• Microsoft Access Overview Database Design Theory
• What is a Relational Database?
• Screen Elements and Help
• Basic Window Elements
• Exploring Microsoft Office Backstage
• Working with The Ribbon
• Customizing the Quick Access Toolbar
• Working with KeyTips
Tables
• Using the Table Wizards
• Manual Creation of Tables
• Fields, Data Types and Properties
• Input Masks
• Data Validation
• Primary Keys and Relationships
Importing Data
• Importing from a Spreadsheet File
• Importing from a Text File
Inputting Data
• Adding Data using the Table View
• Adjusting the Column Widths
Finding Records
• Using the Find Feature to Find Records
• Using the Replace Feature to Replace Text
Filters
• Using the Filter Button to Find Records
Queries
• Designing Queries
• Query Wizard Overview
• Sorting and Searching Queries
• Multi-Table Relationship Queries
• Update, Append and Delete Action Queries
Forms
• Introduction to Form Design
• Form Wizards
• Toolbox Controls
• Combo Boxes and Command Buttons
• Main/Sub Form Creation
• Creating a Menu Form
Reports
• Report Wizard
• Creating Reports
• Printing Reports
Advanced Table Design
• Attachment Fields
• Multiple Value Fields
• Lookup Fields
• Advanced Field Properties Including Input Masks
• Multiple Field Primary Keys
• Multiple Field Indexes
• Using the Access Documenter
Relational Concepts
• Relational Concepts and Rules
• Data Structure Principles
• Types of Relationship
• Referential Integrity
• Relating Tables
Multiple Tables and Forms
• Using a Combo Box In Forms
• Combo Box Properties
• Lookup Properties
• Creating Forms with Subforms
• Editing Sub Forms
• Tabbed Sub Forms
• Embedding Sub Forms Using Drag and Drop
Advanced Select Queries
• Filter By Form
• Advanced Filter/Sort
• Convert Filter to Select Query
• Duplicate Records Query
• Unmatched Records Query
• Working with Multiple Tables
• Understanding Query Join Types
• Concatenating Fields
• Calculations in Queries
• Using String Functions
• Using Date Functions
• Using the Immediate If Function
• Using Wildcards and Parameters
Advanced Reports
• Working with Multiple Tables
• Concatenating Fields
• Date and Time Functions
• String Functions
• Custom Styles
PivotTables and PivotCharts
• Create a PivotTable
• Modify a PivotTable
• Working With a PivotChart
Creating Advanced Forms
• Designing a Form Based on Joined Tables
• Automating Data Entry
• Grouped Control
• How to Improve the User Interface
Subforms
• Designing, Creating and Adding Subforms
Macros
• Create and Run Macros
• Attach Macros to Events of Database Objects
• Creating Advanced Macros
• Create Macros to Provide User Interaction
• Create Macros Requiring User Decision
• Use AutoKeys and AutoExec Macros
• Exploring Access SQL
• How to Identify Different Clauses in an SQL Statement
• Writing SQL Statements
• Attach an SQL Statement to Database Objects
• Integrating the Internet
• Work with Hyperlink Fields
Managing Databases
• Work with Database Utilities To Optimize Resources
• Secure Data by Database Replication
• Security Fundamentals
• Protecting Databases
