MICROSOFT

Enjoy the best in Access for Office 365: Part 2 Training

Microsoft® Access® for Office 365™: Part 2 (this course): Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.

ITIL Training

Microsoft Access for Office 365: Part 2

Your training and experience using Microsoft® Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users.

This course is the second part of a three-course series that covers the skills needed to perform database design and development in Access.

Online Labs

Objectives

In this course, you will optimize an Access database.

You will:

  • Provide input validation features to promote the entry of quality data into a database.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Improve the usability of Access tables.
  • Create advanced queries to join and summarize data.
  • Use advanced formatting and controls to improve form presentation.
  • Use advanced formatting and calculated fields to improve reports.
Online Labs

Lesson 1: Promoting Quality Data Input

Topic A: Restrict Data Input Through Field Validation

Topic B: Restrict Data Input Through Forms and Record Validation

Online Labs

Lesson 2: Improving Efficiency and Data Integrity

Topic A: Data Normalization

Topic B: Associate Unrelated Tables

Topic C: Enforce Referential Integrity

Online Labs

Lesson 3: Improving Table Usability

Topic A: Create Lookups Within a Table

Topic B: Work with Subdatasheets

Online Labs

Lesson 4: Creating Advanced Queries

Topic A: Create Query Joins

Topic B: Create Subqueries

Topic C: Summarize Data

Online Labs

Lesson 5: Improving Form Presentation

Topic A: Apply Conditional Formatting

Topic B: Create Tab Pages with Subforms and Other Controls

Online Labs

Lesson 6: Creating Advanced Reports

Topic A: Apply Advanced Formatting to a Report

Topic B: Add a Calculated Field to a Report

Topic C: Control Pagination and Print Quality

Topic D: Add a Chart to a Report

Online Labs

Intended Audience

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases and developing tables, queries, forms, and reports in Microsoft Access for Microsoft 365.

Online Labs

Prerequisites

To ensure your success in this course, it is recommended you have completed Microsoft® Access® for Office 365™: Part 1 or possess equivalent knowledge.

It is also suggested that you have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites. You can obtain this level of skills and knowledge by taking the following Logical Operations course, or any similar courses in general Microsoft Windows skills:

  • Using Microsoft® Windows® 10 (Second Edition)
    Toggle Filters
    Want to run this course in-house?
    None of these dates work for you?

    Get Azure Microsoft Access for Office 365: Part 2 Certified

    Our award winning superior training solutions are designed to help you set effective business goals and attain measurable business outcomes. With return clients and multiple testimonials, we have established ourselves as a premier training solution provider for corporate teams across the globe, providing nothing less than the best corporate training in the marketplace.

    aws training

    Client Testimonials

    Be wary of companies that pay external vendors to farm and post reviews, many of them are not authentic. Ours come straight from Google, you can’t alter reviews on Google Maps in any way. Don’t take our word for who we are – hear from our clients:

    5 Star Reviews

    We offer more than just Microsoft Access for Office 365: Part 2 Training

    We offer more than just Microsoft Access for Office 365: Part 2 Training

    Our successful training results keep our corporate and military clients returning. That’s because we provide everything you need to succeed. This is true for all of our courses.

    A+ training in panama beach

    STRATEGIC PLANNING AND PROJECT MANAGEMENT

    From Lean Six Sigma to PMI Project Management Professional, Agile and SCRUM , we offer the best-in-class strategic planning and project management training available.  We are here to train your team!

    A+ training in panama beach

    IT AND CYBERSECURITY

    As the leading Offensive Security US training provider, and a CompTIA and EC-Council award-winning training partner.  We offer the best cybersecurity and vendor driven IT training and certification courses to keep your team ahead of the technology skills curve.

    A+ training in panama beach

    LEADERSHIP AND MANAGEMENT

    Let us teach your team the high-level traits and micro-level tools & strategies of effective 21st-century leadership.  Empower your team to play to each others’ strengths, inspire others, and build a culture that values communication, authenticity, and community. 

    Looking For Microsoft Access for Office 365: Part 2 Training?

    Please reach out to us with any questions you might have. We welcome the opportunity to talk through your individual training needs, or that of your team. And no, we will not relentlessly hound you with sales calls, we promise!  We are a no pressure, service oriented company.

    Reach out – you’ll be glad you did!