Foundation Level Course Outline
Database Concepts
• Database
• Relational Database
• Table
• Record (Row)
• Field (Column)
• Data Types
Opening a Database & Security Issues
• Opening a Database
• Trusted Locations
• Setting the Default Folder Location
• Closing the Access Program
Tables, Fields and Field Types
• Creating a New Blank Database
• Adding Fields and Setting the Field Type
• About Access Data Types
• Closing and Naming a Table
Table Navigation & Modification
• Opening a Table within a Database
• ‘Datasheet View’ vs. ‘Design View’
• Adding Records to a Table
• Navigating Through Records
• Adjusting Column Width
• Automatically Resizing a Column Widths
• Rearranging the Column Order
Field Properties
• Field Properties
• Input Masks
• Validating Numbers
• Validating Dates
• Data Entry Required / Not Required
• Field Properties – Reference Materials
• Field Properties – Logical Operators
• Field Properties – General
• Field Properties – Format
• Field Properties – Input Mask Characters
Manipulating Tables & Records
• Renaming a Table
• Editing Data within a Record
• Deleting Data within a Record
• Using the Undo Command
• Deleting a Single Record
• Deleting Multiple Records
• Deleting a Table
Primary Keys and Indexing
• Defining a Primary Key
• Indexing
• Creating a Single-Field Index
• Creating a Multiple-Field Index
• Deleting Multi-Field Indexes
Filtering
• Text Filters
• Single Filter
• Multiple Filters
Sorting
• Sorting Records
• Removing a Sort
• Sorting on Multiple Fields
Searching
• Searching Through Records
Relationships
• One-To-Many Relationship
• Many-To-Many Relationship
• One-To-One Relationships
• Creating Relationships between Tables
• Referential Integrity
• Cascade Options
• Cascade Update Related Fields
• Cascade Delete Related Records
• Enabling Cascade Options
• Deleting Relationships
Forms
• Creating Forms
• Modifying Forms
• Saving a Form
• Form View
• Adding and Formatting Attachments
• Modifying Data within Records
• Deleting Records using a Form
• Adding Records using a Form
• Closing Forms
• Deleting a Form
• Filtering a Form
• Removing a Filter from a Form
• Inserting and Modifying a Form Header
• Inserting and Modifying a Form Footer
Intermediate Level Course Outline
Queries
• Creating a Query
• Adding Criteria to a Query
• Running a Query
• Editing Criteria In a Query
• Saving a Query
• Creating a Two Table Query and Sorting the results
• Refining a Query
• Wildcards
• Deleting a Query
• Hiding and Un-Hiding Query Fields
Reports
• Creating a Report
• Using the Report Wizard
• Modifying the Layout of a Report
• Widening a Report Column
• Modifying the Report Title
• Adding a Logo to a Report
• Formatting a Form using Themes
• Modifying Field Names within a Report
• Inserting and Formatting the Date & Time
• Adding Existing Fields to a Report
• Resizing Reports For Printing
• Totals
• Closing a Report
• Deleting a Report
Exporting
• Exporting a Table As an Excel File
• Exporting a Table As a Text File
• Exporting a Table As a Text CSV File
• Exporting a Table As a PDF File
• Exporting a Table As an XML File
Printing
• Print Previewing
• Portrait and Landscape
• Adjusting Layout In Print Preview
• Margins
• Printing a Complete Table
• Printing Selected Records
• Printing a Query or Reports
• Printing Forms
Reference: the Access 2010 Interface
• Opening a Database
• Opening a Table
• The Ribbon (Toolbar)
• Ribbon Tabs
• Groups
• Dialog Box Launcher
• Navigating
• Contextual Tabs
• Minimising the Ribbon
• The File Tab
• Microsoft Access Help
• Closing Access 2010
Database Terminology & Theory
• Database
• Table
• Record
• Field
• Field Data Types
• Field Properties
• Primary Key
• Types of Database
Trusted Locations
• Setting a trusted location
Fields
• Creating a Lookup within a Field.
• Modifying a Lookup within a Field.
• Deleting a Lookup within a Field.
• Creating an Input Mask.
• Modifying an Input Mask.
• Deleting an Input Mask.
• Modifying a Field to Require Data Entry.
• Modifying a Field So That It Does Not Require Data Entry.
Relationships
• Creating and modifying a One-To-One Relationship.
• Creating and modifying a One-To-Many Relationship.
• Creating and modifying a Many-To-Many Relationship using a
Junction Table.
• Enforcing Referential Integrity.
• Automatic Updating of Related Fields.
• Automatic Deletion of Related Records.
Joins
• Inner Join.
• Outer Join.
• Subtract Join.
• Self Join
Advanced Level Course Outline
Queries
• About Queries
• Update Query.
• Delete Query.
• Make Table Query.
• Append Query.
• Crosstab Query.
• Find Duplicates Query.
• Find Unmatched Records Query.
• One Variable Parameter Query.
• Two Variable Parameter Query.
• Using Wildcards In a Query:
• Maximum or Minimum Values In a Query.
• Using Calculated Fields That Perform Arithmetic Calculations.
• Grouping Information In a Query using Functions.
Forms
• Types of Form Controls
• Bound Controls Vs. Unbound Controls.
• Text Box.
• Combo Box.
• List Box.
• Check Box.
• Limit to List
• Distinct Values.
• Arithmetic Expressions.
• Logical Expressions.
• Modifying the Tab Order in a Form.
• Creating a Sub-Form.
• Linking a Sub-Form.
Reports
• Formatting Arithmetic Calculation Controls
• Applying a Running Sum For a Group or Over All
• Concatenating Fields within a Report.
• Inserting a Data Field In a Report Group.
• Inserting a Data Field In a Report Page.
• Inserting a Data Field In Report Headers and Footers.
• Sorting and Grouping Records In a Report By Field(S).
• Forcing Page Breaks For Groups In a Report.
• Creating a Linked Sub-Report.
Macros
• Creating Macros
• Assigning a Macro to a Command Button.
• Assigning a Macro to an Object.
• Assigning a Macro to a Control.
Linking Data
• Linking an Excel Workbook to a Database.
• Linking External Text Data In a TXT File
• Linking External Text Data In a CSV File
• Linking External Data to a Database using Existing Database
Files.
Importing Data
• Importing an Excel file.
• Importing a CSV Text file
• Importing a TXT file
• Importing an XML file
• Importing an Database File