Home

About Us

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

Contact Us

AIN100: Introduction to Microsoft Access Book List | Course Links
Tuition: $295.00 per student Length: 2 days
Synopsis: 2 day introductory course to Microsoft Access, the leading desktop database. Covers databases, tables, the datasheet, sorting and manipulating tables, import/export, queries, forms and reports. Using our supplied courseware, students will work on several small database application during this course. These database can be tailored to the needs of custom groups or private training students. No prior knowledge of Access is assumed. As part of our courseware platform students have online access to course materials such as checklists, videos and assessments.
Formats: This course is a discounted package combining the following two courses: AIN100A and AIN100B. Please see those courses for available formats.
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 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
Session 3	Tables and Queries in Depth	3.0 Hours
	Controlling Data Entry Constrain Data Entry Using Field Properties Establish Data Entry Formats for Entering Field Values Create a List of Values for a Field Joining Tables Create Query Joins Join Tables That Have No Common Fields Relate Data Within a Table Creating Flexible Queries Set the Select Query Properties Retrieve Records Based on Input Criteria Create Action Queries
Session 4	More on Forms and Reports; Sharing Data	3.0 Hours
	Improving forms Restrict Data Entry in Forms Organize Information with Tab Pages Add a Command Button to a Form Create a Sub form Display a Summary of Data in a Form Change the Display of Data Conditionally Customizing reports Organize Report Information Format Reports Control Report Pagination Add a Calculated Field to a Report Add a Sub report to an Existing Report Create a Mailing Label Report Sharing data across applications Import Data into Access Export Data to Text File Formats Export Access Data to Excel Create a Mail Merge

Materials: Students will receive two comprehensive manuals and a training certificate.   Location: Classes are normally taught on-site at your facilities or via online Remote Learning. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested. 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.