Microsoft Access Jobs

37 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 - Intermediate ($$) - Est. Budget: $20 - Posted
I am making my own POS system with MS-Access. Everything are cool the receipt is printed well and cash drawer is opening after printing on Access but I need to send the signal to the printer to just open cash drawer. I don't know how to send signal to printer with vba. I don't know what code is to be sent. = Environment = Windows 10 64bit MS Access 2016 On Star Micronics TSP100 Configuration; Print test is working. Open CashDrawer 1 is working. I researched to find the code all day long but I couldn't. I think the answer bellow is closest but it is not working with mine.
Skills: Microsoft Access Administration
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
Hourly - Intermediate ($$) - Est. Time: 3 to 6 months, 30+ hrs/week - Posted
Description: Essential Job Functions • Codes, tests, debugs, implements, and documents programs. Assists in the modification of company products and/or customer/internal systems to meet the needs of the client and/or end-user. • Gathers information from the system, analyzes program and time requirements, and prepares documentation to change existing programs. • Researches and analyzes existing systems and program requirements, under periodic supervision. • Designs programs for projects or enhancements to existing programs. • Writes specifications for programs of low to moderate complexity. • Assists in resolving production support problems. Develops and suggests alternative approaches to resolving problems. • Develops test plans to verify logic of new or modified programs. Identifies issues as appropriate. • Creates appropriate documentation in work assignments such as program code, and technical documentation. • Conducts quality assurance activities such as peer reviews. • Remains abreast of and researches industry technical trends and new development to maintain current skills and remain current with industry standards. Qualifications Basic Qualifications • Bachelor's degree or equivalent combination of education and experience • Bachelor's degree in computer science, mathematics or related field preferred • Three or more years of experience in programming or testing • Experience working with appropriate programming languages, operating systems and software • Experience working with relational databases to facilitate programming software Other Qualifications • 7+ years of experience in front-end development for on-line reporting using MS Access and MS SQL Databases. • Experience in object-oriented design and analysis. • Extensive experience in full software development life cycle including requirements definition, prototyping, design, coding, testing and maintenance. • Strong background in database development and proven history as a team player. • Must be able to compile and maintain an enterprise schema across all applications and enforce the principles of good (authorized/accepted) data design. • Design and maintain data architecture that accommodates changing business priorities and technological changes. • The position is responsible for extensive hands-on data modeling, front-end development, data acquisition, analysis, database design as well as interfacing with internal business partners to gather, critically assess, and implement business requirements for statistics-based reporting spanning financial and project development activities. • Expertise in planning, analysis, design, and implementation. • Ability to handle critical data/database management initiatives - including responsibility for database architecture, design, integration, and/or data modeling. • Incumbent will develop tests plans, procedures and data, and evaluates system, effectiveness and efficiency. • Willingness/ability to take ownership of a project and ability to manage multiple complex exercises in various stages simultaneously. • Languages - VBA, SQL. Tools SQL Server. Management Sudio 2005/2008/SSRS, MS Office 2010, VBA - Access & Excel.
Skills: Microsoft Access Administration Visual Basic VBA
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