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 XP Foundation Training Course

Microsoft Access XP
Introduction to Microsoft Access 2002
      What is Access?
            Access 2002
            Content
            Delivery
      Creating Files
            About Access 2002 Files
            Creating a new database file
      Opening and Closing a Database File
            Opening a database file
            Closing a database file
      Review Questions
Access 2002 Interface
      Access 2002 Workspace
            Using the Menu bar
            Using the Database toolbar
            Using the Task Pane
            Using the Status bar
            Using the Office Assistant
            Customizing the toolbars
      Review Questions
The Database Toolbar
      Using the Database Toolbar
            Using the Database Toolbar
            Using the New button
            Using the Open button
            Using the Save button
            Using the Search button
            Using the Print button
            Using the Print Preview button
            Using the Spelling button
            Using the Cut button
            Using the Copy button
            Using the Paste button
            Using the Undo button
            Using the OfficeLinks button
            Using the Analyze button
            Using the Code button
            Using the Microsoft Script Editor button
            Using the Properties button
            Using the Relationships button
            Using the New Object: <Object Type> button
            Using the Microsoft Access Help button
      Review Questions
The Task Pane
      Using the Open a File Area of the New File Task Pane
            Opening the New File task pane
            Viewing and opening recent files
      Using the New Area of the New File Task Pane
            Using the Blank Database option
            Data Access Page option
            Using the Project (Existing Data) option
            Using the Project (New Data) option
      Using the New From Existing File Area of the New File Task Pane
            Using the Choose File option
      Using the New From Template Area of the New File Task Pane
            Using the General Templates option
            Using the Templates On Microsoft.com option
      Using the Clipboard Task Pane
            About the Office Clipboard feature
            Opening the Clipboard task pane
            Using the Office Clipboard feature
      Using the Search Task Panes
            About the Search feature
            Opening the Search task pane
            Using the Search feature
      Review Questions
The Database Window
      The Database Menu Bar
            Using the Database Menu Bar
            Using the Open button
            Using the Design button
            Using the New button
            Using the Delete button
            Using the Icon buttons
            Using the List button
            Using the Details button
      The Database Window Toolbar
            About the Groups feature
            Using Groups in the Toolbar
            Using the Favorites button
            Using the Tables button
            Using the Queries button
            Using the Forms button
            Using the Reports button
            Using the Pages button
            Using the Macros button
            Using the Modules button
      Review Questions
Tables
      Create a Table
            About creating a table in Design view
            Creating a Table in Design View
            About using the Table Wizard to create a table
            Using the Table Wizard to create a table
      Working with Tables
            About changing a table design
            Changing a table design
            Adding records
            Finding Records
            Editing records
            About filtering records
            Filtering records
            About sorting records
            Sorting records
      Review Questions
Queries
      Create a Query
            About queries
            About creating a new query in Design view
            Requirements for a query in Design view
            Creating a new query in Design view
            About creating a new query using a wizard
            Creating a numerical query using the wizard
            Creating a non-numerical query using the wizard
            Saving queries
            Opening an existing query’s result window
            Open an existing query in Design view
            Refining the results of a query
            About adding calculations to a query in Design view
            Adding calculations in Design view
      Review Questions
Forms
      Using and Creating Forms
            Using Forms
            Creating forms with the wizard:
            Creating a simple form from scratch in Design view
            Modifying a form in Design view
            Using a form to locate information
            Using a form to organize information effectively
      Displaying and Linking Images
            About inserting images
            Inserting the same background image for all records:
            Inserting an image that does not change from record to record
            Inserting an image that is particular just to one record
            Replacing an image
      Review Questions
Reports
      Creating and Using Reports
            Using Reports
            Creating a report using AutoReport
            Creating a report using a wizard
            Creating a report from scratch in Design view
            About totals or averages in a report
            Creating a report with totals or averages
      Saving, Maintaining, and Printing Reports
            Saving a report
            Setting report properties
            Previewing a report (before you print it)
            Printing a report
      Review Questions


    


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