Child ID Access

I am creating a database for my final project at school and experiencing difficulty creating queries and reports. What should they consist of. My database is for a salon and I have a table for employees and one for clients (I am only allowed 2 tables). I created 2 forms based on my tables, but now I need 5 queries and 3 reports what should I base them on? Any ideas my table fields for employees are employee number, name, address, gender, b-day, phone #, position, salary and date hired. For the clients table they are name, address, client #, stylist (I did a relationship between client and employee names), phone #, gender and b-day. That’s all I have right now, if you think I should include more fields or know what queries or reports I should use please help me. Thank you so much for your time. I will give you points for a good answer.

Salon Finder
We also offer free listings to salons so … Remember we are new and we are just building the database…Tell your salon about this service. …www.beautyweb.com/salon_finder/salon_finder.htm
Business Rules for Hairdressers Appointments
 . This Page defines the Requirements for a Database for a Hairdressing Salon. … A Client can be given a specified Salon Treatment. …www.databaseanswers.org/data_models/hairdressers/facts.htm
CaliforniaSalons.com
… a wide array of services, including our user friendly California salon database. … California Salons will not only find the closest salon for you, we will also …www.californiasalons.com
Affordable Salon software at $99.95 – Salon Management Software
… an affordable solution to both hair and nail salons. … a restore Point for your PC to specifically save and backup the salon database on a daily basis. …www.xtremeblue.com/Troubleshootingtips.htm
Salon.com | Bush’s bogus document dump
… and by linking the site to an entirely unrelated database of al-Qaida materials. … The Current Occupant goes for a walk …www.salon.com/opinion/feature/2006/04/13/document_dump/index_np.html

This entry was posted on Monday, March 1st, 2010 at 3:15 am and is filed under access queries. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.