Completed

Update Access Database Form and Report

We have an existing Access database that has forms and queries built that generate reports. Need to have it updated with the following changes:

MANIFEST GENERATION FORM (screenshot attached)

1) Add "Resource Request #" - Type: text field

2) Add" Standby (Yes/No)" - Type: drop down - 2 values: Yes, No

3) Add "Date - Arrived at Incident" - Type: text field with date picker

4) Add "Date - First Duty Day" - Type: text field with date picker'

5) Add "Date - Manifest Created" - Type: text field with date picker

6) Add "Marshaling Point" - Type: text field

7) Update "Crew Type" drop down" add "IFR Scan" as an additional option.

8) Rename "Mobilization Date" to "Date - Left Home Base"

9) Rename "Project/Fire#/Stby" to "Incident or Project #" (remove any default value)

NEW TABLE

10) Add a Fire_Centers table. This will have 2 columns: Name, Phone_Number.

11) The "Name" column will populate the "Fire Center" drop down on the manifest generation form. The associated "Phone_Number" will populate the "Fire Center Phone" field on the Manifest Report.

MANIFEST REPORT UPDATES (screenshot attached)

I've attached markup of the changes.

12) Remove 2 rows at the top

13) Add new table at the top (below header). All the fields are shown in the mockup and would need to be auto populated from the tables. I can help explain where each vale is stored n which [url removed, login to view] fields will be populated and map to the input options on the Manifest Generation Form. Can make the font size, table height and general layout etc the same as the personnel table below. I pasted in the table from excel so looks bigger in the mock up than we want.

14) At the top add a title for the document: "Contractor Personnel Manifest" (shown in mock up)

We are looking for quick turn around time for this.

Thanks,

Skills: C# Programming, Microsoft Access

See more: using front page update access database, vbnet update access database excel, script update access database web form, sql, database administration, database development, database programming, update access database csv, ssis script update access database, access database crystal report cards design, script update access database javascript, script update access database, update access database, update access database using script, javascript update access database, update access database excel, simple vbscript update access database, access database attendance report, update access database using asp, update access database website script

About the Employer:
( 144 reviews ) Vancouver, Canada

Project ID: #14948466

Awarded to:

fuentro

To modify a database based on the points explainedin your briefing Relevant Skills and Experience MS Access VBA SQL Proposed Milestones $194 USD - Complete the changes in the project briefing How soon do you need th More

$194 USD in 2 days
(0 Reviews)
0.0

23 freelancers are bidding on average $191 for this job

TopTower22

hello,how are you. i read your bid carefully. i am Access DB, C# expert and have full experience for 7 years. Access, C# language is my top skill and my interested skill. I can provide most quality and high fast. i More

$155 USD in 3 days
(15 Reviews)
5.9
zu02

Hi , I can make all 14 your assignments for $350 during 3 days. Thanks Relevant Skills and Experience access,vba, sql,ado Proposed Milestones $388 USD - default

$388 USD in 3 days
(34 Reviews)
5.9
mrrapp

I have been an independent Access programmer in New Jersey for the last 20 years. Access is all I do, full-time. I can work on the project right away. Relevant Skills and Experience I have designed thousands of Acces More

$250 USD in 3 days
(6 Reviews)
4.7
amraltweky

Hello cdmediasl, I am ready to start now Relevant Skills and Experience MS Access Forms, Reports queries , also i have solid experience in SQL queries

$111 USD in 0 days
(13 Reviews)
4.5
dineshmore

Hi Myself expert in Dot net technologies with 12+yrs of experience in software development. Developed various web and desktop based projects in Finance, Insurance, Research, Education , Research and Retail Domains. More

$250 USD in 3 days
(19 Reviews)
5.0
$250 USD in 3 days
(8 Reviews)
4.3
NayaPakistan

A proposal has not yet been provided

$198 USD in 1 day
(5 Reviews)
3.6
chryonsoftware

This looks to be a very simple project, and I would be very happy to assist you in it. I have been working with software on a multitude of levels for over 8 years, everything from Access Databases to fill site design More

$137 USD in 5 days
(1 Review)
3.1
dpune

add new functionalities in MS Access forms Relevant Skills and Experience MS Access Proposed Milestones $200 USD - Completed work Hello, I have more than 14 years of exp. Completed 320+ projects. Look at my feedback More

$200 USD in 5 days
(4 Reviews)
2.9
$194 USD in 2 days
(3 Reviews)
2.9
polarjin2017

I am good in Desktop, Mobile and Website building and 5 years development experience. And I am experienced in Desktop and Web development with Microsoft technologies using C#, WPF , UWP, MFC, C++, Java, Python, A More

$155 USD in 3 days
(2 Reviews)
2.6
huongth

Hi. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now Relevant Skills and Experience I am an expert i More

$277 USD in 3 days
(4 Reviews)
1.9
$250 USD in 3 days
(1 Review)
1.3
sajibdigital

I am interested in your project and would like to discuss with you. please reply to me on chat, I am waiting for your response. Relevant Skills and Experience Access Proposed Milestones $200 USD - project

$200 USD in 3 days
(2 Reviews)
1.1
$111 USD in 3 days
(1 Review)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
alhassanlatif

Hey, I can do the required job in Access I have built many complicated databases using Access please message me for more details Relevant Skills and Experience I have experience in Access ,SQL and VBA for years Prop More

$88 USD in 3 days
(0 Reviews)
0.0
$155 USD in 3 days
(0 Reviews)
0.0
kevalshah1195

As per your suggestions, your changes on table on relative fields will affect in queries and reports in Access application. All your steps are acceptable and I can be able to make/modify this project, as I am having a More

$155 USD in 3 days
(0 Reviews)
0.0
krishnasoftweb

Hey I know I don't have good rating to impress you & new [login to view URL] I have more expertise and creativity you deserve for you project. Lets make a website best more than you expectation. Relevant Skills and Experie More

$222 USD in 3 days
(0 Reviews)
0.0