Courses for Computer Training:
Introduction to Access 2007
4 Hours Total (One 4–Hour Session)
This course addresses the design and maintenance of a database system. Topics of emphasis are writing of data queries, data redundancy and validation, sorting, reporting, and database programming. The student will design, create and manipulate several databases and also write database programs.
The participant will learn: (1) introductory relational database design concepts, (2) to create database tables and define primary keys, (3) to create forms for entering, displaying and printing data, (4) to design select queries that will enable the user to choose records, sort records, and combine records from multiple tables, (5) to generate reports from the database, (6) to backup the database, and (7) the benefits of the Access wizards and help topics.
- Clarify the terminology associated with relational databases
- Explain the steps necessary to design a database
- Learn how to create and manipulate a table
- Comprehend referential integrity conditions and explain how to enforce them
- Clarify the usage of forms
Who Should Attend
This seminar is intended for individuals with little prior database experience but some with the Microsoft Office products.
Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.
Note: documents in Excel format (XLS) require Microsoft Viewer,
Note: documents in Word format (DOC) require Microsoft Viewer,
Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,