Em Andamento

MS-Access Project

We are a school photography company. The school gives us a database of teacher and grade. We need to create a database record for each student for photographer #1 and each student for photographer #2. There can never be duplicate numbers.

## Deliverables

Here’s what we want.

Modify the MS-Access database called specprep which should do the following:

1. Our client gives us a text file that contains the teacher and grade for each class in the school. (See [url removed, login to view])

2. Employee opens up [url removed, login to view] which launches frmStartup. (See [url removed, login to view] which includes frmStartup)

3. We press the button “Import Database?? which is a simple Macro which launches “File/Get External Data/Import.

4. We select the .csv file that has 2 fields: (See [url removed, login to view])

a. Teacher

b. Grade

5. After pressing import, using normal Access functionally, the .csv file is imported into tblStudents.

6. We press the button “Prepare database for DET??

a. When this is pressed the following happens

b. The user is prompted for the number of photographers at the job with the prompt, “Number of Sets??

i. The user can then enter the number of sets from 1-9.

c. For each record, the following data is added

i. Subject ID = G10 for the first record, G11, for the next record and so on . . . . .

ii. First Name = “-??

iii. Last Name = “-“

iv. SubjectType = “Group??

v. Grade = pre-existing grade in the DB

vi. Teacher = pre-existing teacher in the DB

d. Then, for each Group record create 25 more records with the following data:

i. Subject ID = “STU1000?? for the first record, “STU1001?? for the next record and so on.

ii. First Name = “-“

iii. Last Name = “-“

iv. SubjectType = “Student??

v. Grade = pre-existing grade in the DB

vi. Teacher = pre-existing teacher in the DB

e. If there are “2 Sets requested?? . . . .

i. then the first Set would start with STU1000 and the field “Set??would be populated with a “1?? for each record.

ii. The second set would start with STU2000 and the field Set would be populated with a “2??.

f. If 5 Sets are requested then there would be Sets 1, starting with STU1000 and Set 1, Set 2 starting with STU2000 and Set 2, Set 3 starting with STU3000 and Set 3, and so on.

g. Group records are never duplicated. There is only one set of records where subjectype=Group, no matter the number of sets.

h. When pressing the "Export" button, will launch File/Export for tblStudents.

i. Pressing Delete All Records will delete all records from the database.

Additionally

1) Complete and fully-functional working program(s) in executable form (MS-Access form) as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows XP / MS Access 2003

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: working photographer, work hire photographer agreement, work hire photographer, teacher f, student photographers hire, student photographer hire, student photographer, school photographer job, school 2007, photography engineering job, photographer work hire agreement, photographer work hire, photographers work, photographers photography, party photographers, nature photography job, nature photographer job, job photographers, want photographer job, iv press, hire student job, hire first employee, hire student photographer, hire photography photographer, hire photographer employee

Acerca do Empregador:
( 15 comentários ) United States

ID do Projeto: #2957466

Premiar a:

dperlbergervw

See private message.

$85 USD em 2 dias
(120 Avaliações)
5.6

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

dominique1

See private message.

$102 USD in 2 dias
(420 Comentários)
6.4
brightsolnslx

See private message.

$59.5 USD in 2 dias
(300 Comentários)
6.4
ysrahmed

See private message.

$93.5 USD in 2 dias
(59 Comentários)
4.8
shraddhamit

See private message.

$127.5 USD in 2 dias
(7 Comentários)
4.2
JamesFrith

See private message.

$85 USD in 2 dias
(16 Comentários)
3.7
digigenvw

See private message.

$119 USD in 2 dias
(6 Comentários)
3.3
happyprogrammer

See private message.

$110.5 USD in 2 dias
(8 Comentários)
3.4
lucidsolution

See private message.

$42.5 USD in 2 dias
(3 Comentários)
2.7
vw1352033vw

See private message.

$68 USD in 2 dias
(14 Comentários)
2.4
emarcsl

See private message.

$85 USD in 2 dias
(3 Comentários)
1.9
renua

See private message.

$42.5 USD in 2 dias
(3 Comentários)
1.6
swiplsl

See private message.

$93.5 USD in 2 dias
(2 Comentários)
0.9
hammivw

See private message.

$93.5 USD in 2 dias
(4 Comentários)
0.8
vw6491411vw

See private message.

$68.85 USD in 2 dias
(1 Comentário)
0.0
zicoelferikico

See private message.

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

See private message.

$127.5 USD in 2 dias
(0 Comentários)
0.0
gnetmagic

See private message.

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

See private message.

$127.5 USD in 2 dias
(0 Comentários)
0.0
ingdejan

See private message.

$85 USD in 2 dias
(1 Comentário)
0.0
fistanvw

See private message.

$42.5 USD in 2 dias
(0 Comentários)
0.0