Create a switchboard for your database

Assignment Help Database Management System
Reference no: EM13950447

Please refer to access_11 questions and make changes on database. (please change the file extension to access)

The following is also in the attachment

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.

2. On the frmOrders form that you just created in #1, add a Command button that will bring the user directly to 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

Attachment:- ACCESS_11.zip

Reference no: EM13950447

Working database that supports the above case.

The students are lodged in one of four houses, with a designated professor in change of each house. But, since some professors, such as Snape, have some problems standing so

Discuss db caching in middle tier of server architecture

Advanced Database Administration (COMP 0343) Manage client-server connections using RDBMS Net Services and evaluate requirements and select appropriate parameters to ensure ef

Why relational database would be suitable information system

Explain why a relational database would be suitable information system for the organisation such as the one provided in the case study and provide (3) three reasons to suppo

Translation from erd to the relational model

Complete (i.e., reverse engineering) ER diagram below such that 4 relation schemas above are exactly result of a translation from the ERD to the relational model.

Consider a relation stored as a randomly ordered

Consider a relation stored as a randomly ordered ?le for which the only index is an unclustered index on a ?eld called sal. If you want to retrieve all records with sal > 20,

Why network is the key to data needs throughout organization

Ascertain the need for a robust network infrastructure to support strategic initiatives related to BI within an organization of your choice. Moreover, analyze the main reaso

Draw the entity-relationship diagram for all of the entities

Note: The counties for the state capitals shown in the figure above are Travis and Williamson counties for Austin TX; Hartford county for Hartford CT; Clinton, Eaton, and In

Quality and correctness of schema design

Create an ER/EER diagram to represent the conceptual schema described by the above Universe of Discourse - You can use MS Word to draw the Entity Relationship diagram, and the

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd