 |
    Access
Overview: This course presents the basic concepts of Access 2003. Students will be introduced to Access features and the steps required to use such features as identifying database components, designing Data Tables, and designing relational databases. Then the student will examine the database window, tables, queries, forms, and reports. They will learn how to create and modifying new databases, and create and navigate in tables. The student will be introduced to working with records by modifying the datasheet layout, and how to add, edit, delete, and sort records. While working with the table structure they will also modify the table design, and set field properties. They will cover finding records, understanding comparison operators, and how to use filters. They will learn to create queries, add fields to queries, and specify query criteria. They will also learn to create, modify, and enhance forms and reports. Prerequisites: A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance of a course. < PC Skills | Schedule | Sign Up > Access Intermediate Overview: In this course, students will learn how to examine table relationships, relate tables, in forms referential integrity, and print table relationships. Then the student will work with related tables, using lookup fields, and sub-datasheets. They will learn how to use sub-forms and review field properties using input masks and validation rules. Students will be introduced to using advanced form features by adding pictures to records, using calculated controls, and improving accuracy in forms. They will use advanced report features by customizing headers and footers, concatenating text fields, forcing pagination, and working with sub-reports. They will also learn about joining tables in a query, performing calculations in a query and displaying and optimizing queries using indexes. Prerequisites: Access 2003 Introduction. Students should have some experience with creating a basic database in Access (including table design and specifying field data types and properties); of adding and editing data; and using wizards to create queries, forms and reports. < PC Skills | Schedule | Sign Up > Access Advanced Overview: This course presents the introduction to application development skill for Access 2003. Students in this course will learn how to examine the application development process by previewing and existing application, and deciding where to automat. Then students will use the controls. Students will also be introduced to setting dialog box form properties and creating, attaching and using macros. They will cover restricting user access to fields, setting properties and specifying default values for fields and setting visible properties. They will also learn boxes. Lastly students will learn how to create switchboard forms, use the database splitter, and how to protect and replicate databases. Prerequisites: Access Intermediate. Students must be able to create tables and queries in design view, use wizards to create forms and reports and make basic modifications in design view. < PC Skills | Schedule | Sign Up >
Access EXTREME! Overview: This course is designed to take the skills you have learned in the other three courses and use them to build a database from start to finish. You will learn how to make buttons open forms and run queries and reports, as well as perform functions such as moving records from one table to another and opening and closing your database. Course Duration: 1 day (9am - 5pm) Prerequisites: Access Advanced. Students must be able to create tables and queries in design view, create forms and reports in design view and write basic macros. < PC Skills | Schedule | Sign Up >
Each newsletter contains useful, and fun to read, articles including: Information that Top Leaders and Managers use to build good Customer Service Skills,
Executive Training Resources
www.etrdirect.com Certified Instructors Professional, Local, & Affordable |
email