Auto form

1.      Create an AutoForm based on tblOrders. Name the AutoForm
object frmOrders. Change the contents of the title bar of the form so
that when it displayed in Form View, you are seeing the name of the
form, rather than the name of the table on which the form was based.

 

Let’s assume your company never keeps more than 1000 of any given
product on hand. Therefore, if an order is placed for more than 500 of a
product, a Message Box needs to be displayed telling the user to reorder
that product immediately.

 

As the user goes about entering records into the form, if they enter a
value greater than 500 in the Quantity Ordered field, as soon as they
move the cursor out of that field a Message Box should be displayed with
the following message:

 

This product needs to be reordered immediately.

 

Add a title to the Message Box of URGENT and display the warning symbol
of a black exclamation point in a yellow triangle.

 

 



 

 

the frmProductDataEntry form. Label the button See Product
Information. Place the Command button in the appropriate section of
the form so that it visible at the top of every record.

 

Change the font of the button to Times new Roman 11 point bold, and
change the color of the button to dark red. Make sure the entire
contents of the button are fully displayed.

 

 



 

 

On the frmProductDataEntry form, add a Command button (also visible at
the top of every record) that will bring the user directly back to
frmOrders. Label the button 迭eturn to Order Form・

 

 



 

 

Change the font of the label in the command button to Times New Roman 11
point dark red bold.

 

 

3.      Make a copy of qry#7ProductAndDateParameter, and name the
copy qry#7Parameter2.

 

Add the Product Code field to the query copy (qry#7Parameter2).

 

Create a report based on query#7Parameter2 that includes the following
fields:

 

Customer ID

Customer Name

Product Code

Quantity Ordered

 

When the Report Wizard asks you how you wish to view the data in the
report, select by tblOrders.

 

Do not include any grouping or sorting.

 

Use the Tabular Layout, Portrait Orientation, and Corporate Style for
the report.

 

Name the report rptProductsOrdered.

 

Once the report has been created, define a macro so that the report will
preview only if there are data. If not, a message Box should display
the following message:

 

This product was not ordered between the specified dates.

 

 



 

 

Name the macro mcrCancelReport.

 

 

NOTE: To test this macro with data in the report, you can use
Standard Lumber with the dates 1/1/2002 to 1/1/2004. This will
generate a report with 8 records. To test the macro with no data for
the report, use Standard Lumber with the dates 1/1/2004 to 4/1/2004.
This should cause the Message Box to be displayed.

 

 

4.      Create a Switchboard for your database with the following
characteristics:

 

a)     Automatically displays and maximizes when the database is
opened.

 

b)     Do not use the Main Switchboard page that is provided for
you, but rather create a new Switchboard named with your first name and
the word Switchboard. (For example, mine is called Janis
Switchboard.)

 

c)      Make your new Switchboard the default.

 

d)     The main page of the Switchboard Manager should have three
buttons:

 

 



 

 

NOTE: The heading at the top of your Switchboard should, of course,
reflect your own name. (Sorry to have to mention this, but this came
up in a previous semester.)

 

 

� Enter Products

 

Should open the frmProductDataEntry form to display all of the available
records.

 

 

� See Active Customers

 

Should run the qry#1ActiveCustomers query with all records displayed in
the dynaset.

 

 

� Preview Reports

 

Should bring you to a second Switchboard page that contains three
buttons:

 

 

o       Total Cost With Grand Total Report

 

Should preview rpt#1TotalCostWithGrandTotals

 

 

o       Sales Reps And Customers Report

 

Should preview rpt#2SalesRepsAndCustomerOrders

 

 

o       Return to Main Switchboard

 

 



 

(...continued)

(continued...)