Microsoft Access Programming Jobs

76 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Fixed-Price - Intermediate ($$) - Est. Budget: $50 - Posted
I need a database created in MS Access with one or two tables and a couple forms as per the attached specification. There are 16 fields. The file format for the imported file including field length and type etc will be sent to the successful candidate.
Skills: Microsoft Access Programming
Fixed-Price - Expert ($$$) - Est. Budget: $1,000 - Posted
We are looking for a Microsoft Access Developer to overhaul our Share Register which was developed using Access. This Share Register holds investor information about investors that invest through our clients (hedge funds). The successful applicant will need to: - amalgamate all our Access files into one (currently we have one file for each client and we would like one master-file where we can select each client from a drop-down menu on the front page). - add in a function that enables us to upload/download pdf documents for each investor - add in an email function where Access will email us on a certain date based on information provided - add several other fields as necessary such as passport expiry dates, a drop-down menu where we can select how risky this investor is (high risk/medium risk etc,) date last review was completed. This information will help determine when the email should go out as mentioned above. The successful applicant will need to sign a non-disclosure agreement.
Skills: Microsoft Access Programming
Hourly - Expert ($$$) - Est. Time: Less than 1 month, 10-30 hrs/week - Posted
We would like a spreadsheet developed that uses exported information from a bidding program to allow for specialized reports and form printing. Vlookup and conditional formatting. This sheet/report would allow our designers to understand exactly how much our estimators have allotted or budgeted construction materials to cost. This will guide them in offering products to our customers that meet the budgets reflected in the estimate. An example would be, if an estimate was accepted to renovate a kitchen, our designer would offer a rage of selections, ie; flooring, cabinets, counter-tops, sinks, faucets, appliances etc. Our estimating software will print out what the total cost of each item but this number reflects material cost as well as the labor to install it. We can however export material cost as a separate line item. We would want this put into an easy format that allowed for us to reduce these numbers by a % to account for our markup. This sheet could also be used as a sign off sheet once items are agreed upon. Please see sample excel sheet so we can discuss options. My cell # is 720.334.8701.
Skills: Microsoft Access Programming Microsoft Excel
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
We had a 2003 Microsoft Access database created for us - we need it updated and completed. This will be on a network drive and shared between 3 users. Ultimately there will be 60-100 work orders (jobs) per month, approximately 350 daily items per vendor, and approximately 60 employees (workers and supervisors). ****** IMPORTANT ****** This will be paid by the project. Please recommend milestones and funding estimates but keep in mind that the goal of the project is a working database that pulls the reports listed below. If the reports don't run properly, everything else in the database doesn't mean anything. ======= Forms that need to be updated ======= Employee Form Add auto-look up so we can automatically look up record by Emp#, First name, or Last Name (currently have to enter field and press ctrl+F - the people using this aren't going to be that savvy). GL, PO, WO Form 1. Current form looks like an Access entry table with "+" signs that need to be expanded to enter in data. Our staff won't understand it. I need form updated so we can enter all of this information without needing to expand the fields. This should look like the rest of our forms. *I need to know if this is possible* 2. I currently can't enter data in properly if I enter in multiple WorkOrder under the same PONbr field. I can enter in duplicate PO numbers in the PONbr field with one WorkOrder under it and it works fine. *I need to know that this is how it's supposed to work.* Job Data Add auto-lookup so we can automatically fill out the top portion of this form. We should be able to look it up by Job#, PO#, or WO ======= Reports that need to be fixed ======= This database was created so we could easily pull these reports, but these have not been finished. Payroll Report 1. I need to be able to select 1 employee and pull their hours for the week. Currently get an error message. 2. The numbers in the report aren't correct - this report needs to be reviewed and updated. PO Report - shows all POs in date range 1. I need this changed to be a calendar icon/date picker to select the dates, not a drop down. Revenue Report 1. Currently asks for supervisor but provides an error message if you select a supervisor. 2. If you don't include a supervisor it includes all information under all supervisors but repeats the same information - so a report that is only 2 pages ends up being 24 pages long. 3. You cannot pull the report by Job ID Billable Report 1. The information on the left side of the report (SOW code, Description, Qty, and Rate) is wrong - it's pulling the right data but the data repeats. Invoice 1. Show titles above final table (SOW Code, Description, Qty, Rate, Total)
Skills: Microsoft Access Programming Microsoft Access Administration
Fixed-Price - Intermediate ($$) - Est. Budget: $100 - Posted
Dear Freelancer, I have a database which its tables are almost ready. I just need the following: 1- To add one more table (for the GL accounts) to the database and link it with another table (projects) with primary key/foreign key (which will require adding more fields to the table "projects"). 2- To add/change some of the tables' attributes as per the attached Excel sheet and implement the constraints in terms of primary key/foreign key. 2- To develop friendly forms that allows users to add/edit/read/search the data within the database. The typical form style should be like the attached Excel sheet which reads/writes in multiple tables and includes drop-down lists, calendars, and text boxes. 3- To create 5 different types of the reports that I will discuss with the candidate once hired and achieved the first and second requirements. Note: I normally give bonuses for outstanding work and things that are being done beyond the scope. Attachments: 1- The MS Excel file that is discussed above 2- The original access database
Skills: Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $40 - Posted
I have a daily report created in Excel that I'd like to import into a table in Access using VBA. I will need to do some analysis and manipulation with the data but I can handle that part. The part I need help with is the following: I'd like to specify a directory on my hard drive that contains roughly 30 excel files and need a script to do the following with it: * Load the first excel file in ascending order, take all the records in the "Scheduled Rescheduled Missed" tab and load it into a table in Access. * In the access table need one more field called "Data_Date" where the date of the excel data is recorded for each record. This date will need to be extracted from the Excel File Name * Go to the next excel file and repeat the process until data from all excel files in that folder has been imported. There is a sample of the data file attached for your reference.
Skills: Microsoft Access Programming Microsoft Excel Microsoft Outlook Microsoft Outlook Development
Fixed-Price - Intermediate ($$) - Est. Budget: $30 - Posted
I have started this new business of taxi rentals. I have created a database. What i wants the candidate to do is: 1. Clean up with database. 2. Design beautiful forms with the logo and branding in place for taxi and drivers. The forms should be able to save and retrieve the database content. Database can be given to interested parties.
Skills: Microsoft Access Programming Microsoft Access Administration
Fixed-Price - Intermediate ($$) - Est. Budget: $150 - Posted
We need to create a link from the Edmunds API database (http://edmunds.mashery.com/io-docs) into Microsoft Access to run queries. Specifically, we need: 1. A step-by-step instruction on how to create links into tables from Edmunds API into Microsoft Access. 2. Once the link between Edmunds API and Microsoft Access has been created, create linked tables for every below source list so that we can run queries from the data. The preference is for you to create the tables in an Access Database that you can send to us, but we will also accept a simple description for how to create the links. The sources are: SPEC: VEHICLE MODEL • All Car Makes: /api/vehicle/v2/makes • Car Make Details by Make Nicename: /api/vehicle/v2/:makeNiceName • Car Makes Count: /api/vehicle/v2/makes/count SPEC: VEHICLE MODEL • Car Model Details by Car Make and Model Nicenames/api/vehicle/v2/:makeNiceName/:modelNiceName • All Car Models by a Car Make Nicename/api/vehicle/v2/:makeNiceName/models • Car Models Count/api/vehicle/v2/:makeNiceName/models/count SPEC: VEHICLE MODEL YEAR • Car Model Year by Car Make and Model Nicenames/api/vehicle/v2/:makeNiceName/:modelNiceName/years • Car Model Year by Car Make and Model Nicenames and the Car Year/api/vehicle/v2/:makeNiceName/:modelNiceName/:year • Car Model Years Count by Vehicle Make and Model Nicenames/api/vehicle/v2/:makeNiceName/:modelNiceName/years/count SPEC: VEHICLE STYLE • Style Details by ID/api/vehicle/v2/styles/:id • Styles Details by Vehicle Make/Model/Year/api/vehicle/v2/:makeNiceName/:modelNiceName/:year/styles • Styles Count by Vehicle Make/Model/Year/api/vehicle/v2/:makeNiceName/:modelNiceName/:year/styles/count • Styles Count by Vehicle Make and Model/api/vehicle/v2/:makeNiceName/:modelNiceName/styles/count • Styles Count by Vehicle Make/api/vehicle/v2/:makeNiceName/styles/count • Styles Count/api/vehicle/v2/styles/count • Styles Details by Vehicle Chrome ID/api/vehicle/v2/partners/chrome/styles/:chromeId SPEC: VEHICLE COLORS AND OPTIONS • List of Options by Style ID/api/vehicle/v2/styles/:id/options • Options Details by ID/api/vehicle/v2/options/:id • List of Colors by Style ID/api/vehicle/v2/styles/:id/colors • Colors Details by ID/api/vehicle/v2/colors/:id SPEC: VEHICLE ENGINE & TRANSMISSION • List of Engines by Style ID/api/vehicle/v2/styles/:id/engines • Engine Details by ID/api/vehicle/v2/engines/:id • List of Transmissions by Style ID/api/vehicle/v2/styles/:id/transmissions • Transmission Details by ID/api/vehicle/v2/transmissions/:id SPEC: VEHICLE EQUIPMENT • Equipment Details by Style ID/api/vehicle/v2/styles/:id/equipment • Equipment Details by ID/api/vehicle/v2/equipment/:id SPEC: VEHICLE SQUISHVINS • Vehicle Details by SquishVIN/api/vehicle/v2/squishvins/:id/ SPEC: VEHICLE CONFIGURATION • the default configured vehicle by zipcode and style ID/v1/api/configurator/default • the configured vehicle with options/v1/api/configurator/withOptions SPEC: VIN DECODING • Basic Vehicle Information by VIN (NEW CARS ONLY)/api/v1/vehicle/vin/:vin/configuration • Full Vehicle Details by VIN/api/vehicle/v2/vins/:vin PRICING: TRUE COST TO OWN (TCO®) • Calculate for New Vehicles/v1/api/tco/newtruecosttoownbystyleidandzip/:styleid/:zip • Calculate for Used Vehicles/v1/api/tco/usedtruecosttoownbystyleidandzip/:styleid/:zip • Calculate Total Cash Price for New Vehicle/v1/api/tco/newtotalcashpricebystyleidandzip/:styleid/:zip • Calculate Total Cash Price for Used Vehicles/v1/api/tco/usedtotalcashpricebystyleidandzip/:styleid/:zip • Vehicle Makes with TCO® Data/v1/api/tco/makeswithtcodata • Vehicle Models with TCO® Data/v1/api/tco/modelswithtcodata • Vehicle Styles with TCO® Data/v1/api/tco/styleswithtcodatabysubmodel • TCO® details for a NEW car/api/tco/v1/details/allnewtcobystyleidzipandstate/:styleid/:zip/:state • TCO® details for a USED car/api/tco/v1/details/allusedtcobystyleidzipandstate/:styleid/:zip/:state PRICING: TRUE MARKET VALUE® (TMV®) • Calculate for New Vehicle with Car Make/Year, MSRP and Zip Code/api/v1/vehicle/:makeNiceName/:year/price • Calculate for New Vehicle with Car VIN, MSRP and Zip Code/api/v1/vehicle/vin/:vin/price • Calculate for New Vehicle with Car Style ID and Zip Code/v1/api/tmv/tmvservice/calculatenewtmv • Calculate for Used Vehicles with Car Style ID, Condition, Mileage and Zip Code/v1/api/tmv/tmvservice/calculateusedtmv • Calculate for the Typically Equipped Vehicle/v1/api/tmv/tmvservice/calculatetypicallyequippedusedtmv • Calculate for the Certified Vehicle/v1/api/tmv/tmvservice/findcertifiedpriceforstyle
Skills: Microsoft Access Programming Database design Database testing
Fixed-Price - Expert ($$$) - Est. Budget: $200 - Posted
Looking for an experienced access db developer who can quickly construct a database to manage a small business. Data entry should be easily accomplished using standardized forms. Reports should be available for a variety of data requests. May involve use of pivot tables and other analytical tools, and calculated fields, etc. Must be open to dialogue and questions before, during and for a reasonable period (1-2 weeks) of time after project completion. Database will be tested by user prior to payment.
Skills: Microsoft Access Programming DBMS