Access 2007 Upgrade to 2010

Storniert Veröffentlicht Oct 4, 2010 Bezahlt bei Lieferung
Storniert Bezahlt bei Lieferung

I am a teacher, so I have very little money and I have to pay for this myself. I have a 2007 MS Access template called Lending Library. I have added several new tables. No new relationships have been created, but I may have messed up some relationships from the original template. That's why I'm calling YOU ! !

The purpose of this database is to track kits that will be loaned out to public school classrooms and returned.

1. I need the database normalized and a couple of new forms or reports added.

2. I need this database to work on a sharepoint 2010 server. Upgrading to Access 2010 is desireable but not required.

3. This database will be posted short term on FPweb sharepoint MOSS 2010 server (or a Sharepoint 2010 test server of your choice) for 6 months. Then it will be migrated to our in-house sharepoint server.

4. The forms need to be available online for multiple users. I will be the admin.

Here is what I am trying to accomplish. I am using terms in the Access 2007 file which I will supply.

I need to keep track of 200 kits that are lent to other teachers.

A teacher gets on a website where Form:User Details appears.

[url removed, login to view] entering name, the teacher first selects which Division {Division ID, "Chesterfield" is first choice]. Upon selection of division, TchSchool ID box is populated with a dropdown list of all schools in that division. Selections of division and specific school are of course posted to userdetails table.

2. Cellphone should be a textnumber or hyphenated number...I don't know how to format that

3. There is another function that I have not developed yet, and that is to create a lesson name that is associated with the period that the kit is on loan for. This is called a Session. Each lesson will have multiple sessions, but the sessions don't have anything to do with the kits being loaned out. They are loaned or checked out by date, and that is already in the template. But we can talk about that later.

The user needs to register for a class and a specific session of that class. Select a box that says "I need a Tech Kit." There should be a function where the database or a form or something automatically assigns the user a kit. The kit will be sent to the user a specific number of days before the session. This "lead time" is set when the admin creates the lesson and session times. The db creates a form which shows on a given day which kits need to be sent out and to whom. There is a form for which kits are overdue. Emails are sent as notices and reminders, and the admin selects email texts

When you solve my issue, I will try to look at the code and understand what you did. If I cannot, I will need you to explain what you did. When this project is over, I need to be able to troubleshoot it myself.

I created an Excel sheet that gives a forecast of inventory levels, and would like to add this function to this database, but that would be a separate price or bid.

of course, of course, this project was handed to me yesterday to accomplish immediately. of course.

Please disregard attached Database4 file. it is too large for Freelancer.com I apologize.

For more details about this project, please inspect attached files. Begin with Production Goals Document. Then see attached images. All tables are also included.

This project is to work in Access for one user. I will migrate it to Sharepoint 2010 test server.

Project is to begin with normalization of all tables and to modify or create new forms as seen in attached production goals document.


Thank you for your continued interest !!

Microsoft Access SharePoint Visual Basic

Projekt-ID: #803169

Über das Projekt

10 Vorschläge Remote Projekt Aktiv Oct 5, 2010

10 Freelancer bieten im Durchschnitt $428 für diesen Job

meetesh

Please let me know when we can discuss

$1000 USD in 20 Tagen
(45 Bewertungen)
7.4
kulhanekd

See pm Donna

$250 USD in 5 Tagen
(30 Bewertungen)
5.7
frehmanpk

Respected Sir, Please see PM for details. Kindest regards.

$300 USD in 7 Tagen
(15 Bewertungen)
4.4
msbatechie

Please read my PM

$750 USD in 5 Tagen
(1 Bewertung)
4.2
freelancerbuzzo

Ready to start right now.

$250 USD in 10 Tagen
(2 Bewertungen)
1.2
Leon1982

I can do this for you.

$399 USD in 10 Tagen
(1 Bewertung)
0.0
Saqibhusnain

A mature and seasoned professional with strong IT Management, Software, Database & Website Development and conceptual skills, demonstrated ability to work effectively with colleagues in a multilingual, multicultural en Mehr

$550 USD in 3 Tagen
(0 Bewertungen)
0.0
radhe003

Ready to do kindly check pm

$255 USD in 5 Tagen
(0 Bewertungen)
0.0
atombabu

I am interested

$250 USD in 30 Tagen
(0 Bewertungen)
0.0