Microsoft Access Jobs

43 were found based on your criteria {{|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 Budget - Intermediate ($$) - $100 to $200 - Posted
We are running a greenhouse operation that we want to manage using access. I have outlined my requirements for this system below, starting with tables and fields. One main concern for us is the user interface, we want to make it as professional and as if it was an enterprise level software. • Clients table o Client o Address 1 o Address 2 o City State o Phone Number o Email o Payment Terms o Input Date o Delivery Charge Checkbox • Crops o Crop o Strain o Organic check box o Nursery Time o Growout Time o Average Yield • Sections o 96 Sections (expandable) o Status (Empty or Filled) • Invoices o Client Relation o Total (All Crops Due that Day + Shipping) o Invoice Date (Date of Creation) o Subtotal (all crops due that day) o Delivery Cost (100/subtotal unless client delivery checkbox is unchecked o Paid Checkbox • Locations o Client Relation o Location Name o Address 1 o Address 2 o City State o Phone Number o Email o Input Date • Orders o Uniqu o Crop Relation o Pounds o Price per Pound o Location Relation o Client Relation o Delivery Date (Input Date + 30) o Input Date o Total (pounds*price per pound) o Planting Date ([Delivery Date]-([Nursery Time]+[Growout Time])*7) o Transplant Date ([Planting Date]+[Nursery Time]*7) • Recurring o Active checkbox o Client Relation o Locations Relation o Crop Relation o Pounds o Price per pound o Day of Week o Input Date o # of Work Orders (Pounds/Crops[Yield]) So these are the tables I am currently envisioning. The process should be as follows. 1. We enter a client 2. We enter a location for that client 3. We enter a recurring order for a client 4. Users can enter one off orders via a form *All these should be available for users to enter via a well-designed form 1. 30 Days before a recurring order is due, a work order generates (multiple if specified) 2. The work order generates with a Planting Date, Transplant Date and Harvest Date 3. Each day the orders are checked for a transplant date, if the transplant date matches, the work order looks through the sections to find an available section and associates that number with the work order and marks the section. Need some sort of warning incorporated in this to warn us if we have over sold our potential output 1. Each day the orders are analyzed and invoices are automatically created to consolidate work orders due that day and to invoice our client 2. Mark any sections that have been “harvested” as empty Reports – Designed more as a to do list or very simple reporting tool for our operations team: • Currently Growing Out o Shows everything that is currently not harvested and is associated with a section • Currently in the Nursery o Any work orders that do not have a section associated with them • Harvest Today o All work orders with a Harvest date for today • Invoices o Well-designed invoice for each client that requires an invoice today o Drop down for picking invoices (grouped by day) would be ideal • Past Due Invoices o Any Invoices that are not paid and due date has passed • Plant Today o Any orders with a Plant date today • Transplant Today o Any orders with a transplant today
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $400 - Posted
Would like an Access data base to keep track of Clients, PCAs (Personal Care Assistant Staffs), and QPs (Qualified Professional Supervisors). This data base must be able to help the organization track client service authorization, training and evaluations of staffs and supervisors, service rendered, and billing of service. The database will assign clients and staff unique ID number. This data base should allow us to generate reports such as Billing per period per client (periods are weekly or biweekly - Sun to Sat), Training and compliance status report for staff and supervisors, Evaluation report of staff and supervisor by client, Units/hours worked by PCA or QP by Client, Client roster by status by Payee, PCA roster by status, QP roster by status. Also, the data base must be set up to be user friendly and adding clients, pca, and QP should be easy. We currently keep track of the above via excel spreadsheet and will provide the spreadsheet to show the data we inputting and tracking. We have requirements that are in the attachment. If you have other ideas, please let us know.
Skills: Microsoft Access Administration Microsoft Access Programming Visual Basic
Fixed-Price - Expert ($$$) - Est. Budget: $500 - Posted
I'm looking for an experienced Access developer to create a simple database for me to help track incidents for a volunteer fire department. Table 1 = Roster Badge Number, Company, First Name, Last Name, Rank Table 2 = Incident Number, Month, Year I would like a few forms, very simple: 1) Add/Remove Member from roster. So that chiefs can add/remove people without actually going into the table. 2) Add incident. Very simple, it asks "WHat month is your incident from" . . .Incident Number, choose your company. . . . then check off or type in the badge numbers who were present at that incident. Only need 1 reporting feature: Choose incident to report on. . . select which Company(s) to report on. . . . Then it will tell me which firefighters responded to that selected incident. I have a much more complex excel sheet that actually calculates the pay for each firefighter that I would eventually like to incorporate into this access database, but that will be a separate job. Much bigger. Depending on how I like the Database you provide, and the price, I will hire you for that second job as well. For now, Its just this simple DB.
Skills: Microsoft Access Administration Microsoft Access Programming
Fixed-Price - Intermediate ($$) - Est. Budget: $30 - Posted
I need an expert person to help me with a task that will need finished ASAP. I need this by April 6th at noon. I am in the USA and on eastern standard time, which the due date is by my time. I don't want someone that has never heard of the program before. You must know what you are doing. Please don't waste my time!!!! How many years have you used this program? Why should I hire you? My budget is $30. I will not hire someone that is out of my budget.
Skills: Microsoft Access Administration