Question: Use the Week 7 Assignment Database File for this section of the assignment. Create and save a data entry form to input more records into

Use the Week 7 Assignment Database File for this section of the assignment. Create and save a data entry form to input more records into the table. Use the form to add 10 more records and save the database with the extra records. Create SQL queries to do the following: Display the total ticket sales to males Display each event (only once) in all upper-case letters Display the total number (not $ amount) of sales of Rodeo tickets Save all 3 queries. Finally, export the entire table to an Excel spreadsheet and save it. Submit the database file with your form, the records you added and your queries, and also submit your Excel file.

My main question is how to create a data entry form and add the 10 records to the file.

Database File Link https://drive.google.com/file/d/0B1bIdsxh03HoaUxFV3pLLTB2RmM/view?usp=sharing

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

3. TechIT Seminars TechIT Seminars is an organization of independent seminar facilitators who provide onsite technical training to large businesses around the world. The facilitators build curriculum...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

Transfer Student Registration Project Description: You were recently hired by your local college to help with registering all transfer students. The colleges Transfer Counseling Department is a...

Create a provider database and related reports and queries to capture contact information for potential PC component providers that might be used to purchase the equipment your specified in your MS...

Please try to answer all if possible :-) Practice Database - March 2021 1. Create a database in your HOME FOLDER, C-Database Systems called Practice March21.accdb a. Remember to click on the yellow...

1 To start, you have been provided with a database the Information Technology department created. The database has one table and one form. You will be importing an Excel spreadsheet into a table and...

You have decided to open a small restaurant. Due to the pandemic and a limited budget, you will offer delivery service only at this time. You choose to start your business based on a...

FAST NU wants to keep records of all HWs, Proj, Mids etc. Following attributes as a part of the key are required to make sure the weakness of duplication of records that can be resolved. Draw ER...

Write a SQL statement to display the name, goal, pledged, and category for the projects with a goal between 3000 and 50000 dollars. Write a SQL statement to display the unique creator name who have...

PHP web question answer needed in coding please Ia. Configure to use the new table Modify tma02_admin.php to use the new table. Only a single line of code should be changed. In your solution...

A company purchases surf boards and resell them to customers. The following information is based on sales of 2,000 surfboards. The company had Sales of $324,000. Cost Variable Cost of goods sold...

Custom Metal Works produces castings and other metal parts to customer specifications. The company uses a job-order costing system and applies overhead costs to jobs on the basis of machine-hours. At...

The Financial Modemization Act allowed banks to merge with insurance companies. True Fatse

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

=+Trainers from headquarters? Local trainers? Independent trainers?

=+j What are the effects of language differences? Will there be translation problems (for both written and orally presented materials)? Are there differences in the meanings of words? Are there terms...

=+foreign language(s)? Who should take responsibility (headquarters personnel, host-country specialists, or third-party vendors) for translation? Should