Auto form

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 dis ...continues

Excel

Please refer to word doument for questions and make changes on the excel sheet. (In the VBA SAMPLE 4 workbook file, create a macro that enters budget data into the active worksheet.) Thank you.

Database

I have the PHP code to produce a product listing, and also the code to Update the fields of an existing Product. (The code for all the examples including the Access database is attached as a Zip file). Supply me with the PHP code to 1.Add a new product to the database. 2.Delete an existing product from the database. Tha ...continues

Form - 3 additional question for OTA 101620

Dear OTA 101620 Thank you for your response. For the second question,I would like to ask how to automatically assign a specific value to a label for a text box. ( automatically assigns a label that reflects the name of the file - for example, if the file name is Janis.mdb, the label shows automatically Janis Switchboard ) T ...continues

Database Question

Why are non-database approaches to data management impractical? How does a database solve these problems? Provide a specific example of an anomaly that is solved by using a database.

Summarizing data in a query

Explain the key concepts that are involved in summarizing data in a query. Include an explanation of functions and grouping. Please provide some examples to illustrate your points.

SQL Command

Find the name of each publisher containing the word "and". (Hint: Be sure that your query selects only those publishers that contain the word "and" and not those that contain the letters "and" in the middle of a word. For example, your querry should select the publisher named "Farrar and Giroux," but should not select the publi ...continues

Access

Database file to keep track of employee information. Please see attachment for questions.

SQL Commands

Use SQL to complete the following: For each type of book, list the type and the average price. There are several BOOKs in each type. See attachement file for details. This is what I was doing in MYSQL but it isn't working and any suggestion would be greatly appreciated. I keep getting error messages. This is definit ...continues

SQL Command

Use SQL to compete the following: What is the lowest book price in the database? For example, this is what the database should look like: (See attached file) This database has 34 books with prices starting from 25.50 to 5.99. This is what I have so far but it isn't working: SELECT TITLE FROM BOOK WHERE SELECT MIN( ...continues