2335

Access Level II

 

Shoring Up the Database

 

Suggested Prerequisites: Access Level I

Description: Access Level II is designed to take the participant to the next level beyond the basics. Level II adds data validation, end-user enhancements, more advanced data manipulation, and system automation. This course, which offers a more full understanding of Access, flows naturally into the Access Level III course, which steps up each of the Level II topics and focuses heavily on data manipulation and end-user strategies.

Topics

 

Review

Rules of Normalization

Relationships

  • The Relationship Window
  • Creating One-to-One Relationships
  • Creating One-to-Many Relationships
  • The Road Map

Table Design Properties

  • Field Descriptions
  • Input Mask
  • Default Values
  • Validation Rules and Text

Queries and Calculations

  • Math Operations
  • The Totals Tool
  • Concatenation

Form Enhancements

  • Adding a Combo Box
  • Rectangles
  • Adding a Logo
  • Adding Additional Fields

Report Enhancements

  • Sorting and Grouping
  • The Summary Line
  • Subreports
Access Level II
Tagged on:
Malcare WordPress Security