Form

Form #1



 

 

1.        Create the main form, with the following
specifications:

ｷ         Name it frmProductDataEntry.

ｷ         Apply any background colors that you like.

ｷ         Calculate the Discounted Price, and format it to
display the value as Currency with 2 decimal places. 

[NOTE: The Discounted Price would be calculated by multiplying the
List Price by the Discount, and then subtracting that value from the
List Price.] 

ｷ         Move and resize the objects on the form and align
the left edges of objects so that they look like the following: 



 

 

ｷ         Add a 16 point bold label as a heading, as in the
above graphic. The contents of the heading should be displayed at the
top of each page when the form is printed, as well as when the form is
displayed on screen. Ensure that the heading is centered horizontally
on the form.

ｷ         Align the top edges and the left edges of the
contiguous objects, so that the misalignment of objects on the form
isn稚 distracting.

ｷ         Add a List Box for the Finish field. Include the
following five entries in the list:

G1S

G2S

RGH

S4S

T3G

Replace the original Finish field with the List Box, and change the
label to read Finish.

ｷ         Control the Discount field so that it痴 displayed
on the form, but wouldn稚 print if the form were to be printed.

ｷ         Control the List Price field so that its contents
cannot be edited on the form.

ｷ         Control the Discounted Price control so it isn稚
activated when you use the Tab key to move from field to field.

ｷ         Change the Tab order so that when a record is
created or activated, the fields are activated as in the following
order:

Product Code

Category

Description

Size

Finish

List Price

Discount

ｷ         Add a variable that will display the current date in
the Form Header. Make sure all dates that will potentially be
displayed in the control will be fully displayed.

 

ｷ         Remove all unnecessary prefixes from labels and
headings.

ｷ         Control the form so that if it were to be printed,
only one record would print per page and there would be no blank
pages. 

The finished form should look as follows:



 2.        Create a subform called fromProductOrderSubform, with
the following specifications:

ｷ         Use the Datasheet layout.

ｷ         Include the following fields:

 

Product Code

Order #

Customer ID

Customer Name

Quantity Ordered

Date of Order

Date Filled

Order Complete?

 

ｷ         Hide the Product Code field in the subform, so it痴
included but not displayed.

ｷ         Remove the prefixes from all labels and headings in
the subform.

 

ｷ         Ensure that only one record will print per page,
with no blank pages.

ｷ         Include in the Subform a calculation to determine
the cost of each order. [This would be done by multiplying the
Quantity ordered by the Discounted Price.]

ｷ         Format the Cost calculation result to display as
Currency with 2 decimal places.

The finished subform should look as follows:

 

 

mer痴 record is active in the main form.

 

The finished form with the embedded subform should look similar to the
following:

 

 



 

 

4.        Re-save and close the form when finished.

 

 

 

 

Form #2



 

 

1.         The main form should have the following
specifications:

ｷ         Name the form frmSalesReps.

ｷ         The Form Header should read Sales Reps and Customers
and should be 16 point bold, centered horizontally across the form.

ｷ         The following fields should be included in the form:

Sales Rep ID

Rep Last Name

Rep First Name

Rep Date Hired

Rep Phone

Rep Hours

Territory Code

Territory Name

 

Also, include a field that will ultimately store the contents of the
Option Group for the Employee Health Plan, shown in the finished form
illustration, above.

ｷ         Apply whichever background color or style you want.

ｷ         Remove all Leszynski prefixes from labels and column
headings. Remove the prefix Sales from the labels of Sales Rep ID,
Sales Rep Last Name, Sales Rep First Name, Sales Rep Phone, and Sales
Rep Hours.

ｷ         Control the display of the data in the Rep Hours
field so that if the value is less than 40, it will appear in red and
boldface.

ｷ         Make sure all territory names and phone numbers are
fully displayed.

ｷ         Align the left edges of the strRepID,
strRepLastName, strSalesRepPhone, sngHours, and dtmDateHired field
controls.

ｷ         Align the bottom edges of the strRepLastName and
strRepFirstName fields and their corresponding labels.

 

ｷ         Group the strRepLastName and strRepFirstName field
controls and their corresponding labels so that the four objects
comprise a single object.

ｷ         Change the label on the title bar of the form window
so that, when the form is displayed in Form View, the title bar reads
Sales Reps Form.

ｷ         Control the form so that if it were to be printed,
only one record would print per page, there would be no blank pages, and
there would be no spillover of objects from one page to another.

ｷ         Add an Option Group called Employee Health Plan with
the following three options:

Plan A

Plan B

Plan C

        Make sure the contents of the Option Group are stored
in a field of the form.

        Do not add a default to the Option Group.

        Display the items in the Option Group as option
buttons.

        To test the Option Group, assign Plan A to the first 3
records, Plan B to records 4 and 5, and Plan C to the last 3 records.
(Leave these record selections in place when you are finished testing.)

        Once the Option Group has been created and you池e
sure it works, replace the original field (i.e., the one where the data
will be stored) with the Option Group, as in the following illustration:

 

 



ｷ         Attach a Calendar control to the Rep Date Hired
field, so the end-user can click a date on the calendar instead of
typing it in the field.

Place the calendar to the right of the Rep Date Hired field on the form.

2.         Add a subform with the following specifications:

ｷ         Name it frmCustomerSubform.

ｷ         Use the Datasheet layout and the Sandstone style.

  ｷ         Include the following fields:

Customer ID

Customer Name

Company Address

City

State

ZIP

Active?

ｷ         Add the label Customers to the subform. Be sure
to omit all prefixes.  (The finished form looks as follows:)