Access DB Project
$30-175 USD
Pagado a la entrega
Setup input forms and reports using MS Access using multiple tables.
## Deliverables
First, apologies to all who bid before, an internal problem kept us from picking someone.? This will not happen this time.
Our attempt at doing this is attached, however any structural changes that would make things more efficient are welcomed.
(This table contains member information only)
Table 1 - Member Information
Field Name? ? ? ? ? ? ? ? ? ? ? ? ? Field Type
Member Number? ? ? ? ? Auto (key no duplicates) <should link to Table 5 -? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Member Class>
Last Name? ? ? ? ? ? ? ? ? ? ? ? ? ? Text
First Name? ? ? ? ? ? ? ? ? ? ? ? ? ? Text
Middle Name? ? ? ? ? ? ? ? ? ? ? Text
Member Since? ? ? ? ? ? ? ? ? Date
Dues Due? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Date
PhP Program? ? ? ? ? ? ? ? ? ? ? Yes/No
(This table contains the different PHP categories and required number of hours)
Table 2 -? PHP Category
Field Name? ? ? ? ? ? ? ? ? ? ? ? ? Field Type
PHP Category Key? ? Auto
Description? ? ? ? ? ? ? ? ? ? ? ? ? Text
Required Hours? ? ? ? ? ? ? Number
(This table contains the list of possible class type)
Table 3 - Type of Class
Field Name? ? ? ? ? ? ? ? ? ? ? ? ? Field Type
Class Type Key? ? ? ? ? ? ? Number <should link to Table 4 - Class Type>
Type Description? ? ? ? ? ? Text
(This table contains all the possible classes that a member could have credit for)
Table 4 - Class List Table
Field Name? ? ? ? ? ? ? ? ? ? ? ? ? Field Type
Class Key? ? ? ? ? ? ? ? ? ? ? ? ? ? Auto
Class Date? ? ? ? ? ? ? ? ? ? ? ? ? Date
Class Type? ? ? ? ? ? ? ? ? ? ? ? ? Number < should link to Table 3 Type of Class Key>
Class Speaker? ? ? ? ? ? ? ? Text
Class Topic? ? ? ? ? ? ? ? ? ? ? ? ? Text
Class Credit Hours? ? ? Number
PHP Category Key? ? ? Number <should link to Table 2 PHP Category Key>
(This table contains all the classes that a member has taken)
Table 5 - Member Class List
Field Name? ? ? ? ? ? ? ? ? ? ? ? ? Field Type
Member Number? ? ? ? ? ? Number (duplicates) <should link to Table 1 - Member
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? Information Member? Number>
Class Number? ? ? ? ? ? ? ? ? Number (no duplicates, as a member can not go to the
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? same class on the same date twice)
Need an Access Application that allows the following tasks.
These should be fairly simple and able to use basic Access form functions
1) Add/Delete/Edit/Search Table 1 - Member Information
2) Add/Delete/Edit/Search Table 2 - PHP Category
3) Add/Delete/Edit/Search Table 3 - Type of Class
4) Add/Delete/Edit/Search Table 4 - Class List
This is the tough one.? It should tie all the relationships together so that when you select a specific member all the classes that they have taken are displayed - detailed information.? Once displayed it needs to allow new classes to be added, existing classes to be edited or deleted.
5) Add/Delete/Edit/Search Table 5 - Member Class List
Reports
1) A report that selects a specific member and then list all the classes that a member has taken
2) A report that selects a specific class and then lists all the members that took the classes
Tough one
3) A report that compares the credit hours that a member has against the credit hours required and reports what a member needs still.
* * *This broadcast message was sent to all bidders on Tuesday Jan 29, 2008 12:02:18 PM:
Password protected zip file had been replaced with correct zip file. Please download and review.
Nº del proyecto: #3672395