1 all powder board and ski microsoft access workbook chapter 8: applications jerry post copyright ©...
TRANSCRIPT
1
All Powder Board and Ski
Microsoft Access WorkbookChapter 8: ApplicationsJerry PostCopyright © 2007
2
Application Elements
Startup form
Integrated forms and reports
Help files
Custom toolbar
3
Template Form
Logo
Title Close button
Messages
4
Customer Form with Template
5
Action
ActionCreate a blank form in Design View.Add a logo and sample title.Add a button to close the form.Add a label that can be used to display messages to the user.Set the message label’s Visible property to No.Apply the template form to the Customer form and save it as CustomerD.
6
Creating a Switchboard Form
Start in design view
Add command buttons
Open forms or reports
7
Action
ActionCreate a blank form in Design viewSet the properties to remove the scroll bars and
navigation buttonsAdd command buttons to open other forms (Form
Operations/Open Form) and reportsUse colors and graphics to make the form appealingRun the form and test all buttons
8
Creating Toolbars and Menus
Create a new toolbar
9
Toolbars and Menus
Drag commands onto the toolbar
10
Action
ActionChoose View/Toolbars/CustomizeOn the Toolbars tab create a new toolbarClick the Commands tabDrag the main form icon onto the toolbarAdd a Customers menu option and drag the
customer forms and reports onto itAdd the Help iconTest the toolbar
11
HTML Help
Form
Help File
AllPowder.chm
HTML Topic
HTML Topic
HTML Topic
HTML Topic
HTML Topic
HTML Topic
Properties:
Help File: AllPowder.chm
Help Context ID: 1
1 Topic A2 Topic B3 Topic C4 Topic D5 Topic E6 Topic F
compile
12
HTML Help Files<Object type="application/x-oleobject" classid="clsid:1e2a7bd0-dab9-11d0-b93a-00c04fc99f9e"> <PARAM name="Keyword" value="Contents"> <PARAM name="Keyword" value="Introduction"> <PARAM name="Keyword" value="Start"> <PARAM name="Keyword" value="Management"></OBJECT><HTML><HEAD><TITLE>All Powder Board and Ski Shop</TITLE><LINK rel="stylesheet" type="text/css" href="Styles.css"></HEAD><BODY><H1>Introduction to the All Powder Board and Ski Shop</H1><TABLE><TR><TD><IMG SRC='BoardLogo1.gif' border='0'></TD><TD>All Powder Board and Ski Shop sells and rents snowboards and skis for all levels of riders and skiers.</TD></TR></TABLE><H2>The Board and Ski Shop</H2><UL><LI><A HREF=’Customers.html'>Customers</A></LI><LI><A HREF=’Sales.html'>Sales </A></LI></UL></BODY></HTML>
13
Action
ActionCreate at least three HTML help files for the All Powder forms using
an HTML editor or WordpadIf necessary, download and install the HTML Help workshopCreate a new project in the workshopAdd the HTML filesEdit the HTML files to add keywordsCreate the mapping file with a text editor and add it to the projectSet project options to build the TOC and index filesCompile and test the help fileEdit the database forms and add the help file name and ContentIDRun the form and press the F1 key to test the help files
14
Topics Map File
#define AllPowder 100
#define Customers 10000
#define Sales 20000
15
Help Compiler and File
16
Help File on Access Form
File name
Topic number
17
Deploying Applications
Developer files
Application users
Files to transfer:Name.mdb or Name.mdeName.chmSecurity files (optional)Replica files (optional)
18
Action
ActionTest your application.Copy the mdb and chm files to a second computer.Add a desktop shortcut to the application.Run the application and test it.If you have the Access runtime, use its installation
software to build an installation file and test it.