Skip to main content
Western Kentucky University
EMERGENCY ALERT SYSTEM:

WKU WEATHER ALERT:

WKU offices in Bowling Green will open at 10 a.m. Friday. Classes Friday remain canceled and campuses in Glasgow, Owensboro and Elizabethtown/Ft. Knox remain closed Friday. Saturday classes in Bowling Green will proceed as scheduled. Here is a link to the University’s attendance policy during adverse weather conditions. Use caution and watch for slick spots on roads and walks. 

Residence Halls remain open until noon Saturday. Bemis & Barnes have space for those who need to stay longer. Visit WKU Housing & Residence Life for more information.

The high school regional basketball tournament games scheduled for Wednesday night were canceled. Games will be rescheduled for Friday/Saturday. Follow WKU News for the latest updates. #WKUAlert

CWD: Courses: Computer Training

Print this page

Intermediate Access 2010

Session Format:

4 Hours Total (One 4-Hour Session)

Introduction

This course addresses more advanced design of databases and query design. Topics emphasized include report design and customization of forms and tables.

Objectives

The participant will learn: (1) intermediate level database application design, (2) to customize forms with controls, properties, and expressions, (3) more complex query design, (4) report design using controls, properties, expressions, (5) table properties and indices, (6) enforcing referential integrity, and (7) to create macros for use with forms and reports.

Content Outline

  • Application design concepts
  • Forms controls and properties, forms with multiple tables
  • Select queries in forms, reports, and with calculators
  • Parameter queries, macro basics
  • Reports using controls, properties, table properties; indexing a table
  • Cascading updates and deletes

Who Should Attend

This seminar is intended for individuals who have basic knowledge of database application design and understand the usage of forms and terminology.

(Prerequisite: Introduction to Access 2010)

Note: documents in Portable Document Format (PDF) require Adobe Acrobat Reader 5.0 or higher to view,
download Adobe Acrobat Reader.

Note: documents in Excel format (XLS) require Microsoft Viewer,
download excel.

Note: documents in Word format (DOC) require Microsoft Viewer,
download word.

Note: documents in Powerpoint format (PPT) require Microsoft Viewer,
download powerpoint.

Note: documents in Quicktime Movie format [MOV] require Apple Quicktime,
download quicktime.

 
 Last Modified 9/24/14