Courses

Access Advanced

Course Description

This class is intended for Access users that are ready to learn advanced Access features such as database management, advanced form design, macros, and more. Participants that are database administrators or prospective database administrators will find this course useful.

Real-World Application

This course is for the individual whose job responsibilities include database administration. Working with advanced form design; writing macros to automate common tasks; and performing general database maintenance. 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 courses Access Introduction and Access Intermediate or equivalent knowledge.

Course Objectives

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

  • Customize a form layout to improve usability and efficiency of data entry
  • Add user interface features to validate data entry
  • Use macros to improve user interface design
  • dependency and minimize redundancy
  • Lock down and prepare a database for distribution to multiple users
  • Create and modify a database switchboard and set the startup options

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.