hithanks for your question
I am John i will help you to do this
can you post the Week 3 project to www.wikisend.com
post the Download link or file id
1. Use the Access database you created in Week 3: Customer Service Database2. Output 3 queries using SQL code and not the standard access view:
3. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.4. Report on Customers in Database showing Names, State, and Phone Numbers.5. Create a report showing contact name and birthdays. Do not show records without a birthday.6. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what the affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of data.7. All data and screen shots should be included in a Word document with a brief explanation of the actions you performed.
http://wikisend.com/download/670606/Lang,Keith Assignment Week 03 10-21-13.doc
Lang,Keith Assignment Week 03 10-21-13.doc
Here is the link to my week 3 assignment
We got a free down load from the school. You might have to get the free download from Microsoft. The week three assignment was done by another person from the site.
Here is a video that the instructor put together for the assingment