This course teaches students intermediate Access skills, including how to enhance your database designs by using the principles of table relationships and referential integrity, integrate data with other applications, modify a table design to control data entry, find data with filters and queries, customize forms and reports, and create data access pages. Students will also learn many additional intermediate-level skills, particularly those related to creating more complex queries, customizing your forms and reports, and broadening the availability of your data. This course also serves as a prerequisite for persons interested in learning more advanced skills and features.
To ensure your success, we recommend you first take the following course or have equivalent knowledge: MS Access Level 1.
Upon successful completion of this course, students will be able to:
- Share data with other applications and enforce referential integrity.
- Modify the design of a table to streamline data entry and maintain data integrity.
- Use a filter to show you records in a datasheet or a form that match whatever conditions you specify, and you will generate different query results by creating different types of joins between tables.
- Create select queries that display special records and you will design other types of queries, including parameter and action queries.
- Create forms and change their designs to enhance the appearance and usability of a form and to make your form more professional.
- Create reports and change their designs to better organize and summarize information and to improve the appearance by enhancing data layout and working with report pagination.
- Create and work with data access pages.
Lesson 1: Managing a Database and Data
Topic 1A: Import Data
Topic 1B: Maintain Record Integrity
Topic 1C: Exporting Data
Topic 1D: Documenting Table Relationships
Lesson 2: Controlling Data Entry
Topic 2A: Make Data Entry More Accurate
Topic 2B: Make Data Entry More Efficient
Topic 2C: Facilitate Data Entry
Lesson 3: Finding and Joining Data
Topic 3A: Find Data with Filters
Topic 3B: Get the Correct Data with Query Joins
Topic 3C: Building Bridges Between the Data
Topic 3D: Relating Data within a Table
Lesson 4: Creating Flexible Queries
Topic 4A: Summarizing Data with Queries
Topic 4B: Enter Criteria on the Fly
Topic 4C: Maintain Data with Queries
Lesson 5: Improving Your Forms
Topic 5A: Enhance the Appearance of a Form
Topic 5B: Enhance the Usability of a Form
Topic 5C: Make Your Forms More Professional
Topic 5D: Display Form Data from Multiple Tables
Lesson 6: Customizing Your Reports
Topic 6A: Organize Report Information
Topic 6B: Enhancing Data Layout
Topic 6C: Working with Report Pagination
Topic 6D: Summarizing Information
Topic 6E: Add a Subreport to an Existing Report
Topic 6F: Creating Mailing Labels
Lesson 7: Making Your Data Available on the Web
Topic 7A: Create a Data Access Page
Topic 7B: Improving the Look of a Data Access Page
Topic 7C: Editing Data Using a Data Access Page
Topic 7D: Group Records in a Data Access Page