Help with Microsoft Access

Other video games, TV shows, movies, general chit-chat...this is an all-purpose off-topic board where you can talk about anything that doesn't have its own dedicated section.

Help with Microsoft Access

Postby scrub on Thu Feb 08, 2007 4:27 am

I need help with queries to create on Microsoft Access for my homework. I have made a database about a vet clinic. I need queries to run about animals, staff members or customers that go to the clinic. Can anyone please give me any ideas? For example, one of my queries is a list of the members of staff who are on 24 hour call to help animals.
Corey Brewer - Defensive Player of the Year 08
Image
User avatar
scrub
 
Posts: 536
Joined: Tue Aug 30, 2005 3:05 am
Location: Belfast, Ireland

Postby bigh0rt on Thu Feb 08, 2007 4:32 am

You can query things like staff members who work with specific types of animals, or staff members who make over a certain annual salary or hourly wage, or who have worked there longer than X years, etc.
User avatar
bigh0rt
NLSC Team Member
NLSC Team Member
 
Posts: 9032
Joined: Thu Nov 10, 2005 5:06 pm
Location: New York

Postby scrub on Thu Feb 08, 2007 4:36 am

I cant include the staff wage in the database so any other queries would be very helpful. Thanks.
Corey Brewer - Defensive Player of the Year 08
Image
User avatar
scrub
 
Posts: 536
Joined: Tue Aug 30, 2005 3:05 am
Location: Belfast, Ireland


Return to Off-Topic

Who is online

Users browsing this forum: No registered users and 6 guests