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

ID de proyecto: #8184179

Adjudicado a:


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)

67 freelancers están ofertando el promedio de £479 para este trabajo


ID : 8184179 Greetings, We are interested to work on this project, please find my comments inline with yours, [url removed, login to view] are a printing company who needs a order database developing for MS Access 2010. =>Ok, Let me kn Más

£388 GBP en 12 días
(223 comentarios)

Hello, I am employed MS Access/SQL Server developer specialized in Databases. I saw the screenshot and read the description. I understand that application is outdated and I can recreate in office 2010 or 2013 for you. Más

£355 GBP en 30 días
(25 comentarios)

Dear, I am Access/VBA expert since 11 years. I checked your project description, and I confirm I can develop your Access DB. -Could you send me more details and screenshots about your project ? I will focus on use Más

£494 GBP en 7 días
(78 comentarios)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a database. I have 7 years’ experience designing and developing Access databases. I would approach your project by creating a draft Más

£600 GBP en 14 días
(85 comentarios)

Scarrot writes: "have to enter the details every time".. Ouch! I feel your pain - Let's get this done! Greetings from the U S A.. {smile} Highly experienced (20+ years) MsAccess Business programming and database Más

£526 GBP en 10 días
(16 comentarios)

I have 15 years experience in access database design and development. I have completed well over 250 custom databases in this time. I have worked on existing databases and created from scratch. A list of some databases Más

£333 GBP en 10 días
(28 comentarios)

Hello, I represent Automyze Consulting. We are a business process automation firm based out of India. We recently solved a very similar automation problem for another printing company in UK. Like you, they also Más

£1111 GBP en 21 días
(49 comentarios)

Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer and a mathematician with a strong background developing a wide range of accounting, economical, statistical and mixed type p Más

£555 GBP en 10 días
(41 comentarios)

Good day, my name is Rodrigo. I have been developing MS Access solutions and applications for my workplace for the past 6 years, during this time I have been in charge of: designing, planning, implementing and maintain Más

£555 GBP en 7 días
(27 comentarios)

Hi I am interested in this project. I am an experienced MS access applications developer. i can do this job for you. If interested in hiring me then please let me know so that we can finalize the scope, timelines and Más

£333 GBP en 10 días
(67 comentarios)

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
(24 comentarios)

I am a software developer with 10+ years experience. I am currently consulting for a Fortune 50 company doing work primarily in Access and Excel with VBA. I have extensive experience in other aspects of software develo Más

£250 GBP en 15 días
(14 comentarios)

Dear Buyer, I am working with Access databases since 1998 (versions 95 up to 2010). First of all, I had a first look at your jpg. As it seems, you have already some items as drop-down lists but you lack two basic thing Más

£250 GBP en 10 días
(24 comentarios)

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)

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)

Hi, I have been developing solutions for more that 20 years. I will be happy to provide you with the solution you want. After the acceptance, I will provide 1 month of FREE support to make sure that the systems is run Más

£500 GBP en 21 días
(13 comentarios)

I am expert in all version of MS Access. I have developed many application using MS Access. Please contact me. I am ready to start work

£750 GBP en 10 días
(2 comentarios)

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)

Hello sir/madam, However, I am new here in 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)

Hi I'm an IT Project manager in a local bank with over than 20 years of experience in banking software development. Im an expert in .NET (c#, vb, c++), vba and sql server technologies I sugest you to work with an SQ Más

£555 GBP en 10 días
(6 comentarios)