Access DB Project

Completado Publicado Jan 28, 2008 Pagado a la entrega
Completado 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.

.NET Ingeniería Microsoft Microsoft Access MySQL PHP Arquitectura de software Verificación de software Visual Basic Visual Basic para aplicaciones Windows Desktop

Nº del proyecto: #3672395

Sobre el proyecto

113 propuestas Proyecto remoto Activo Jun 10, 2008

Adjudicado a:

meparashar

See private message.

$148.75 USD en 66 días
(82 comentarios)
5.7

113 freelancers están ofertando un promedio de $157 por este trabajo

bzamfir

See private message.

$238 USD en 66 días
(70 comentarios)
8.1
jared23

See private message.

$212.5 USD en 66 días
(288 comentarios)
7.7
branislavm

See private message.

$212.5 USD en 66 días
(329 comentarios)
7.7
shikhamehta

See private message.

$85 USD en 66 días
(264 comentarios)
7.2
shebkhan2007

See private message.

$127.5 USD en 66 días
(723 comentarios)
7.2
sharpMind007

See private message.

$233.75 USD en 66 días
(246 comentarios)
7.2
pShankar2

See private message.

$127.5 USD en 66 días
(407 comentarios)
7.1
proteamspb

See private message.

$212.5 USD en 66 días
(43 comentarios)
6.8
i2software

See private message.

$136 USD en 66 días
(94 comentarios)
6.3
phosphorvw

See private message.

$148.75 USD en 66 días
(104 comentarios)
6.1
radzivil

See private message.

$170 USD en 66 días
(92 comentarios)
6.1
suthernsoftware

See private message.

$187 USD en 66 días
(61 comentarios)
6.6
solutionsauzlx

See private message.

$93.5 USD en 66 días
(40 comentarios)
5.8
pronixtechn

See private message.

$255 USD en 66 días
(20 comentarios)
5.7
ghumber

See private message.

$255 USD en 66 días
(108 comentarios)
5.9
ourious

See private message.

$127.5 USD en 66 días
(116 comentarios)
5.3
SoftwareParadigm

See private message.

$136 USD en 66 días
(24 comentarios)
4.8
swhitedev

See private message.

$148.75 USD en 66 días
(27 comentarios)
4.5
dolcemano

See private message.

$127.5 USD en 66 días
(57 comentarios)
4.8
simpledigitech

See private message.

$51 USD en 66 días
(65 comentarios)
4.8