In Progress

Convert small Excel database/info to MS Access for Tracking Job Status

We have an Excel spreadsheet that tracks the status and information regarding about 100 current jobs. We want to convert it to MS Access to allow multiple users, better reporting, better usability and easier entry and tracking of comments re status.

We will of course provide the existing Excel which will provide the fields needed. The new MS Access needs to have:

* simple New Job input screens;

* Status Comments: Ability to enter information regarding the current status of the job - needs to record the date of entry of each comment, and show the most recent couple of comments - prior comments can scroll out of view;

* Report Summary Page;

* Ability to Report in other ways, such as per Staff Member;

* Ability to calculate dates and highlight if something is overdue;

* ability to move the record to a Finalized List (which obviously retains all information);

We would like a Fixed Price for the creation. In the event of post-creation amendments we'll pay by the hour.

Fairly small job. Needs a quick turnaround once green light is given so that data doesn't have to be entered in old and new systems.


Skills: Excel, Excel Macros, Excel VBA, Microsoft Access

See more: how to create a database in excel 2016, excel relational database template, microsoft access employee database template free download, excel database examples, when to use access instead of excel, microsoft access, access database templates, microsoft access tutorial, convert excel database access, small excel database, convert excel file pdf ms access vb, convert exe files database ms access, convert ms access database exe, convert ms access database exe, convert ms access database program, convert ms access database standalone software, convert ms access database stand application, convert ms access database work web server service, database design ms access, database factory ms access sqlserver

About the Employer:
( 0 reviews ) Australia

Project ID: #17522761

Awarded to:


Hello and Good day. I would like to take on this project. MS Access Development is my bread and butter so building apps just like this will be fast and accurate. I already built several medium-scaled application using More

$120 USD in 7 days
(51 Reviews)

26 freelancers are bidding on average $203 for this job


I am ready to convert excel DB to access DB. I am able to create/Improve online database so that multiple users can access into db and keep track. I have 7 years’ experience designing and developing Access databases. F More

$294 USD in 5 days
(185 Reviews)

Hello, I can help with you in your project Convert small Excel database/info to MS Access for Tracking Job Status I have more than 5 years of experience in Excel, Excel Macros, Excel VBA, Microsoft Access. We h More

$250 USD in 3 days
(274 Reviews)

Dear Client, We are interested in your project and ready to go for it. We have read your job description carefully and understood the project. We have done similar projects so confident to handle this project. Yo More

$235 USD in 3 days
(112 Reviews)

Hello! My name is Paris Pallas and just had the chance to read your project's brief. I was very excited that you mention Microsoft Excel and Access because related projects are among the tasks I work with regularly More

$250 USD in 5 days
(190 Reviews)

Hi! I think I can make this in up to two days if I push hard, however, I do not see anywhere less than 10 hours of work to make it be good. Here is my offer, estimated deadline (by what I saw in attached PDF's) and More

$270 USD in 3 days
(202 Reviews)

Hi there,I am Miljan,Excel and MS Access expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish i More

$235 USD in 3 days
(77 Reviews)
$320 USD in 3 days
(120 Reviews)

I would like to discuss little bit more about the project for appropriate duration and cost as well. Hi Mr. Employer I have lot of experience in Access and I can do this project in effective manner with 100% accuracy More

$30 USD in 1 day
(97 Reviews)

Dear Sir, Greetings. I have developed similar MS Access db for another client. That was an elevator company who get orders and later distribute the job to respective departments. Each department has it's own login More

$250 USD in 6 days
(102 Reviews)

Hi, my name is Rodrigo. I have read the project description and I can assist you in this development. I also have a suggestion to develop this in .NET to increase security while also maintaining the multi-user functio More

$235 USD in 5 days
(29 Reviews)

Hi, I'm a senior databases developer. I have developed multiple CRMs, Inventories and Information Systems from scratch using Ms Access, SQL and VBA. I have read your project description and I'd like to help you devel More

$200 USD in 5 days
(67 Reviews)

Hi I can Convert small Excel database/info to MS Access using MS Access. Do you have more detaiils for this project? I'm Ms Access/VB/SQL/Access/Excel programmer since 1997. Really all my projects here I've devel More

$250 USD in 5 days
(50 Reviews)

Hi, My name is Janis and I have been here in freelancer since 2014. One of the preferred freelancer because of the good standing and have good feedback from previous employers. I was asked by the freelancer staff Tim More

$250 USD in 5 days
(18 Reviews)

Hi, I'm an expert Access / database developer with several years experience. I can convert the Excel spreadsheet to a fully functioning multi-user Access database. High quality work done. Will provide support whe More

$300 USD in 4 days
(32 Reviews)

Hello I can help you to get it done quickly. I have 10+ years experience in Microsoft Technologies development Like MS SQL, Visual Basic, MS Access and Excel. Thanks Guru Venkat

$155 USD in 3 days
(21 Reviews)

HI, I have excellent experience in Excel and Access and other Microsoft related. I have written complex macros like creating a BoM for an ERP, creating P/L, Cashflow statements from a database. I have worked in More

$223 USD in 10 days
(14 Reviews)

Sir, I am very able to convert this excel database into Access database flawlessly as per requirement. I am very much able to work on this. ***I am ready to start Message me for further discussion. Waiting to More

$194 USD in 3 days
(45 Reviews)
$250 USD in 5 days
(58 Reviews)
$155 USD in 3 days
(16 Reviews)

Hi, there i read your initial requirements and i have some question regarding to your excel database [login to view URL] can we discuss it on chat ? i will wait for your positive response.

$105 USD in 3 days
(5 Reviews)