Đã hoàn thành

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.

Kĩ năng: Microsoft Access

Xem nhiều hơn: 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

Về Bên Thuê:
( 4 nhận xét ) London, United Kingdom

ID dự án: #1031056

Được trao cho:


Hi, please check PM

$150 USD trong 5 ngày
(17 Đánh Giá)

19 freelancer đang chào giá trung bình $217 cho công việc này


Hi RDSuk, Please see my PM.

$50 USD trong 2 ngày
(30 Nhận xét)

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

$175 USD trong 7 ngày
(27 Nhận xét)

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 Thêm

$150 USD trong 1 ngày
(14 Nhận xét)

Hello, Please check your PMB

$200 USD trong 20 ngày
(15 Nhận xét)

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 trong 5 ngày
(2 Nhận xét)

Please check PM

$170 USD trong 7 ngày
(4 Nhận xét)

Please check PMB for details.

$1000 USD trong 20 ngày
(2 Nhận xét)

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

$225 USD trong 3 ngày
(2 Nhận xét)

please see pmb for details

$200 USD trong 15 ngày
(1 Nhận xét)

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

$200 USD trong 3 ngày
(0 Nhận xét)

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 trong 2 ngày
(0 Nhận xét)

hello, check PM! i'm wait)

$300 USD trong 14 ngày
(0 Nhận xét)

see PMB Regards

$250 USD trong 10 ngày
(0 Nhận xét)

Sir, Plz see your pmb for more detail.

$200 USD trong 10 ngày
(0 Nhận xét)

Hello, please check PMB for details. Thanks!

$200 USD trong 10 ngày
(0 Nhận xét)

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 trong 2 ngày
(0 Nhận xét)

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

$200 USD trong 5 ngày
(0 Nhận xét)

You can send access file to me by mail

$30 USD trong 1 ngày
(0 Nhận xét)

I able to do your [login to view URL] check the PM.

$50 USD trong 10 ngày
(0 Nhận xét)