Access Intermediate | CSU Pro Dev

Courses

Access Intermediate

Course Description

This class is intended for Access 2013 users that have a basic understanding of the application and wish to gain intermediate level skills. Anyone who needs to construct relational databases, perform database maintenance, create advanced queries and reports, and integrate Access with other programs will find this course useful.

Real-World Application

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. Extending your knowledge of Microsoft Access will result in a robust, functional database for your users.

Prerequisites

Knowledge of the Microsoft Windows operating system, minimizing and maximizing windows, opening, saving and closing files. Completion of the course Access Introduction or equivalent knowledge.

Course Objectives

Upon successful completion of the course, participants will be able to:

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

Course Content

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

Schedule

This course is available online. Please call 216.687.6957 or email prodev@csuohio.edu if you are interested.

CEUs: 0.7

Course Benefits

Competency-based Professional Development: Our programs increase learner retention through application, which results in a more productive workforce.  Students demonstrate their competence by successfully completing a course assessment.

Digital credentials: Digital credentials give employers, clients and colleagues the ability to instantly verify student mastery of learning and see what the earned credential qualifies the student to do.

All Inclusive: Each course delivered at CSU includes materials, pre-test and post-test, coffee, snacks, lunch and convenient, on-site parking.

Educated and Experienced Instructors: Our instructors bring years of real-world, classroom and CPA, CFA, SHRM, PhD and MBA experience. Many hold leadership positions in northeast Ohio organizations and have taught at the graduate and undergraduate levels.

Cost-effective: The course is designed to minimize travel expenses and time away from work.

Networking Opportunities: Learn from instructors and colleagues who have a variety of industry experiences to share.

Audit option: Students have the option to audit a course they have already attended at no charge within one academic year. Interested students must notify the ProDev office requesting to audit a course a minimum of 10 business days prior to the course start date to ensure there is enough seating. Audit students are responsible for their own parking and lunches. New materials will not be provided.

Refund Policy

No refunds will be issued if notification is not received seven business days prior to the first day of class. Registrants who cancel will receive a refund, less a $50 processing fee, if we receive written notification a minimum of seven business days prior to the first day of class.