Business and Training Center > Summer Quarter > Database Management

NOTE: Are you a working parent? Call (425)640-1686.

Learn to create and manage simple database systems; learn the shortcuts and the most efficient ways to get basic tasks done. The concepts covered lay the foundation for more advanced Query features in Levels 2 and 3. Prerequisite: Windows Basic or database, spreadsheet or other PC experience. Textbook included. (6 hours)

6:00pm - 9:00pm TTh MAB 109

7/5/05-7/7/05 $125

9:00am - 4:00pm F MAB 109

8/5/05 $125

Learn to export and import data to and from programs like Excel, Lotus, SQL, dBase and Paradox; attach external databases to access the data; perform multiple table Select Queries; use Parameters in Queries and Reports and more. Prerequisite: Access for Windows Level 1 or comparable experience. Textbook included. (6 hours)

6:00pm - 9:00pm TTh MAB 109

7/12/05-7/14/05 $125

9:00am - 4:00pm F MAB 109

8/12/05 $125

Learn designing and building tables, developing Relationships, working with indexes, advanced field attributes, Lookup fields and the Table Analyzer. Will cover rules for normalizing tables. Prerequisite: Access Level 1 and 2 or comparable experience. Textbook included. (6 hours)

6:00pm - 9:00pm TTh MAB 109

7/19/05-7/21/05 $125

9:00am - 4:00pm F MAB 109

8/19/05 $125

Use Form Wizard to create Form/Sub Form forms with embedded tables; use Wizards to add List Boxes, Combo Boxes, Options lists and Command Buttons to your forms and more. Prerequisite: Access Level 1 and 2 or comparable experience. Textbook included. (6 hours)

6:00pm - 9:00pm MW MAB 107

5/23/05-5/25/05 $125

6:00pm - 9:00pm TTh MAB 109

7/26/05-7/28/05 $125

Use Add-In Manager to customize Form and Report wizards: document applications; discuss and work with advanced properties features and basic application development techniques; customize toolbars; build and work with template files. Prerequisite: Access Level 3 or comparable experience. Textbook included. (6 hours)

6:00pm - 9:00pm MW MAB 107

6/6/05-6/8/05 $125

6:00pm - 9:00pm TTh MAB 109

8/2/05-8/4/05 $125

Class is for experienced Access users. Students will progress from Level 5 skills. Work with progressively more elaborate macros to increase the power of your applications. Discuss when to use macros and when to use VBA programming. Introduce basic VBA programming concepts and structure. The VBA section of this course is Visual Basic for Applications within the Access environment, not Visual Basic Studio. Prerequisite: Access Level 5 or comparable experience. Strong Access background preferred. Form Design experience is mandatory. Textbook included. (12 hours)

9:00am - 4:00pm Sa MAB 107

6/11/05-6/18/05 $299

6:00pm - 9:00pm MW MAB 107

8/8/05-8/17/05 $299