Upgrade our MS Access Database

I have gone through the attached pdf and have got some questions.. 1- ‘appliance-centred’ system where we ‘add’ appliances to cases.. So do you need a screen where user select case and then appliance and map them ? Will there be a need to assign multiple appliances to a single case or one to one relation is there ? 2-add’ replacement parts to that appliance.. Parts are already defined in the existing database or we will add on the fly when we are working on Quotation ? 3- attach documents to cases... will we need to store the documents in the database or save on physical hard disk and save document path in database table ? (it covers point 6 of document..i guess) Looking forward to have a chat with you to discuss further.

*** Dear, I AM EXPERT MS ACCESS DATABASES *** I checked your requirements file, I can have some questions, could you contact me ? I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice

Hello! I am ready to carry out your project in the shortest possible time and with the highest quality! You can read reviews about my work at: https://www.freelancer.com/u/VladimirLilenko?w=f From the Microsoft Access, of course, familiar. Regards, Vladimir

Good day, My name is Donna. I have read your project description and appreciate the geat detail you provided. I bellerive I would be an ideal candidate to complete your database. I am a expert Microsoft  Access database developer, I am also an expert in Microsoft Excel. I have completed all classes from beginner to expert in 2007 to 2016 Microsoft  Excel and Access.  I have created well over 350 custom databases in 19 years.  I am fluent in VBA, Macros, Vba lookups, Mysql, complex formulas,  and many other excel and access functions.  I guarantee my work.  If there is any error after project completion, please do not hesitate to contact me to get it resolved.  I also charge $40.00 an hour for changes and upgrades.  I have screenshots of past work on my profile.  If you feel my qualifications are a good fit for your project, needs please contact me.  If not best of luck. I hope you have a blessed day Donna

Hi Alan, I'm an expert Access / MS-SQL database application developer with 20+ years experience in developing business databases. Per your requirements, I am bidding to make enhancements, fixes and maintenance on your Access database. Per your requirements, I shall do all the items ( 1 - 6) detailed in the PDF file. Also - For document management, its never a good idea to put documents in the database, and these need to go into a shared folder on the PC (the database will be responsible for copying the documents to the folder and retrieving them). I can write the code for this accordingly. Estimated delivery time is: 10 days or less, with frequent updates as work progresses. I shall also offer FREE ongoing remote support for any technical issues. Good quality work done. I will also be available on the long term should you need additional modifications or support. Thanks for considering my bid. Best wishes, Steve ~ Larry Anselof Technology Solutions - Providing a quality and reliable freelance software development service since 2004 ~

Hi, Greetings! ✅checked your project details: Upgrade our MS Access Database ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion.. Thank you Sandeep Digital screencast

Hi, I had studied your attached Mulcahy Tech Documentation. I can update the existing database app to include assignment of a status to the quotation and other specified business needs. I had done a similar Access projects before with 5* ratings: • https://www.freelancer.com/projects/microsoft-access/Microsoft-Access-VBA-Application/ • https://www.freelancer.com/projects/database-programming/legal-finances-database-improvements/ • https://www.freelancer.com/projects/php/build-ACCESS-Database-with-external/ • https://www.freelancer.com/projects/excel/Access-Database-design-18665960/ • https://www.freelancer.com/projects/microsoft-access/Microsoft-Access-VBA-Application/reviews • https://www.freelancer.com/projects/database-administration/Customer-desktop-database-management/ • https://www.freelancer.com/projects/database-programming/Convert-data-Word-table-Access/ • https://www.freelancer.com/projects/database-programming/data-base-search-options/ I am an experienced Access Developer with Database Programming, Analysis and Administration skill. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. EDUCATION • BSc Computer Sciences, University of Hertfordshire, UK 2014 • Microsoft Certified Business Intelligence Developer 2009. • Microsoft Certified SQL Server Administrator 2008. • compTIA A+ Certified 2008

Hello there, I am interested in the project. I have gone through the requirement details document and I am sure I can implement the requested features. For addition of new appliances and parts data can be added to a new table as master records and in frontend a list loaded from those data can be presented for user to choose. For storing documents it is not recommended to store the data directly into the database as it'll increase the chance of data corruption and affect performance of database. The ideal way would be store the files in filesystem, network drive and use the file path only in database. Also it is advisable to keep the data and frontend in two different files. For more discussions please message me. Thank You.

Hello I hope all's well with you. I'm professional Ms Access/Excel/vba coder. I'm coding in vba since Ms Office 97 released. Really most of my projects I've developed in freelancer.com . Please visit :https://www.freelancer.com/u/zu02?w=f And please see for example the following screens in my portfolio : "Access Attendance", "Invoice & book-keeping management" and " Create sales and purchases database application" . Those 3 app-s will give you a little view about my coding capabilities . Based on your instructions with PDF you've uploaded, I can code all including to split DB by fe and be , for your ms Access DB , professionally and on time. I charge $1125 but I can offer a lower rate. I hope hearing from you soon. Thank you for your consideration and Best Regards, Zurab Esartia

Hello and Good day. I can and able to upgrade your MS Access database using the guidelines your provided on your PDF attachment. I went trough it and I would say that the necessary changes are pretty basic and we can implement it without any problems. Message me whenever you are free and we can talk more about this project. Thanks and have a nice day.

Hi, I am ready to work on your project to upgrade your access database, please give me more details about the requirements. I have experience in MS SQL server, asp.net, crystal reports and VB.net more than 13 years. Other skills: Access vba, Excel vba, C#, my sql , technical & Sage 300 (ACCPAC) ERP support, SQL server Replication, Microsoft office(Word, Excel, PowerPoint, Access), Windows servers. Best Regards. Khaled Alflah

Dear Mr. Alan, Mulcahy Technical Services Ltd. Re: Requirements for upgrade of Service Management Database I have experience working on MS Access and look forward to work on the proposed new features of Phase-1, that would upgrade existing version of Services for your Equipment Catering business requirements. I understand that major areas I need to develop include: 1. Adding "appliances" to cases with repair note 2. Adding "replacement parts" to Appliance with status: requested / quoted / fitted, 3. Generate "Quotation" with parts and labour cost, 4. Generate "Service History" for specific appliances, 5. Attach documents to cases and/or appliances, 6. Splitting of database. As full stack, developer I will provide with development, testing, deployment, scaling, management and ongoing support. Payment terms can be discussed and may be made in milestones after you are satisfied with the work done. Ongoing support is available when needed. Can share work experience and references in Personal Message Board. Looking ahead to hear from you, Thanking you, Best of Regards, Ajit

Alan, I would be pleased to make your required changes and provide support for your Access database on an ongoing basis. I am very familiar with you type of application – one of my main clients used to provide a catering equipment repair service. Although your database does need to be split it will not solve the bloat problem. Your backend database will simply bloat instead. You need to store the documents separately and provide links to them from within the database. This type of docuemnet management is another of my specialities. I have over 20 years experience developing applications in Access, Excel, Word and Outlook with advanced knowledge of SQL and VBA. I build my applications on a standard "framework" application. I would be pleased to demonstrate systems which I have developed, to give you an idea of the quality of my work. I also have a number of clients who have come to me with an existing system which needs modification or maintenance. I take a flexible approach ranging from giving tuition to users who want a maintain a DIY approach to a total adoption of the system and responsibility for all changes and maintenance. I have clients in countries all over the world. We interact via email, telephone and TeamViewer. Please call me on 0292 125 8848 to discuss your requirement in more detail. I am available from 09:00 to 19:00 BST/IST Kind regards Neil Sargent Please note: All services delivered within the EU are subject to VAT at the standard rate.

I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access certified. I'm confidence I can help you to finish this project for you as requested.

Ready to do the necessary new functions, enhancements and modifications to the existing ms access application as required and described in the project requirements file you attached Regards, Rageg

I am programming on access and coding VBA for 22 years. Focused on production and maintenance applications. Have done much more complex programs. Your requirements are easy to apply and the DB *must* be split into frontend/backend for security matters. Feel free to get in contact for any question and to discuss the project

Hello! Thank you very much for describing the requirements in the attached PDF document. I understood what was described and noticed that there are two critical points that are: 1. The size of the database 2. Instability when the database is accessed by multiple users. Below is my strategy for these critical points: 1. The database does not necessarily need to be divided (I will analyze your database before deciding). 2. The scanned images, photos and files will not be kept in the database, but only the path of the directory where the file is located, thus the size of the database decreases in an incredible way. 3. I will develop an automation to check the size of the database and if necessary, compress it to reduce its size. Know that the divided database (front end and back end) is usually slower than an undivided database), so I will evaluate the cost benefit of each case to be applied in your database. I have been an expert in Access databases for many years. For a client of mine, who is a chain of toy stores across the country, I managed to make a database in Microsoft Access with more than 50 GB of information.

Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, C#, and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.

Experienced Solution Architect with over 25 years in the design and development of large applications. Have a good knowledge of MS Access and can develop / add new features to this application. We can split the database and we can also move the backend to some RDBMS as SQL Server / MySQL etc which will make the system more robust.

Dear Sir/Madam, I am an experienced MS Access application developer and will be happy to work on your project. I have developed many projects using Access as the front and back end. I have developed solutions for Customer Relationship Management, Project Tracking, Academics Databases, Human resources, Patient Management, Lease Management, Pharmacy Retail Software, Law Practice Software. Best regards, Anita