|
|
 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
|
Customisable
Courseware
