**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**



Access 2000 MOS Tutorial Details

Total Lessons: 8
Total Time: 22 hour(s)
Subscription Term: 12 month(s)

Click Here to buy the MOS-A2K Online Course Tutorial Now!

Summary:

This series is designed to help users prepare for Microsoft Access 2000 MOS certification. It shows how to create, plan, and modify databases and tables in Access 2000. It also covers sorting and filtering, creating queries, forms and reports, and advanced tasks such as saving Access objects as Web pages, importing data, and adding hyperlinks.

Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment

Lesson 1 Creating Databases - 3 hours

Objectives: After completing this course, students will be able to:
* Identify appropriate input and output for a database
* Plan a database
* Create a database with and without the wizard
* Select and print database objects

Lesson 2 Building Tables - 2 hours

Objectives: After completing this course, students will be able to:
* Explain the structure of a table, the data types used in the table, and the function of primary keys
* Create a table using the wizard
* Enter records into the table through a form or datasheet

Lesson 3 Modifying Tables - 3 hours

Objectives: After completing this course, students will be able to:
* Insert and delete records and fields
* Modify the appearance and structure of the table in Design View
* Change the size, format, and default value of fields
* Use the Lookup and Input Mask wizards

Lesson 4 Sorting and Filtering - 3 hours

Objectives: After completing this course, students will be able to:
* Sort records
* Create advanced sorts
* Search for records
* Apply and remove filters

Lesson 5 Relationships & Queries - 4 hours

Objectives: After completing this course, students will be able to:
* Define table relationships
* Display related records
* Specify query criteria
* Create calculated fields
* Create and modify multi-table queries

Lesson 6 Building Forms - 2 hours

Objectives: After completing this course, students will be able to:
* Create a form
* Edit the form in design view
* Add and modify controls
* Create and use calculated controls

Lesson 7 Producing Reports - 3 hours

Objectives: After completing this course, students will be able to:
* Describe the components of reports
* Create a report using the Report wizard
* Edit the report in design view
* Add and modify controls in a report
* Create and use calculated controls in a report

Lesson 8 Advanced Tasks - 2 hours

Objectives: After completing this course, students will be able to:
* Import data into a table
* Save an Access object as a Web page
* Add hyperlinks to an Access object
* Back up restore and compact a database