Completado

Create a Jobs Database in MS Access

We are a printing company who needs a order database developing for MS Access 2010. We have been using Lotus Approach for this purpose since 2003 but this is now massively out of date and very limited. The current database has 7100 orders in it which would need to be imported into the new system. The current data can be exported to an Excel Sheet/DBF file or any other format that can be used.

The database needs to be able to keep customer details (name, contact, phone, email) in a table and link these to an 'Orders' table. Within each order, there will be one or more items. Each item in an order will detail the product being ordered, the type and weight of paper, the quantity ordered, etc. Some of these fields are simple text entry, some would need a drop down with options (possibly taken from another table).

Currently this is all done on a single entry screen, putting data into a single table, so there is no customer management (we have to enter the details every time). We would like relationships creating so that if customer details are changed once, they change every time we can update customer details easily. It would also be useful to have the option of more than one contact name/number/email for a company, that can viewed easily.

I've put on a screenshot showing an example entry on the current database, to show the information that would need to be in the new database. This currently limits us to 4 items per order. The new system should be able to handle any number of items on each order. We would need the order form to have an 'Add Item' button which would bring up an additional form to put in the details for the item. It should then be easy to view and search past orders.

We don't necessarily need everything designing to look pretty, as we can modify the look of the various forms afterwards if required. We need the functionality setting up and the contents of the existing database importing and setting up correctly.

We haven't tried to do something like this before, so i have no idea what to set the budget as. Please quote realistically. We will be able to supply a full brief of everything required before proceeding.

Habilidades: Desarrollo de base de datos, Microsoft Access

Ver más: what we have to do in data entry jobs, what to do in data entry jobs, what jobs can i do, what is a jobs, what is a data entry form in a database, type setting jobs, time management jobs, should i change jobs, product development jobs, product development brief, product designing and development, printing company jobs, phone jobs, order form format in excel, order entry jobs, new product development brief, new haven jobs, ms access jobs, ms access form data entry, ms access data entry forms, ms access data entry form, ms access database jobs, ms access database development, ms access 2010 data entry form, jobs using excel

Información del empleador:
( 4 comentarios ) Sheffield, United Kingdom

Nº del proyecto: #8184179

Adjudicado a:

danielrinf

Hello there. I will be glad to help you to develop this app in msAccess 2010. According with you needs, I can offer you the following modules: 1) Customer manager module: A window where you can add, edit and susp Más

£300 GBP en 10 días
(17 comentarios)
0.0

66 freelancers están ofertando el promedio de £478 para este trabajo

fazeelatmazhar

Sir/Madam, Greetings. This is an IT person , an experienced database developer , an experienced designer and an experienced technical writer. I have developed university management system , advanced timer, file t Más

£300 GBP en 5 días
(9 comentarios)
0.0
point5nyble

Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in Más

£400 GBP en 10 días
(27 comentarios)
0.0
sargardon

Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in Access and .Net programming. I am ready to work for you for free until you get the results. I can develop an Access datab Más

£333 GBP en 10 días
(4 comentarios)
0.0
Grunty

Hello, I've got extensive experience with MS-Access and VisualBasic/VBA. Several projects in my FL job history were actually developed in MS-Access, even though not labelled as such by the project creators. I convin Más

£350 GBP en 20 días
(6 comentarios)
0.0
Giolisbeth

The good news is that there is a Lotus version that I can use, and even better. First of all, I respect and look after the integrity of the data that already exists (7100 orders), which would be charged to the system o Más

£333 GBP en 5 días
(0 comentarios)
0.0
Aldo21

Hi: I am a database developer and administrator. I can easily take this project on. Please consider me for it. regards, Aldo

£250 GBP en 5 días
(0 comentarios)
0.0
NeilSargent

I am an expert in Microsoft Access with 17 years’ experience and particular skills in VBA and integrating Access with Excel, Word and Outlook. I specialise in bespoke application development. I use a modular system Más

£600 GBP en 10 días
(4 comentarios)
0.0
Mohict

A proposal has not yet been provided

£444 GBP en 15 días
(0 comentarios)
0.0
NewYorkStranger

I have developed in MS Access for well over a decade and can send you an example DB if you wish. If all data is received this should not take a very long time.

£277 GBP en 5 días
(1 comentario)
0.0
bvrmboystore

A proposal has not yet been provided

£555 GBP en 10 días
(0 comentarios)
0.0
ENRICOJ

HI. I HAVE EXSTENSIVE EXPERIENCE IN DATABASE AND DATABASE APPLICATION DEVELOPMENT ,MAINLY USING MS ACCESS. I CONCENTRATE O 3 AREAS: 1)PROPER DATA STRUCTURES,2)FUNCTIONALITY,3)USER-FRIENDLY EXPERIENCE. PLEASE FEEL Más

£250 GBP en 10 días
(10 comentarios)
0.0
AliSafder

Hi, This is really a routine work to fine tune databases and adding functionality to it with great maintenance and up-gradation skills. I also have over 8 years of experience in Databases like Sql Server, Oracle Más

£250 GBP en 10 días
(5 comentarios)
0.0
Nisar69

Hi, I have experience in Database Designing and doing jobs related to MS Access and MS SQL. I can provide you quality work as per demand. Best Regards.

£277 GBP en 15 días
(0 comentarios)
0.0
evv59

Предложение еще не подано

£333 GBP en 10 días
(0 comentarios)
0.0
pramodv

I am proficient in web development using HTML5, CSS3, Javascript, jQuery, jQuery UI, Ajax, Bootstap, Foundation, Asp.Net MVC etc. I have also have strong experience of software development using Foxpro, Visual Foxpr Más

£555 GBP en 10 días
(1 comentario)
0.0
iwonadomino

Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA Más

£250 GBP en 3 días
(0 comentarios)
0.0
pegasus9529

Hello, good day to you. I am fulltime freelancer that already made a money from this portal. Microsoft Access database is my strong skill and i love it and i am verified member on freelancer.com. I am interesting to bi Más

£450 GBP en 5 días
(1 comentario)
0.0
acronymsolutions

Hi, I am 19+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL,MSSQL Server 7.0/2000/2008R2 and Onwards. Data Base Tools : Database Configura Más

£666 GBP en 15 días
(15 comentarios)
0.0
rsliter

Hello, I’m newer to this freelancing website and am just beginning to build my online reputation and client base. Over the past 17 years, I’ve worked in a variety of functions spanning Information Technology, Suppl Más

£500 GBP en 10 días
(6 comentarios)
0.0
Altantsetseg

Hi, From your project description, its the kind of job I have been experienced very well. d I can complete your project by your requested time frame because I nkow what I should do. I have been experienced in progr Más

£333 GBP en 10 días
(4 comentarios)
0.0