Access Basics | CSU Pro Dev

Courses

Access Basics

Course Description

This class is intended for beginners or people who are self-taught in Access. You will create databases and examine key concepts of the software. In addition, you will create tables, queries, forms and reports in this class.

Real-World Application

This course is for anyone who wishes to learn the basic operations of the Access database program to perform their day-to-day responsibilities, and who want to use the application to be more productive in their work. It provides the fundamental knowledge and techniques needed to use more complex Access features such as maintaining databases and using programming techniques that enhance Access applications.

Prerequisites

To be successful in this course, students should be familiar with personal computers (Windows Basics) and the use of a mouse and keyboard.

Course Objectives

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

  • Identify the basic components of an Access database
  • Build the structure of a database
  • Manage data in tables
  • Query a database
  • Design form
  • Generate reports

Course Content

Unit 1 – Getting started

  • Topic A: Database concepts
  • Topic B: Exploring the Access environment

Unit 2 – Databases and tables

  • Topic A: Planning and designing databases
  • Topic B: Exploring tables
  • Topic C: Creating tables

Unit 3 – Fields and records

  • Topic A: Changing the design of a table
  • Topic B: Finding and editing records
  • Topic C: Organizing records

Unit 4 – Data entry rules

  • Topic A: Setting field properties
  • Topic B: Working with input masks
  • Topic C: Setting validation rules

Unit 5 – Basic queries

  • Topic A: Creating and using queries
  • Topic B: Modifying query results and queries
  • Topic C: Performing operations in queries

Unit 6 – Using forms

  • Topic A: Create forms
  • Topic B: Using design view and layout view
  • Topic C: Sorting and filtering records

Unit 7 – Working with reports

  • Topic A: Creating reports
  • Topic B: Modifying and printing reports

Schedule

May 17, 2017
8:30 a.m.-4:30 p.m.
Location: CSU's Monte Ahuja College of Business, 1860 E. 18th St., Cleveland, OH 44115 (map)

CEUs: 0.7

Fee: $249

Corporate, CSU Student, Alumni and Organization membership discounts available!

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.

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.

Convenient: Flexible schedules are not only an attractive option, but a necessary for busy professionals.

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.

Corporate, Custom Availability: Can be custom-tailored to the needs of your organization to provide skills your workforce can apply immediately as a corporate training if requested.

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.