database

alternateproject.accdb

Home >Computer Science homework help >database

AppointmentID	AppointmentDate	AppointmentTime	CustomerID
1033	2/18/16	12/30/99	113
1034	2/25/16	12/30/99	4
1035	3/10/16	12/30/99	4

AppointmentServiceID	AppointmentID	ServiceID	StaffID	Units
1091	1033	3	13	1
1092	1033	23	13	3
1093	1034	23	13	4
1094	1035	3	13	1
1095	1035	23	14	1

CustomerID	CustomerFirstName	CustomerLastName	CustomerAddress	CustomerCity	CustomerProvince	CustomerPostCode	CustomerPhone	CustomerDOB	CustomerSince	CustomerSex
3	Angela	Nelsen	1140 Esquimalt Road	Victoria	BC	V6W 1E8	(250) 366-1450	1/2/50	2/26/05	F
4	Toby	Fisher	100 Altantic St	Victoria	BC	V8V 2J8	(250) 745-8962	1/9/64	3/6/05	M
113	Avery	Access	123 Microsoft Lane	Victoria	BC	V8W 4R5	(902) 123-9535	9/12/70	5/8/10	F

ServiceID	ServiceName	ServiceCategory	ServiceFee	ServiceNotes
3	Emergency Visit	2	¤ 100.00
23	Filling	3	¤ 125.00

ServiceCategoryID	Category
1	Diagnostic
2	Emergency
3	Dental Procedure
4	Oral Hygeine

StaffID	StaffFirstName	StaffLastName	StaffSex	StaffPhone	StaffDOB	StaffHireDate	StaffE-Mail	StaffPosition	Notes
13	John	Jones	M	(250) 382-5674	7/3/45	1/1/05		Dentist
14	Jenny	Cleaner	F	(205) 388-5544	1/4/65	9/5/14		Hygienist

PARAMETERS __AppointmentID Value; SELECT DISTINCTROW * FROM tblAppointmentService AS frmCreateAppointment WHERE ([__AppointmentID] = AppointmentID);

SELECT tblCustomer.CustomerID, [CustomerFirstName] & " " & [CustomerLastName] AS Customer FROM tblCustomer ORDER BY tblCustomer.[CustomerLastName], tblCustomer.[CustomerFirstName];

SELECT DISTINCTROW * FROM tblAppointment;