Microsoft Access 2016: Level 2 (Online)
- Intermediate
- 18 and older
- $174
- Virtual Learning
- 7 hours
Thankfully we have 3 other Access Classes for you to choose from. Check our top choices below or see all classes for more options.
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.
Apr 3rd
10am–4pm MDT
Apr 4th
10am–4pm MDT
Apr 5th
10am–4pm MDT
Apr 6th
10am–4pm MDT
Apr 7th
10am–4pm MDT
This class has 23 more dates.
Tap here to see more
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.
Apr 3rd
10am–1pm MDT
Apr 4th
10am–1pm MDT
Apr 5th
10am–1pm MDT
Apr 6th
10am–1pm MDT
Apr 7th
10am–1pm MDT
This class has 23 more dates.
Tap here to see more
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.
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:
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.
Refunds:
Class Credits & Transfers:
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.
Get quick answers from CourseHorse and past students.
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
This school has been carefully vetted by CourseHorse and is a verified Denver educator.
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.
More in Microsoft Office
Get special date and rate options for your group. Submit the form below and we'll get back to you within 2 business hours with pricing and availability.