Microsoft Access 2010 Basics

Courseware Training Materials 

Foundation / Intermediate level computer training materials for delivering training to your students, staff or clients.  A courseware site licence allows you to train an unlimited number of people, at your training center using these teaching resources.

Training Course Outlines 

DATABASE CONCEPTS

• What is a database?
• Database Examples
• What is a relational database?
• What is a table?
• What is a record (row)?
• What is a field (column)?
• What is data?
• The difference between data and information
• Data types
• Common uses of large-scale databases
• Keeping data discrete
• Each field should contain only one item
• Database designers, database administrators and database users

OPENING A DATABASE & SECURITY ISSUES

• Opening a database within your samples folder
• Trusted Locations – Using the Trust Centre
• Setting the default folder location within Access
• 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
• Switching between ‘Datasheet View’ and ‘Design View’
• Adding records to a table
• Saving changes made to a table
• Navigating through records within a table
• Adjusting column width
• Automatically resizing a column with to fit contents
• Moving a column to rearrange 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 – Validation Rule Examples
• Field Properties – General
• Field Properties – Format
• Field Properties – Input Mask Characters
• Field Properties – Input Mask Examples

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
• Using Save As to backup the database using a different file name
• Deleting a table

PRIMARY KEYS AND INDEXING

• Defining a Primary Key
• Indexing - Reference Notes
• Creating a single-field Index
• Creating a multiple-field Index
• Deleting multi-field indexes

FILTERING

• Text Filters
• Applying a single filter
• Clearing a single filter
• Creating multiple filters
• Clearing multiple filters

SORTING

• Sorting Records A-Z
• Sorting records Z-A
• Removing a sort
• Sorting on multiple fields

SEARCHING

• Searching through records

RELATIONSHIPS

• Table relationships
• One-to-many relationship
• Many-to-many relationship
• One-to-one relationships
• Creating relationships between tables
• About Referential integrity
• Enabling Referential Integrity
• Cascade options
• Cascade update related fields
• Cascade delete related records
• Enabling cascade options
• Deleting relationships

FORMS

• Forms overview
• Creating forms
• Modifying forms
• Modifying a form title
• Changing a form logo
• Modifying a form label
• Saving a form
• Form View
• Adding and formatting attachments
• Modifying data within records
• Deleting records using a form
• Adding records using a form
• Adding or deleting text in a record using a form
• Closing forms
• Opening forms
• Deleting a form
• Filtering a form
• Removing a filter form a form
• Inserting and modifying a form header
• Inserting and modifying a form footer

QUERIES

• What are queries?
• Creating a simple query
• Adding (and removing) 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 your query
• What are Wildcards?
• Deleting a query
• Hiding and un-hiding fields (columns) within a query

REPORTS

• What are reports?
• Creating a simple 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

• What does exporting data mean?
• What is a spread sheet format?
• What is text only and CSV format?
• What is a PDF file?
• What is an XML file?
• Exporting a table as an Excel file
• Exporting a table as a text file (keeping data format & layout)
• Exporting a table as a text CSV formatted file
• Exporting a table as a PDF formatted file
• Exporting a table as an XML formatted file

PRINTING

• Considerations before printing
• Print previewing
• Which orientation, portrait or landscape?
• Adjusting layout in Print Preview
• Setting margins
• Printing a complete table
• Printing selected records
• Printing a query or reports
• Printing forms

REFERENCE: THE ACCESS 2010 INTERFACE

• Opening the Access 2010 program
• Opening a database within your samples folder
• Opening a table
• The Ribbon (Toolbar)
• Ribbon tabs
• Groups
• Dialog box launcher
• Navigating - Quick keys (shortcut keys)
• Navigating – Pointer keys & quick keys
• Contextual tabs
• Minimizing the Ribbon
• Quick Access Toolbar
• The File tab
• Microsoft Access Help
• Closing Access 2010
• Closing the Microsoft Access program