Access 2016 'Product Inventory' Database Template - Amendment to 'Customer' form
- or -
Post a project like this$$$
- Posted:
- Proposals: 9
- Remote
- #1847641
- Expired
REACT jS|ANGULAR 2+|NODE JS|EXPRESS JS|AWS|WORDPRESS|MONGO DB |WEB DEVELOPMENT|MY SQL|PHP WEB DEVELOPMENT
Bangalore
AUTOMATION EXPERT l VBA l PYTHON l SQL l POWER AUTOMATE l WINAUTO l DATA ANALYSIS l ACCESS
Greater Noida
Email Deliverability, DNS, Google Workspace, Office 365, DMARC, Website Migration Expert
Accra
⭐⭐⭐⭐⭐ Top Rated Speed Optimizer For WordPress, Shopify, Magento, Prestashop, we improve the performance of the website and get you the prefect 100% score in google
Amravati
1568397176840386560187822529412138997627026916460921890803
Description
Experience Level: Expert
General information for the business: Small British 4-way Stretch Garment Manufacturer
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: Have an Access 2016 'Product Inventory' Template Database which we have previously split, uploaded to SharePoint, shared, saved local copies to use as Ui for small Team of 4. This has now been deleted from SharePoint as have all lists, tables etc. In order for us to now hone database to our exact requirements.
Work to be done:
1. 'Customer Details' form (which has built in relationships, queries etc)
Require a 'lookup' in 'Company' field which also has facility to add new - want to be able to choose 'Company' and if not existing then type in New Company name which would display in 'Company' field in existing 'Customer Details' form
Users would then only require to add Contact Details and Address in a new 'Customer Details' form.
I appreciate, it would make more sense to have separate 'Contacts' and 'Address' tables and forms etc, however we really need this up and running now, so this seems like a quick solution that would not affect existing relationships, queries of the 'Customer Details' form.
Only really interested in Freelancers that would be available to undertake immediately as need this work completed straight way please.
Have attached image of form and happy to send database.
NEED to ensure all existing tables, queries, forms & Macros keep their integrity.
Many thanks
Debs
Extra notes:
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: Have an Access 2016 'Product Inventory' Template Database which we have previously split, uploaded to SharePoint, shared, saved local copies to use as Ui for small Team of 4. This has now been deleted from SharePoint as have all lists, tables etc. In order for us to now hone database to our exact requirements.
Work to be done:
1. 'Customer Details' form (which has built in relationships, queries etc)
Require a 'lookup' in 'Company' field which also has facility to add new - want to be able to choose 'Company' and if not existing then type in New Company name which would display in 'Company' field in existing 'Customer Details' form
Users would then only require to add Contact Details and Address in a new 'Customer Details' form.
I appreciate, it would make more sense to have separate 'Contacts' and 'Address' tables and forms etc, however we really need this up and running now, so this seems like a quick solution that would not affect existing relationships, queries of the 'Customer Details' form.
Only really interested in Freelancers that would be available to undertake immediately as need this work completed straight way please.
Have attached image of form and happy to send database.
NEED to ensure all existing tables, queries, forms & Macros keep their integrity.
Many thanks
Debs
Extra notes:
Debbie S.
100% (6)Projects Completed
5
Freelancers worked with
4
Projects awarded
42%
Last project
26 Aug 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies