1 all powder board and ski microsoft access workbook chapter 8: applications jerry post copyright ©...

Post on 26-Mar-2015

221 Views

Category:

Documents

0 Downloads

Preview:

Click to see full reader

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.

top related