
Simple Access Database proof of concept
- or -
Post a project like this3487
$$
- Posted:
- Proposals: 3
- Remote
- #1182841
- Completed
Description
Experience Level: Intermediate
Estimated project duration: 1 day or less
General information for the business: Consulting Firm
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: I am in need of a simple access database for use as a prototype. If the concept is accepted, I may use you to refine the database. I know the basics of Access and this would probably take me 2 hours max to do. The needs are simple:
A table called "Ideas" with 7 fields:
Unique Key
Industry
Client
Group
Topic
Idea
Decision
An example record is: KEY | Energy | Acme Co. | Tax | Property Tax | Audit all property tax bills | GO
I would need a fairly simple way to import/append additional records into the main "Ideas" table every once in a while as we work with additional clients and have a list of new ideas to add.
I need a query/form which allows me to enter 1 or more search terms for:
Selection box for Industry
Selection box for Company
Selection box for Group
Selection box for Topic
Text box to enter a keyword that would pull matching records from the Idea field
The selections/search terms would return matching records in a table with a simple way (one button click) to export these to Excel.
That's it!
Specific technologies required: Ideally Microsoft Access but am open to a highly secured internet based solution that could be accessed securely by 10 people.
Extra notes: This is a prototype only. It is ok to keep it simple.
Database management system (DBMS): Microsoft Access
Description of requirements/functionality: I am in need of a simple access database for use as a prototype. If the concept is accepted, I may use you to refine the database. I know the basics of Access and this would probably take me 2 hours max to do. The needs are simple:
A table called "Ideas" with 7 fields:
Unique Key
Industry
Client
Group
Topic
Idea
Decision
An example record is: KEY | Energy | Acme Co. | Tax | Property Tax | Audit all property tax bills | GO
I would need a fairly simple way to import/append additional records into the main "Ideas" table every once in a while as we work with additional clients and have a list of new ideas to add.
I need a query/form which allows me to enter 1 or more search terms for:
Selection box for Industry
Selection box for Company
Selection box for Group
Selection box for Topic
Text box to enter a keyword that would pull matching records from the Idea field
The selections/search terms would return matching records in a table with a simple way (one button click) to export these to Excel.
That's it!
Specific technologies required: Ideally Microsoft Access but am open to a highly secured internet based solution that could be accessed securely by 10 people.
Extra notes: This is a prototype only. It is ok to keep it simple.
Jeff F.
100% (4)Projects Completed
5
Freelancers worked with
4
Projects awarded
43%
Last project
11 Oct 2016
United States
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