Access 2003 Basic, 2nd Edition + CertBlaster Study Guide

1-4188-8922-9 © 2007 Publish date: February 10, 2006 220 pages

Buy Now: $25.99

Course ID: access-2003-basic-2nd-sg

Learn the ins and outs of Microsoft Access and concepts of relational databases by choosing from our selection of computer training books dedicated to the Microsoft Office suite of programs. The Access 2003 Basic study guide focuses on basic functions and features of Microsoft Access so that you can get up to speed and begin using this powerful program.

The Access 2003 Basic courseware is highly rated with a 4.9/5.0 score in overall quality from ProCert Labs. Use this training manual to learn about the basic functions and features of Access 2003 including how to plan and develop a database, how to work with tables, how to create queries and forms, how to filter records, and how to generate reports.

If you are on track for getting your Microsoft Office Specialist certification from Microsoft, choosing the Access 2003 Basic courseware is an excellent choice because it is an approved course for this credential. You'll learn the fundamentals and be ready to begin creating your own databases using powerful features.

You can follow this courseware on your own time and get the basic skills without stepping into a single class or lecture. After the course, use the study guide as a reference whenever you work with Access databases.

Course Objectives

By following this course, you will learn:

• How to organize data with a database management system
• How to start Access and open Access databases
• How to use the Help feature
• How to plan and create databases
• How to use the Datasheet and Design views
• How to create and use tables
• How to modify a table's design
• How to use the Find feature and the spelling checker
• How to sort, filter, and delete records
• How to set field properties
• How to create input masks, set validation rules, and how to create single and multiple field indexes
• How to work with queries
• How to work with forms
• How to use AutoReport, the Report Wizard, Design view, and queries for working with reports

Course Contents

Unit 1 introduces Microsoft Access

• Database concepts
• Exploring Microsoft Access's environment
• Getting help using Access
• Closing databases and Microsoft Access

Unit 2 covers databases and tables

• Planning and designing a database
• A look at tables
• How to create tables

Unit 3 discusses fields and records

• How to change the design of a table
• Finding and editing records
• How to organize records

Unit 4 covers data entry rules

• How to set field properties
• Using input masks
• How to set validation rules
• Working with indexes

Unit 5 discusses simple queries

• Creating and using queries
• Modifying query results and queries
• How to perform operations in queries

Unit 6 covers working with forms

• Creating forms
• Working with the Form Wizard
• Design view
• Finding, sorting, and filtering records

Unit 7 talks about using reports

• How to create reports
• How to modify and pring reports

Appendix A contains the Microsoft Office Specialist exam objectives map