Discover Classes. Earn Rewards.

Microsoft Access 2016: Level 2 (Online) is unfortunately unavailable

Thankfully we have 3 other Access Classes for you to choose from. Check our top choices below or see all classes for more options.

All Day Private Digital Photography (Denver) Deal

All Day Private Digital Photography (Denver)

Digital Photo Academy @ Cross Streets TBA, Denver, CO

Take your digital photography skills to the next level with a personalized, full-day session designed to cater to your unique interests and needs. Master camera settings, explore various shooting techniques, and learn post-capture editing tips to create stunning images. Elevate your photography game with a private session led by experienced instructors at Digital Photo Academy.

(146) All levels 15 and older
Now:
$540
Was:
$600
Gift it!
Half Day Private Digital Photography (Denver) Deal

Half Day Private Digital Photography (Denver)

Digital Photo Academy @ Cross Streets TBA, Denver, CO

Master the art of digital photography with personalized instruction and hands-on shooting in Denver. Explore various photography categories, learn about camera settings and techniques, and enhance your post-capture workflow. Limited spots are available, so book your private session now.

(146) All levels 15 and older
Now:
$315
Was:
$350
Gift it!

Using Microsoft Windows 11

Colorado Free University @ 7653 E 1st Pl, Denver, CO

Become more comfortable using Windows 11 and familiarize yourself with its user interface and basic capabilities in this course offered at Colorado Free University. Learn to work with locally installed and cloud-based apps, browse the internet, manage files and folders, and adjust basic settings. Prior experience with personal computers, desktop apps, and the internet is recommended.

(17) Beginner 18 and older
See all Access classes Denver

Microsoft Access 2016: Level 2 (Online)

  • Intermediate
  • 18 and older
  • $174
  • Virtual Learning
  • 7 hours

Start Dates (0)

  • $174
  • Virtual Learning
  • 7 hours
Showing 10 of 0

Class Description

Description

What you'll learn in this access class:

In Level 2 customize reports, join tables, modify table design and field properties, share data across applications.

Prerequisite: Microsoft Access Level 1 or equivalent knowledge.

Target Student: This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs. 

Overview: In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. 

Course Objectives: In this course, you will work with relational database structure, relationships, efficiency, integrity, and customization. You will: 

  • Design a relational database.
  • Join tables to retrieve data from unrelated tables.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Share data among Access and other applications.
  • Customize reports to organize the displayed information and produce specific print layouts.

Lesson 1: Designing a Relational Database

Topic A: Relational Database Design 

Topic B: Create a Table 

Topic C: Create Table Relationships 

Lesson 2: Joining Tables 

Topic A: Create Query Joins 

Topic B: Join Tables That Have No Common Fields 

Topic C: Relate Data within a Table 

Topic D: Work with Subdatasheets 

Topic E: Create Subqueries 

Lesson 3: Organizing a Database for Efficiency 

Topic A: Data Normalization 

Topic B: Create a Junction Table 

Topic C: Improve Table Structure 

Lesson 4: Sharing Data Across Applications 

Topic A: Import Data into Access 

Topic B: Export Data to Text File Formats 

Topic C: Export Access Data to Excel 

Topic D: Create a Mail Merge 

Lesson 5: Advanced Reporting 

Topic A: Organize Report Information 

Topic B: Format Reports 

Topic C: Include Control Formatting in a Report 

Topic D: Add a Calculated Field to a Report 

Topic E: Add a Subreport to an Existing Report

Note:

This course will be offered via Zoom. Register now and then the day before class the instructor will send you the link to attend. Look for an email with "CFU Zoom class" in the subject line. A good internet connection and a computer or device with a camera and mic are needed.

 Look for an email from your instructor with the subject line CFU Zoom class for the link. Be ready to log on and join the meeting 5-10 minutes prior to the class start time so you will be ready when class begins. If you have trouble using the link, just go to Zoom.us, click "Join a Meeting" and enter the meeting ID provided in the instructor's email.

Refund Policy

Refunds:

  • Refunds are given ONLY if the school cancels a class.

Class Credits & Transfers:

  • If you cannot attend a class you must contact CourseHorse at least 4 business days prior to your first class meeting. With 4 business days notice we can transfer you to another available class or give you a credit voucher to use towards another class in the future (credits are good for one year from date of issue and cannot be redeemed for cash). There will be a $7 transaction fee for dropping or transferring out of the original class.
  • With less than 4 business days notice a credit voucher for half of the class’s tuition will be issued to your account.
  • There are no credits issued for cancellations under 4 business days notice.

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at Colorado Free University (17)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 1740 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Colorado Free University

Colorado Free University is a life long learning center offering a wide array of skill-based and enrichment courses. More of a learning network than a traditional school, CFU draws its teachers from the community and all teachers are independent contractors. Classes are designed for busy adults who...

Read more about Colorado Free University

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Denver educator.

Colorado Free University

Colorado Free University

All classes at this location

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...