Microsoft Access Database Project
- or -
Post a project like this3145
$$
- Posted:
- Proposals: 14
- Remote
- #886375
- Completed
Business Analyst - SQL Server and Business Intelligence Developer - Business Solution Designer - Software Architect
Rochester
34 years in IT, as analyst, developer, manager and director, bilingual Spanish/English, focus on customer, simple solutions & creative skills.
Buenos Aires
963451354955857067273110092346479465547846508980416102150410276431034380
Description
Experience Level: Intermediate
Estimated project duration: less than 1 week
General information for the business: Mental Health Charity
Description of requirements/functionality: Add functionality to existing MS Access Database
Extra notes: We're a charity looking for help with our research database. We'd like the following things done please....
Forms:
00 IH Main Input Form
Can we amend the form so that changing the number in the box (top left hand corner of form) changes the Primary Key record that this form puts data into? (At the moment you have to click on the record direction buttons at the bottom of the database) If this isn’t possible, could there be a button to add new record for different primary key?
Would it be possible to add a button for add additional record for this primary key?
Tables:
00 IH Person SOURCE table - Add “consent” checkbox
01 IH ContactInstance SOURCE Table – team can see raw data and may break it! Can we hide this?
Queries:
Create a query for researcher – if consent box is checked in 00 IH Person SOURCE table, then all fields are populated into query, if consent box not checked then the following fields would be populated with “no consent”: Notes, Brought to attention by, comments on wellbeing, planning & goals, actions, comments on risk, safety plan,
Questions
Is there an easy way to export a query and share it? (Rather than sharing the whole database)
Would it be possible to import old data?
Description of requirements/functionality: Add functionality to existing MS Access Database
Extra notes: We're a charity looking for help with our research database. We'd like the following things done please....
Forms:
00 IH Main Input Form
Can we amend the form so that changing the number in the box (top left hand corner of form) changes the Primary Key record that this form puts data into? (At the moment you have to click on the record direction buttons at the bottom of the database) If this isn’t possible, could there be a button to add new record for different primary key?
Would it be possible to add a button for add additional record for this primary key?
Tables:
00 IH Person SOURCE table - Add “consent” checkbox
01 IH ContactInstance SOURCE Table – team can see raw data and may break it! Can we hide this?
Queries:
Create a query for researcher – if consent box is checked in 00 IH Person SOURCE table, then all fields are populated into query, if consent box not checked then the following fields would be populated with “no consent”: Notes, Brought to attention by, comments on wellbeing, planning & goals, actions, comments on risk, safety plan,
Questions
Is there an easy way to export a query and share it? (Rather than sharing the whole database)
Would it be possible to import old data?
Katie F.
100% (5)Projects Completed
8
Freelancers worked with
6
Projects awarded
80%
Last project
12 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