MS Access database and related tables and forms


This should be a pretty simple project for an Access expert. I need a MS Access database created in order to do bids for construction clients. I will populate the tables, I need you to create the tables and one form and ensure that the system "hangs together". This program is going to be used by our estimators in the field and our bidding department in the office. The tables will be pretty straight forward. Here is what I will need the form to do:

1. Bidding Form - this is blank form with drop down lists as follows:

a. Drop down list for Client

b. Text boxes for Job Location and related information

c. Drop down list for Trade

d. Drop down list for Room

e. Drop down list for items of work to be done. Since we will have multiple line items there will need to be a button for "New Line Item" so our estimator can add as many lines as needed

f. For items that are priced per a certain unit, such as square feet, there needs to be a field for the # of units. This will be used to calculate the total price for that line item

g. Warning prompts based on dependencies, e.g. if our estimator selects a certain item of work he should be prompted that we can't do that item without doing another, so both need to be included in the bid. We will provide all dependencies

h. Three simple "Yes/No" check boxes

i. Text box/field for Notes

j. One check box that can be selected if the job is Awarded. This will then create a new record in the Awarded Jobs table.

k. Must be able to export to Excel, Word, and we must be able to have it print in a specific way (our clients have their own ways of wanting to see information).

Skills: Contracts, Microsoft Access

See more: what job for an excel expert, trade jobs, square jobs, print estimator jobs, n.j. jobs, ms project jobs, ms project expert, ms excel expert jobs, ms access work, ms access jobs, ms access database jobs, microsoft project jobs, microsoft office jobs, microsoft jobs, microsoft excel 2013 expert, microsoft access jobs, microsoft access job, lists jobs, k jobs, jobs ms project, jobs ms access, jobs microsoft excel, jobs microsoft access, jobs in microsoft access, jobs in an office

About the Employer:
( 53 reviews ) Santa Clarita, United States

Project ID: #4853122

34 freelancers are bidding on average $663 for this job


You mentioned that the program will be used by estimaters on the field, if so what device you will be providing estimators and how will be network for these devices, will they be connected thr' VPN to office ? OR thr' More

$633 USD in 15 days
(237 Reviews)

MS Access expert here. I have done a lot of MS Access here in freelancer as shown in profile. We can develop the using MS Access 2007/2010.

$555 USD in 2 days
(45 Reviews)

MS Access expert here - have completed over 100 such projects on this site with 5-star ratings. Rajiv

$555 USD in 3 days
(60 Reviews)

Hi, I am a developer with over 23 years experience building complex database systems, specialising in the development of applications in MS Access using VBA and WinAPI. I could do this project to your specification. Pl More

$750 USD in 14 days
(14 Reviews)

13+ years of Access/VBA programming. Please see the PM for project comments.

$527 USD in 6 days
(7 Reviews)

Hi, I can do the job, just send me all information and field do you need to include in the form I am very skilled MS Access developer Regards Diego

$600 USD in 10 days
(15 Reviews)

10+ years experience. 500+ projects completed. I have read the project description and I can start the task immediately.

$1200 USD in 21 days
(14 Reviews)

Hello Sir, kindly check PMB.

$500 USD in 14 days
(11 Reviews)

Highly skilled [20+ years] MsAccess programmer / analyst with extensive Accounting, Estimating and indented Bill Of Material experience. Well spoken and written American English is our only language. Confidentiality gu More

$1500 USD in 31 days
(5 Reviews)

I can help you please check your Inbox.

$631 USD in 12 days
(2 Reviews)

1. We have big experience in MS Access, Excel, Word, Visual Basic, VBA, Visual Basic.NET, C# , Crystal Reports and MS SQL, MySQL 2. We have developed pure MS Access applications, applications that uses MS SQL as Dat More

$555 USD in 21 days
(1 Review)

Hi, I have plenty of time and knowledge to complete this job. I guarantee that the job will satisface all your requirements. Respectfully, Liviu

$500 USD in 7 days
(2 Reviews)

Over 20 years of experience in organization environments with much pressure and critical situations. SQL Server, VB.NET, MSAccess, ASP.NET, HTML5, Javascript, jQuery, CSS3 at your disposal.

$789 USD in 10 days
(1 Review)

Hello, I can help.

$500 USD in 5 days
(1 Review)

Hi, I can develop your application, See sample applications in your PMB. You are welcome to ask any question or concern. Thanks

$800 USD in 4 days
(1 Review)

Hi I will do this for you. Please check PM.

$500 USD in 5 days
(5 Reviews)

Please check pm for detail bid.

$1111 USD in 20 days
(1 Review)

Hello sir, I have done a similar project before. I can complete well this one. Please choose me. Thank you. Best regards,

$500 USD in 2 days
(1 Review)

Experienced VB coder and MS Access database development. I can do certain queries with no problems.

$500 USD in 7 days
(0 Reviews)

Hi sir.., i'm interested in doing this job.., please check my PM for the detail of my proposal...

$550 USD in 5 days
(0 Reviews)