Free Microsoft Office Training and MS Windows Training
HOME  |  Premium Edition IT Training Courses  |  FAQs  |  Schools, Colleges & Computer Training Companies  |  Contact Us  | Terms  |  Link to Us 

Free computer tutorials & full computer training courses, inc. Microsoft Word training, Excel training & MS Project training.  Other IT training courses include Microsoft Windows.

 

FREE 
Online Computer Training Courses for Microsoft Office and Microsoft Windows

Access 2007 Foundation Tutorial

Access 2007
Access 2007 Database Concepts
            What is a database?
            What is a relational database?
            What is a table?
            What is a record (row)?
            What is a field (column)?
            What is data?
            Data types
A First Look at Access 2007
            Opening Access 2007
            Exploring the Access 2007 window
            The Ribbon (Toolbar)
            Ribbon tabs
            Groups & Dialog Box Launcher
            Navigating - Quick keys (shortcut keys)
            Navigating – Pointer keys & quick keys
            Navigating – Mouse wheel
            Contextual tabs
            Minimizing the Ribbon
            Quick Access Toolbar
            The Office Button
            Microsoft Access Help
Opening a Database & Security Issues
            Opening a database
            Security warnings
            Trusted Locations - Trust Centre
            Setting the default folder location within Access
Creating a Database & Using Views
            Creating a new database
            Creating a new blank database
            Saving a table
            Adding and renaming fields
            Using Datasheet View
            Using Design View
            Changing the view
Table Modification and Navigation
            Adding Fields - Design View
            Data Type - Overview
            Data Type - Descriptions
            Using the Attachment data type
            Adjusting column width
            Moving a column to rearrange the column order
            Adding records to a table
            Navigating through records within a table
            Closing a database
            Navigation Pane
Field Properties, Validation & Input Masks
            Field Properties
            Input Mask
            Validation Rules
            Field Properties - Guides Tables
Manipulating Records & Tables
            Closing an Object - Table
            Renaming an Object - Table
            Editing data within a record
            Deleting data within a record
            Using the Undo command
            Deleting a single record
            Deleting multiple records
            Save As – Database Object
            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 & Sorting
            Text Filters
            Applying a single filter
            Clearing a single filter
            Creating multiple filters
            Clearing multiple filters
            Sorting
Relationships
            Table 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
Access 2007 Forms
            Forms overview
            Creating forms
            Modifying forms
            Modifying a form title
            Modifying a form logo
            Modifying a form label
            Saving a form
            Form View
            Adding and formatting attachments
            Modifying records
            Deleting records
            Adding records
            Closing forms
            Opening forms
            Deleting a form
Access 2007 Queries
            What are queries?
            Creating a simple 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
            Deleting a query
Access 2007 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 logos to a report
            Autoformating a report
            Modifying field names within a report
            Inserting and formatting the date & time
            Adding available fields to a report
            Resizing reports for printing
            Closing a report
            Deleting a report
Access 2007 Printing Issues
            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

    

FOR INDIVIDUAL USE ONLY – NOT TO BE DOWNLOADED
Copyright 'Best Computer Training Courses' - www.BestComputerTrainingCourses.com

Microsoft Access Training Courses

Other Computer Tutorials

 
 

 
 

Free Microsoft Office & Microsoft Windows computer training courses inc. Microsoft Word training courses, Excel training courses, PowerPoint training courses.  Microsoft Office 2010 & Windows 7 manuals also available. 
© 2011 Best Computer Training Courses - Search Engine SEO by http://www.WebSiteSEOAustralia.com.au

  

www.BestComputerTrainingCourses.com