I need some Microsoft Access 2010 Tables and forms made
- or -
Post a project like this2898
£350(approx. $437)
- Posted:
- Proposals: 11
- Remote
- #1142017
- PRE-FUNDED
- Awarded
Microsoft Access Developer, Access Developer, Access Development, Access Database Developer, MS Access VBA Developer
Paris
website customization, web based application, High accuracy ✌Data scraping, ssl setup, wordpress, zen-cart customization
Pathankot
Professional Engliash to Spanish Translator, German to Czech, Content Writer, Design Expert, Microsoft Office Specialist
Kingston
36481599925111500276193323452595619672617800399107669511773551250008
Description
Experience Level: Intermediate
Please can anyone help me to link tables in Access 2010 so that I can open a form (from a form) to add more info for that person that enters a different table. I am thinking of member in one table, then member address in another, then telecoms in another etc. For different member types I need to add more information into yet another table. I can then use queries to filter out what I need to display. I thinks it's fairly basic work but I have wasted too many hours trying on my own. I could provide sample data and instructions. Thanks, Sue
UPDATE
Due to early landslide of responses (Thank you all) I will take a day or two (sorry) and put together more explicit details of what I need and upload it. It's not the form design or styling that I need its just making a functioning relational (small) database so that I can retrieve data from all of the information I have been collecting using queries (I can do that). Please watch for next update. Thank You. PS I will also post a budget at that point.
Proposed Update by: Sue Furness Fixed Price offered: GBP £350
Deposit £50
Date: 8 May 2016
1. I have decided to have someone build a relational database from flat file data.
2. I can provide the data either in Excel tables or in tables (Around 6 main tables) in Access with lookups in place.
3. I estimate 9 forms; 2 Input Masks and some coding for filtering for display.
4. That someone will be required to use my fields, which can be arranged in different tables as necessary.
5. The data are both people and organisations, called [Members].
6. Members can be classified as [General Members] and [Venues].
7. General members require just a few fields for the purposes of identification and mail outs.
8. Venues are organisations, which fall into a local catchment [City] or global catchment [Country].
9. A Venue will belong to one of 5 [Types].
10. Venues with more than one site, means that they are located in a physically different place (on a map say). This means a venue [Parent] could have more than one address [Child].
11. Each [Venue] will have a specific [Site Name] that identifies the [Child]. E.g. Starbucks, Swindon High Street, Starbucks Swindon Motorway Services.
12. Each [Address] will have a specific set of [Telecoms] related to that address.
13. Each [Venue Type] will have a specific set of [Key Info Details] used for filtering.
14. Venues can edit their own [Key Information] on [Sign-Up] mostly from [Lookup lists]. New Venues can add themselves to the listings via a self-registration form.
15. It is possible that a [General Member] could (immediately or subsequently) be the individual who becomes the [Level 1 Contact] for a [Venue]. A Level 2 (or Senior Contact) can be added later if required.
16. Currently the overall size of Member’s data is around 500 records (2 Cities, 1 Country) but this will be a growing database.
17. This is the same data, with similar functionality, that will exist online but for now I want to be able to work on it separately - in a Windows Microsoft Office + (Access) 2010 environment.
18. An [Account] page will display information from all the tables (linked) for all records (General Members and Venues).
19. The database needs to be built so that I can query and edit it. Permissions are required for a Co-Worker for checking and data input.
20. I can supply a sample of test data initially and require all the data merged when the database is complete.
21. The information shared by me is confidential and subject to a Non-Disclosure Agreement (Attached) Please sign and return.
22. I am fairly sure of this design layout however some variation could be required if problems surface.
23. I estimate that at the higher end PPH hourly rate x 10 hours should be a sufficient budget for this build. I propose £350 payment for this job. Deposit £50.
I would like to hear from anyone who is interested and I will release very specific details to assist once I proceed with one developer.
Thank you for your interest.
Sue
UPDATE
Due to early landslide of responses (Thank you all) I will take a day or two (sorry) and put together more explicit details of what I need and upload it. It's not the form design or styling that I need its just making a functioning relational (small) database so that I can retrieve data from all of the information I have been collecting using queries (I can do that). Please watch for next update. Thank You. PS I will also post a budget at that point.
Proposed Update by: Sue Furness Fixed Price offered: GBP £350
Deposit £50
Date: 8 May 2016
1. I have decided to have someone build a relational database from flat file data.
2. I can provide the data either in Excel tables or in tables (Around 6 main tables) in Access with lookups in place.
3. I estimate 9 forms; 2 Input Masks and some coding for filtering for display.
4. That someone will be required to use my fields, which can be arranged in different tables as necessary.
5. The data are both people and organisations, called [Members].
6. Members can be classified as [General Members] and [Venues].
7. General members require just a few fields for the purposes of identification and mail outs.
8. Venues are organisations, which fall into a local catchment [City] or global catchment [Country].
9. A Venue will belong to one of 5 [Types].
10. Venues with more than one site, means that they are located in a physically different place (on a map say). This means a venue [Parent] could have more than one address [Child].
11. Each [Venue] will have a specific [Site Name] that identifies the [Child]. E.g. Starbucks, Swindon High Street, Starbucks Swindon Motorway Services.
12. Each [Address] will have a specific set of [Telecoms] related to that address.
13. Each [Venue Type] will have a specific set of [Key Info Details] used for filtering.
14. Venues can edit their own [Key Information] on [Sign-Up] mostly from [Lookup lists]. New Venues can add themselves to the listings via a self-registration form.
15. It is possible that a [General Member] could (immediately or subsequently) be the individual who becomes the [Level 1 Contact] for a [Venue]. A Level 2 (or Senior Contact) can be added later if required.
16. Currently the overall size of Member’s data is around 500 records (2 Cities, 1 Country) but this will be a growing database.
17. This is the same data, with similar functionality, that will exist online but for now I want to be able to work on it separately - in a Windows Microsoft Office + (Access) 2010 environment.
18. An [Account] page will display information from all the tables (linked) for all records (General Members and Venues).
19. The database needs to be built so that I can query and edit it. Permissions are required for a Co-Worker for checking and data input.
20. I can supply a sample of test data initially and require all the data merged when the database is complete.
21. The information shared by me is confidential and subject to a Non-Disclosure Agreement (Attached) Please sign and return.
22. I am fairly sure of this design layout however some variation could be required if problems surface.
23. I estimate that at the higher end PPH hourly rate x 10 hours should be a sufficient budget for this build. I propose £350 payment for this job. Deposit £50.
I would like to hear from anyone who is interested and I will release very specific details to assist once I proceed with one developer.
Thank you for your interest.
Sue
Sue F.
0% (0)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
6 Jul 2016
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