CSC 459- Project #3 - MS ACCESS (Due 5/19/06)

 

Submit a disk or email an Access 2002/2003 database file to me by the last day of the finals.

Build a MS-ACCESS database similar to what you developed in project 2 with Oracle; respond to the same queries and implement part of the GUI that you had developed in that context.


Create or import the tables that you had in project 2. Implement the same constraints that were put on these tables when you did your project #2.


Perform the following queries in Access and produce a report for each:

a.         Professional’s appointment scheduled for a specified day where the date and the professional are variables in the query.

b.         Client’s appointment schedule for a specified day where again the date/time are variables.

c.         Find professional and client pairs that have multiple appointments with each other; this query includes both historical and pending appointments.  Historical refers to all appointments that have already taken place.

d.         Find Clients and the count of appointments they have already had where that count is more than 2.

e.         Provide a list of all offices with the count of professional that have more the average number of clients.

f.          List the professionals and their offices that have no pending appointments.

g.         List the office(s) with the most number of professionals that have no pending appointments.


Develop one or more forms providing an interface for a client. This interface needs to allow the user functionality similar to that what you had in project #2 for the client.