Đang Thực Hiện

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 thêm: 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

Mã Dự Án: #1031056

Đã trao cho:

djucuti

Hi, please check PM

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

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

winghei

Hi RDSuk, Please see my PM.

$50 USD trong 2 ngày
(30 Đánh Giá)
5.4
KellogITSolution

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

$175 USD trong 7 ngày
(27 Đánh Giá)
4.6
frehmanpk

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 Giá)
4.4
amnmttl

Hello, Please check your PMB

$200 USD trong 20 ngày
(15 Đánh Giá)
4.3
IanSmithISA

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 Giá)
3.9
finsoft03

Please check PM

$170 USD trong 7 ngày
(4 Đánh Giá)
3.1
dev3dworx

Please check PMB for details.

$1000 USD trong 20 ngày
(2 Đánh Giá)
3.0
oFAZo

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

$225 USD trong 3 ngày
(2 Đánh Giá)
2.2
albariconsulting

please see pmb for details

$200 USD trong 15 ngày
(1 Đánh Giá)
1.0
punshar71

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 Giá)
0.0
kroshty32

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 Giá)
0.0
levitan9

hello, check PM! i'm wait)

$300 USD trong 14 ngày
(0 Đánh Giá)
0.0
fdave

see PMB Regards

$250 USD trong 10 ngày
(0 Đánh Giá)
0.0
muhammadibaad

Sir, Plz see your pmb for more detail.

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
gutibs

Hello, please check PMB for details. Thanks!

$200 USD trong 10 ngày
(0 Đánh Giá)
0.0
porchelino

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 Giá)
0.0
gacove

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

$200 USD trong 5 ngày
(0 Đánh Giá)
0.0
mhelkomy

You can send access file to me by mail

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0
smbakhtiar

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

$50 USD trong 10 ngày
(0 Đánh Giá)
0.0