Em Andamento

small Access DB with Classic ASP

Create a small member data MS Access database and Classic ASP-coded webpages for login, member search and editing profiles. Additional work on? other parts of our project - to be paid for separately from this proposal? - may be offered for a job well done!

## Deliverables

**Project Specs**

1.? ? ? ? ? ? All pages should be coded in Classic ASP; your HTML will be added into an existing template, so no styles should be added.

2.? ? ? ? ? ? Create an Access DB with the fields listed below

3.? ? ? ? ? ? Create login page for a “members only?? area that hits DB for validation

4.? ? ? ? ? ? Login page also offers a “Forgot Password?? link that automatically emails password to email on file (for the username as entered; validation and error message for username field)

5.? ? ? ? ? ? At login verification, lastLogin field for the user’s record is given a value of the current date, and session variables are created for the following:

- ID

- membName (concat firstName + {space} + lastName)

- newsAdmin

- financeAdmin

6.? ? ? ? ? ? Create a new “Edit My Profile?? page to allow logged-in user to update ONLY their own DB data (historical data need not be saved)

7.? ? ? ? ? ? Display a “No Photo?? graphic for records without valid JPG photos. Utilize ASPupload code to upload new or replacement photo file (the component is already installed on web server). Store the filename in the membPhoto field and the file itself in a subfolder “membphotos??.

8.? ? ? ? ? ? Create a new “Search Actives?? page that offers search options to view linked names matching the given criteria ??" only for records with membType=0. All blank fields returns a complete listing (with no filter).

9.? ? ? ? ? ? Create a new “Search Alumni?? page that offers search options to view linked names matching the given criteria ??" only for records with membType=1. All blank fields returns a complete listing (with no filter).

10.? ? Clicked names from the above two lists links to a “Profile View?? page with all data for that record displayed.

?

**Database Fields/Columns** (standard Char 50 unless specified otherwise)

·? ? ? ? ? ? ? ? id <autonumber; primary key>

·? ? ? ? ? ? ? ? firstName

·? ? ? ? ? ? ? ? middleInitial

·? ? ? ? ? ? ? ? lastName

·? ? ? ? ? ? ? ? username

·? ? ? ? ? ? ? ? password

·? ? ? ? ? ? ? ? gradYear <4-digit number>

·? ? ? ? ? ? ? ? membType <single digit number> [0=active; 1=alum; 2=web admin only/test account]

·? ? ? ? ? ? ? ? currentStreet

·? ? ? ? ? ? ? ? currentStreet2

·? ? ? ? ? ? ? ? currentCity

·? ? ? ? ? ? ? ? currentState

·? ? ? ? ? ? ? ? currentZip

·? ? ? ? ? ? ? ? currentCountry

·? ? ? ? ? ? ? ? currentPhone

·? ? ? ? ? ? ? ? currentCell

·? ? ? ? ? ? ? ? homeStreet

·? ? ? ? ? ? ? ? homeStreet2

·? ? ? ? ? ? ? ? homeCity

·? ? ? ? ? ? ? ? homeState

·? ? ? ? ? ? ? ? homeZip

·? ? ? ? ? ? ? ? homeCountry

·? ? ? ? ? ? ? ? homePhone

·? ? ? ? ? ? ? ? companyName

·? ? ? ? ? ? ? ? companyTitle

·? ? ? ? ? ? ? ? companyPhone

·? ? ? ? ? ? ? ? workType

·? ? ? ? ? ? ? ? membPhoto

·? ? ? ? ? ? ? ? lastLogin <date>

·? ? ? ? ? ? ? ? newsAdmin <true/false>

·? ? ? ? ? ? ? ? financeAdmin <true/false>

Habilidades: ASP, Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software, Hospedagem Web, Gestão de Site , Teste de Website

Ver mais: template job proposal, template for job proposal, small project proposal template, photo editing profile, parts database access, ms access with php, ms access parts database, job proposal template, job ms access, file upload component, editing job search, component active, classic asp job, access parts database, ms access job, ms access email, key code verification, edit an existing template, classic asp, active filter, profile hits, filter search component, user profile template html, create update profile page php, asp access html

Acerca do Empregador:
( 8 comentários ) Greenwood, United States

ID do Projeto: #2962419

Premiar a:

applisofttech

See private message.

$93.5 USD em 5 dias
(97 Avaliações)
6.0

22 freelancers estão ofertando em média $236 para este trabalho

sammughal

See private message.

$467.5 USD in 5 dias
(342 Comentários)
8.2
alitharwani

See private message.

$425 USD in 5 dias
(269 Comentários)
7.8
digitallogix

See private message.

$170 USD in 5 dias
(168 Comentários)
7.7
pShankar2

See private message.

$127.5 USD in 5 dias
(411 Comentários)
7.1
hwanghendra

See private message.

$85 USD in 5 dias
(430 Comentários)
6.8
shuvrapintu

See private message.

$110.5 USD in 5 dias
(126 Comentários)
6.6
sankettshah

See private message.

$102 USD in 5 dias
(159 Comentários)
6.1
vw1621783vw

See private message.

$127.5 USD in 5 dias
(187 Comentários)
6.0
gopisoft

See private message.

$340 USD in 5 dias
(62 Comentários)
5.8
kevneth

See private message.

$255 USD in 5 dias
(38 Comentários)
5.6
EnvisionTechs

See private message.

$255 USD in 5 dias
(44 Comentários)
5.2
baburam

See private message.

$229.5 USD in 5 dias
(93 Comentários)
5.2
oraclequest

See private message.

$85 USD in 5 dias
(73 Comentários)
5.2
edreamzinc

See private message.

$170 USD in 5 dias
(26 Comentários)
5.1
thecloudkernel

See private message.

$1530 USD in 5 dias
(6 Comentários)
4.0
alanmunoz

See private message.

$114.75 USD in 5 dias
(8 Comentários)
2.8
engrtabishmirza1

See private message.

$85 USD in 5 dias
(2 Comentários)
0.5
davibq

See private message.

$85 USD in 5 dias
(0 Comentários)
0.0
amtechsl

See private message.

$127.5 USD in 5 dias
(0 Comentários)
0.0
wizardguru

See private message.

$85 USD in 5 dias
(2 Comentários)
0.0