Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The main menu form must open automatically when your database opens. The main menu form has 5 controls: 1 label to hold the name of

The main menu form must open automatically when your database opens.
The main menu form has 5 controls:
1 label to hold the name of the form
3 buttons to open the Queries, Reports, and Data Management forms
1 button to close the application
The queries form allows the user to run the even-numbered queries Query 24??68(labeled,02,04, Q6, and Q8 above).
Queries form has 6 controls:
1 label to hold the name of the form
4 buttons to run each of the queries Q2,Q4,Q6, and Q8
1 button to close the Queries form
Reports: generated by the Reports Wizard.
Sales Per Product in Countries: Design a report that is based on a query. The query lists the names of products, the total number of times the product has been ordered by customers in different countries, and the name of the country. The report should list the product names in ascending order and show the number of times it has been ordered in each country. A sample of the beginning of the report is shown in Figure 1.
Customer Orders Summary: design a report that is based on the relationships in the database. The report shows each customer's name, the order ID of the orders the customer has submitted, and the ID and name of the employee who handled the order. For each customer, it lists the order ID in ascending order. A sample of the expected result is provided in Figure 2.
The report form has 4 controls:
1 label to hold the name of the form
2 buttons to open each of the reports; provide meaningful names for the reports.
1 button to close the Reports form
Data Management form.
The Data Management form has 8 controls
1 label to hold the name of the form
6 buttons to open each of the table forms
1 button to close the Data Management form
Table forms: generated by the Forms wizard for each table.
Each of the Categories, Customers, Employees, Order Details, Orders, and Products forms has 3 buttons
1 button to add a record
1 button to delete a record
1 button to close the form
6
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

New Trends In Databases And Information Systems Adbis 2019 Short Papers Workshops Bbigap Qauca Sembdm Simpda M2p Madeisd And Doctoral Consortium Bled Slovenia September 8 11 2019 Proceedings

Authors: Tatjana Welzer ,Johann Eder ,Vili Podgorelec ,Robert Wrembel ,Mirjana Ivanovic ,Johann Gamper ,Mikolaj Morzy ,Theodoros Tzouramanis ,Jerome Darmont

1st Edition

3030302776, 978-3030302771

More Books

Students also viewed these Databases questions

Question

How We Listen?

Answered: 1 week ago