Home

About Us

Catalog Main Catalog Microsoft Access Courses Database Development Courses Discounts and Passports Miscellaneous Fees & Services SQL Courses

Contact Us

AIN100A$: Microsoft Access Training Level 1 Book List | Course Links
Tuition: $195.00 per student Length: 1 day
Synopsis: 1 day introductory Microsoft Access course covering databases, tables, the datasheet, sorting and manipulating tables, basic queries, reports and forms. Using our courseware students will work on several small database applications during this course. These can be tailored to the needs of a custom group or private training student. No prior knowledge of Access is assumed. The next class in sequence is AIN100B Microsoft Access level 2.Following the class students will have on-going access to online materials such as videos and assesments.
Formats: Custom scheduled corporate groups (min. 2 students) at your facility or via Remote Learning. Single individuals may arrange a private online session.
Scheduling: Flexible to suit your requirements. Both onsite and online classes are custom scheduled.
Group Discounts: 2-4 students 20%, 5-8 30%, >8 quote

Session 1	Tables, Relationships, and Data	3.0 Hours
	Getting Started with Access Databases Identify the Elements of the Access Interface Identify the Components of a Database Examine the Relational Database Design Process Building the Structure of a Database Create a New Database Create a Table Manage Tables Establish Table Relationships Managing Data in a Table Modify Table Data Sort and Filter Records Work with Subdatasheets
Session 2	Queries, Forms and Reports	3.0 Hours
	Querying a Database Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping Designing Forms Create a Form Modify the Design of a Form View and Edit Data Using an Access Form Generating Reports Create a Report Add a Control to a Report Format the Controls in a Report Enhance the Appearance of a Report Prepare a Report for Print

Materials: Students will receive a comprehensive manual and a training certificate.   Location: Classes are normally taught on-site at your facilities or via online Remote Learning. Related Services Need help with a project? We may also provide programming and consulting services covering the above material. See Programming and Consulting for more information.