En cours

Optimise Database

The task is to update and improve an existing database in Microsoft Access 2010, and some problems we are having.

this database has three main tables and is used daily to keep track of visits that our speakers make to schools. It holds contact information from schools and speakers. this includes emails and address information for regular group e-mails. At the moment it is the school holidays so work is quiet. I would like this project completed by the 9th May,

An additional use is to store feedback from the visits.

The main part of the database that changes frequently is the Visits Table (tbVisits). The data is fed in data from SurveyMonkey – that downloads into CSV [url removed, login to view] of these can be provided. The Visits table draws together information from schools (tbSchools), information from speakers (tblSpeakers) to create a single event (a visit by a speaker to a school).

In our offices we coordinate these visits. Each visit will go through different stages (field name for this is “status”) as the arrangements become finalised, from:

“requested” to “arranging” to “upcoming” to hopefully “visited” or “cancelled”

Each school year these will be stored under a different School Year (08-09, 09-10, 10-11, 11-12)

Specific tasks:

1. Within a query be able to change the status of the visit – at present it is stuck with whatever was originally picked in tblVisits

2. Make importing data from Survey Monkey easier for both tbVisits tbTeacherFeedback

3. Search for a school and/or speaker within a form.

4. FrmVisits only searches for the current year visits eg 10-11

5. We download lots of the data in spreadsheet format to send to volunteers at present the spreadsheets show the autonumber instead of the text attached to it.

6. Create an attractive form which will show tblVisits in datasheet view with drop-down boxes at the top to select particular parameters, including region and status. This will allow user to quickly select particular sets of visits to work on.

We are looking for someone who can fix these issues but also suggest ways to make the database work more efficiently, especially suggesting ways we can get volunteers to access the database online to ‘sign up’ to speed up the process.

Compétences : Microsoft Access

Voir plus : top query, top it problems, stuck at work, region 13, online database work, more visits, access group, optimise access database online use, spreadsheets online, microsoft spreadsheets, microsoft access online, survey part 3, school database, monkey, fix database, spreadsheet holidays, attractive online store, create access database spreadsheet, microsoft query top, fix problems access, access query table, fix database access, event spreadsheet, fix query, send form data spreadsheet

Concernant l'employeur :
( 4 commentaires ) London, United Kingdom

N° du projet : #1031056

Décerné à :


Hi, please check PM

150 $ USD en 5 jours
(17 Commentaires)

19 freelance ont fait une offre moyenne de 217 $ pour ce travail


Hi RDSuk, Please see my PM.

50 $ USD en 2 jours
(30 Commentaires)

Hello Ready to start right now. Please see your PMB for details. Thanks

175 $ USD en 7 jours
(27 Commentaires)

Respected Sir, I have already done similar type or projects and can handle and advise with great comfort. Please see PMB for details & I m Ready to start immediately. Surety of quality work done with 100% accuracy wit Plus

150 $ USD en 1 jour
(14 Commentaires)

Hello, Please check your PMB

200 $ USD en 20 jours
(15 Commentaires)

Good afternoon I have send you a document via the message board with some information about me and some questions. Bye Ian Smith

250 $ USD en 5 jours
(2 Commentaires)

Please check PM

170 $ USD en 7 jours
(4 Commentaires)

Please check PMB for details.

1000 $ USD en 20 jours
(2 Commentaires)

Exceptional quality & Quick work. Please refer to Profile & Reviews for details. Thanks FAZ

225 $ USD en 3 jours
(2 Commentaires)

please see pmb for details

200 $ USD en 15 jours
(1 Commentaire)

pls share with me the data base file, i have plenty of expereicne with MS access Data Bases.

200 $ USD en 3 jours
(0 Commentaires)

I have over 13 years experience in working with databases (I was a Database administrator for 5 years) and with coding applications, including Access forms. Let me help you maximize the potential of this database!

150 $ USD en 2 jours
(0 Commentaires)

hello, check PM! i'm wait)

300 $ USD en 14 jours
(0 Commentaires)

see PMB Regards

250 $ USD en 10 jours
(0 Commentaires)

Sir, Plz see your pmb for more detail.

200 $ USD en 10 jours
(0 Commentaires)

Hello, please check PMB for details. Thanks!

200 $ USD en 10 jours
(0 Commentaires)

Hi there, I am a professional London based database developer and consultant and am very happy and keen to help you in this and am sure I can deliver you a tailored solution. Please check your pm. Regards

170 $ USD en 2 jours
(0 Commentaires)

Have worked for English Local Government. Please see Personal Message.

200 $ USD en 5 jours
(0 Commentaires)

You can send access file to me by mail

30 $ USD en 1 jour
(0 Commentaires)

I able to do your [url removed, login to view] check the PM.

50 $ USD en 10 jours
(0 Commentaires)