Access Introduction Course Content

Access Overview

• An overview of database elements, including tables, forms, queries and reports
• Creating a new blank database, planning and structuring a database

Creating Data Tables

• Creating new tables using various methods
• Understanding data types and adding descriptions
• Primary Key Fields
• Inserting, deleting and moving fields. Also working with field properties
• Importing and linking data from other Access databases, Excel sheets or CSv text files

Working with Table Data

• Adding, deleting and copying records
• Applying filters, select and form filters
• Using advanced filters and sorts
• Proofing tools, e.g. Spell Check, Find and Replace etc

Creating Select Queries

• Creating new queries using wizards and design views
• Adding, removing query fields
• Setting field criteria for all data types
• Using SQL query statements
• Calculated queries

Table Relationships

• Why create relationships between tables?
• Different types of relationships
• Conditions for setting up a relationship
• Referential Integrity, Cascade Update, Cascade Delete
• Inserting Subdatasheets, Removing Subdatasheets, Expanding and Contracting Subdatasheets
• Queries accross multiple tables, Query Joines

Creating Forms

• Creating new forms types and layouts
• Form deisgn views, adding, removing and aligning form controls
• Adding Unbound calculated controls
• Setting form and control properties
• Inserting Subforms
• Formatting forms

Creating Reports

• Creating new reports and report layouts
• Adding, removing and formatting controls in Report Design
• Grouping data and Sub Reports
• Form property settings

Exporting Data

• Exprting Table, Query and Report data to Excel
• Using Acces as datasource for Word Mailmerge
• Using Access as datasource for Excel Pivot Tables / Lists