Access 2007 Level 3: Interface Design

IT@Emory computer education - Microsoft Office Training

Database information is most useful if you can quickly and easily access it. In many cases, those needing to use the information in an Access database are non-Access users. Designing a user-friendly “front-end” interface in Access makes information accessible to everyone. Create a database menu, navigational elements, and even forms that generate reports at the click of a button. Turn your Access database into a system that looks and works like an “out of the box” application.

Prerequisite: Accessing the Possibilities or equivalent experience with Access

Instructor: Paul Dunlop, Certified Technical Trainer
1 session(s): Wed: Dec 16 / 9:00 am-4:00 pm
Registration fee: $225       

You should take this class if:

You need to design an Access database for use by people unfamiliar with access OR you are creating a database that will be used everyday and would like to make the interface more user friendly.

After this class, you will be able to

• Standardize colors, fonts, and other settings when creating database forms from templates
• Create buttons that open and close forms and allow the user to navigate the interface
• Change database settings to prevent users from viewing or editing tables and queries directly
• Design list forms to display multiple records at the same time and detail forms to display one record at a time
• Manually and automatically compact and repair a database
• Split an Access database into multiple files so that several people can safely use it at once

What will be covered

Lesson One: Creating a Form Template


• Creating a template form
  
• Making a form the default Template
  Lesson Two: Starting an Interface
  
• Creating a “switchboard” form
  
• Form automation
  
• Setting startup options
  
• Custom toolbars
  Lesson Three: Creating List and Detail Forms
  
• List forms
  
• Detail forms
  
• Linking list and detail forms
  Lesson Four: Database Utilities
  
• Compact and repair
  
• Splitting an Access database

Share this class:   Digg    Facebook    Del.icio.us    Reddit    LinkedIn  

Search Results

Search again