Computer Training



Course Description


Course Length 1 Day - 8 Hour Class Session

Overview Students will learn how to enhance their database designs by using the principles of normalization and table relationships. Students also learn how to query multiple tables for data that is used in customized forms and reports. Additionally, students learn how to create data access pages to share data over an intranet or the Internet

Prerequisite Introduction to Personal Computers
Window 2000 Introduction  or Windows XP Introduction
Word 2000 Level 1
Word 2000 Level 2
Word 2000 Level 3
Excel 2000 Level 1
Excel 2000 Level 2
Excel 2000 Level 3
Access 2000 Level 1

Delivery Method Instructor-Led, Group Paced, Classroom-Delivery Learning Model with Structured Hands-On Activities

Benefits Students will learn how to take the guesswork out of creating databases by using data-normalization techniques. They will learn how to take advantage of relational database efficiency to maintain data. In addition, students will be able to save time by controlling data entry and automating tasks. Students will also benefit by becoming familiar with Access features that will enable them to customize forms and reports, and to share data over an intranet or the Internet by creating and using data access pages

Target Student Students enrolling in this course should understand the basics of creating and using database objects, including tables, queries, forms, and reports

What's Next Access 2000: Level 3 Advanced
In this course, students learn to create advanced queries, create more efficient forms and reports and work with macros.

Access 2000: Level 4- Introduction to Application Design
Students learn to create custom applications
students to create custom applications.

Objectives Normalize sample tables by identifying design problems.

Establish relationships between tables by analyzing table relationships and enforcing referential integrity.

Customize table designs by setting field properties to maintain data integrity, by creating a lookup list, and by creating indexes.

Design select queries by using multiple tables to calculate, group, average, and concatenate values and to show top values.

Customize form designs by creating calculated fields, combo boxes, and unbound controls.

Interact with data through a browser by creating and using data access pages.

Customize report designs by grouping, sorting, and summarizing data, and by adding subreports.

Please Contact Us For Class Outlines.



e-mail.gif (7997 bytes)To Contact Us:
Office:    (479) 452-4439
                   (888) 933-3579
    Fax:    (479) 452-4418
       Post Office Box 10783  

             Fort Smith, Arkansas 72917