Access Expert Level
Upon successful completion of this course, students will be able to:
- 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.
|
|
||||||||||
- Access Level 1
Next Course(s):
- Access PowerUser Level
This course is included in these Certification Programs:
- Microsoft Office Specialist
- Certified Medical Administrative Assistant
Our Program is All-Inclusive:
- 8 hours of classroom instruction
- Unlimited supervised computer lab/practice time for 6 months
- A complete instruction manual
- Certificate upon completion
- Career Enhancement Services
- Full Placement Counseling
- Free Resume Review
- Job Placement Assistance
- Free Test Preparation
- Computer-Based Training Files
- Assessment Testing
- Internship Opportunities
- Guarantee: Retake the course for free until test passed and/or employed.
- Check the schedule
Topics:
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
