Question:
I have a question about database assignment 2. I have already submitted it,but I didn't do everything correctly. I'm having trouble doing the part that says "...select records for items that have not been sold,(SoldTo has a value of 0)" I appreciate it if you could help me out. Thank you.
Answer:
A query filters (selects) information from a table. (A query can also combine information from multiple tables, but that's a more advanced topic.) I'm asking you to create a query that shows only records for items that have not been sold. The table Merchandise has a field called SoldTo. If the value of this field is 0 that implies the item has not been sold. Any item which has been sold has the customer's ID number. A customer ID number is always larger than zero. So, to select records to which no customer's ID has been assigned (because no one bought the item), you should create a query that shows only records for items that have a value of 0 in the SoldTo field.
The lesson that talks about how to specify a criteria (for this assignment the criteria is that SoldTo = 0) on a query is:
In short, you should put =0 in the criteria row under the SoldTo column in the query you create. Note, you will have to add the field SoldTo to your query. It was not specified as a field you should include in your query.
As a final comment if you resubmit your assignment after it is graded you should send a note to cs100help@cstp.umkc.edu explaining that you are resubmitting your assignment with corrections. If you don't send an email it's unlikely we will regrade it.
Question:
Hi...I am having some problems with the database assignment #3. On the first section when I am creating the form called merchandise....it looks fine except for the background. The box is not gray as it is supposed to be, instead it is and image of clouds (like Windows' background). How do I change it to gray. I have tried clicking the right button on the box and using Fill/Back Color (under the design menu)...but it doesn't change it, it is still clouds. Also on the first part how do I put the box around the "Date of Sale" and "Sold to." Thanks!
Answer:To get rid of the clouds (picture background) and change the background color to gray:
- Open properties for form (One way is to double click on the gray background of the form in form design view. Be careful not to double click any form sections such as Header, Detail, etc. That will bring up properties for that section of the form.)
- Underneath the Format tab there will be an entry for Picture. Erase the value that is there. This should leave it with the value: (none)
- To set the background color you will need to set the background color for each section. Do the following to each section:
- Select the section header to display the properties for that section
- Underneath the Format tab there will be an entry for "Back Color". Select that and use the "..." button to open a dialog box. This dialog box will allow you to specify the color.
The box around Date of Sale and Sold To is a rectangle. You can draw the rectangle with one of the toolbox options. To draw the box,
- Open the form in design view
- Make sure the toolbox is in view. If it isn't select View/Toolbox
- Click the tool that looks like a rectangle. If you hold the cursor still over it it will say "Rectangle"
- After you have selected the rectangle, click and drag over the place on your form where you want the box.