microsoft access 2010 build user friendly database systems l.
Download
Skip this Video
Download Presentation
Microsoft Access 2010 Build User-Friendly Database Systems

Loading in 2 Seconds...

play fullscreen
1 / 14

Microsoft Access 2010 Build User-Friendly Database Systems - PowerPoint PPT Presentation


  • 290 Views
  • Uploaded on

Microsoft Access 2010 Build User-Friendly Database Systems. Chapter 7. Chapter Overview. Query Based Forms AutoLookup Menu Systems Switchboards, Blank Forms and Navigation Forms Macros Autoexec, Help Button. Query Based Forms. Display data from multiple tables Display calculated fields

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Microsoft Access 2010 Build User-Friendly Database Systems' - jola


Download Now An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
chapter overview
Chapter Overview
  • Query Based Forms
  • AutoLookup
  • Menu Systems
    • Switchboards, Blank Forms and Navigation Forms
  • Macros
    • Autoexec, Help Button
query based forms
Query Based Forms
  • Display data from multiple tables
  • Display calculated fields
  • Utilize AutoLookup
  • Display sorted data
autolookup
AutoLookup
  • Automatically “looks up” data based on a primary key
  • Tables used in query must have a one-to-many relationship
  • Join field in the query must be taken from the many side
switchboard menu system
Switchboard Menu System

Switchboard Wizard creates a user friendly menu that can link together all of your forms and reports in one place. Limit of 8 items per menu. Submenus can be added if 8 item limit is exceeded.

The wizard creates a form called Switchboard and a table called Switchboard items. Do NOT delete or move the textboxes and buttons in the design of the Switchboard form.

Page 74, Step 13 explains how to enable the Switchboard Manager in Access 2010

blank form menu system
Blank Form Menu System

Alternatively, a menu can be built from a blank form and command buttons.

Advantages: Unlimited items on menu and greater design flexibility.

navigation form menu system
Navigation Form Menu System

Alternatively, a menu can be built using a Navigation Form from a blank form and command buttons.

Advantages: Updated design and Web integration

Disadvantages: Limited customization options available

macros
Macros
  • Used to execute series of stored commands
  • Useful for opening and closing forms, reports, or queries
  • Makes an application easier to use
help button
Help Button
  • Macro using MsgBox function that provides technical support information.
  • Sample help message:
    • “Please call 555-5555 for technical support”
autoexec macro
AutoExec Macro
  • Special macro will Automatically Execute when database is opened.
  • Used to open main menu on startup.
  • Macro should be saved with the name “Autoexec” for it to be recognized as this special type of macro.
database startup options
Database Startup Options
  • May be used instead of Autoexec macro to automatically open a form on database startup
  • See page 71 for additional instructions
homework 5
Homework 5
  • Chapter 7 Guided Exercise
  • Chapter 7 Applied Exercise