I"m needing help in Microsoft Access doing the following steps with a database Open the NorthWind Database. 2. Click "Sales Reports" in the "Quick Links" box. 3. The Year combo box is auto-populated with 2006. Explain where this is being generated from. 4. Go into Design view of this form. You should notice that the combo box cbYear is a Value List with a set Row Source of the years 2002-2005. However the current database has Orders in 2006. Therefore if you select 2003 from the list there is no way to go back to 2006 without generating an error. Change the Row Source Type to Table/Query and set the Row Source to a query that selects only the Years of existing orders. Note: Each year should only appear once. 5. Close and Save the Form. 6. Click "Sales Reports" in the "Quick Links" box to open it. Describe: a. How this form knows which report to open based upon the Selected Sales Period. b. Under "Select Case Me.lstSalesPeriod", where is "Case ByYear", "Case ByQuarter" and "Case ByMonth" defined? 7. Create a new table named tblProjectType. This table needs to contain a unique ID and a description of the project type. 8. Populate tblProjectType with the following data: · Industrial · Manufacturing · Medical/Research · Educational · Government 9. Add a field [ProjectType] (type is Number, Long) to table Orders. 10. Create a one-to-many relationship between the Orders table and tblProjectType. 11. Create a query named qryOrderedProductByProjectType that shows all Products ordered in the second quarter of 2006 grouped by ProjectType, sorted by the Order Date. 12. Create a report named rptOrderedProductByProjectType that displays the results of qryOrderedProductByProjectType. 13. Compact and Repair the completed database.
Hi, I'll be happy to help with this
do you have the database available?
I do....how do I send it to you?
if you go to wikisend.com
and attach the file there
it will then give you a link I can use to download the file
Is it downloading for you okay?
does it matter what user logs in to the database?
I am just completely confused on this so I'm praying you can help
ok - no problem
leave it with me
Oh...this has to stay in an Access 2007 format
yes - think it'll be fine
will make sure it stays Access 2007
should be with you in 30 mins or so
hows it going?
not too bad
Would you be up for...after you work your magic...to answering some questions after I look through it?
Everything going okay?
yes - that'll be fine
just on last step
database is here
questions are here
Gotcha...let me look through it
Steve...this is perfection. Thank you so much
Okay....what do I do from here?
this is the first time I've used this service
well, if you're happy then you can rate the service
and that will credit me for my time