Microsoft Access™ 97, 2000, & XP 
                                                                 

Microsoft Access™ is a comprehensive Database Management System (DBMS), which stores data in simple-entry format. Access is the ideal choice for all database use, especially involving multiple databases, or complex sorting and filtering operations.

The real value, however, of using Microsoft Access™ as a database is in the highly flexible input & output methods, in terms of forms and reports.  Microsoft Access™ is also extremely interactive with Microsoft Excel™ for use of imported databanks and charts.  Through development of customized database systems for our Clients, we have developed a simple approach to database creation, use and management within our training material.

Level I:

• Database structure
• Access database components
• Database creation
• Creating a table within the database
• Tables – primary keys
• Relationships
• Form creation using autoform
• Entering data & editing forms
• Deleting record
• Re-sizing columns
• Changing field order
• Sorting data
• Introduction to queries

Level II:

• Simple reports
• Queries involving calculation
• Reports using multiple tables
• Forms using automatic fill from queries
• Joining two or more databases
• Handling duplicate records                                                         

Biography     Services     Contact Us     Other links     Home     Training Schedule  Training Materials