Access Intermediate Class

Microsoft Access is a powerful data management tool in which one can consolidate and track various types of inter-related information, and generate reports to analyze the data in order to make better business decisions. AcademyX's Access Intermediate class will take you beyond the basics, giving you experience with Access's more advanced capabilities. Upon completing this course, you will be thoroughly versed in the precepts of data normalization and effective database design, so that you can quickly author sophisticated queries to seek exactly the necessary data to answer complex business problems. Students will also learn to create forms which are well-suited to the users' perspectives and needs, and create charts and graphs which express the data with visual impact and clarity. Our instructors will share their broad base of Access experience, in order to help you attain the practical knowledge and skills necessary to put the advanced functionality of this data management system to work for you.

How Table Relationships Affect Queries

Creating Relationships Between Tables
Add Relationship Security

Controlling Query Results with Join Types

How Relationships Affect Query Results
Using Join-Types to Affect Query Results

Creating Complex Queries with Multiple Criteria

Applying Wildcards
Using And / Or Conditions

Calculating Data with Queries

Create Custom Fields with Calculations
Summarize Data with Grouping

Automating Queries with Parameters

Creating Automated Requests for Criteria
Using Wildcards in Parameter Queries
Using Range Operators in Parameter Queries

Using Query Wizards

Getting Non-Matching Records with the Un-Matched Query Wizard
Finding Duplicate Records with the Duplicate Query Wizard

Exploring Action Queries

Create Tables with a Make-Table Query
Add Records to a Table with an Append Query
Change Data with an Update Query
Delete Data with a Delete Query

Advanced Report Design Techniques

Understanding Report Control Types
Grouping Report Data
Summarizing Report Data

Prerequisites:

A solid understanding of Windows file management, the concepts of right-clicking and selecting object properties
Successful completion of Access Introduction class or equivalent experience providing a basic understanding of tables, queries, forms and reports