Solved

Microsoft Access/Database for beginner.

Posted on 2014-12-13
5
170 Views
Last Modified: 2014-12-17
I have a little programming experience mainly using Borland C++ in the past. I am nowadays trying to create a software which mainly will do the following :

- The user will select a list of variables (e.g. symptoms of a disease)
- The software will list the possible disease according to the symptoms selected
- The software will suggest a proper therapy.


And this should go vice versa . (e.g. selecting a therapy , then the software will automatically list the diseases which can be treated with this therapy, or selecting a disease and then the software will automatically list the symptoms etc.)

I've been told that the best way to do it is to use Microsoft Access (Database). Since i don't have really any serious experience with Microsoft Access or Database programming in general, I would appreciate if i could get some general guidelines regarding the design of your database tables and relationships. (most important thing is to know where to start, what should i study in order to accomplish my goal).

Thanks a lot.
0
Comment
Question by:Chrysaor
5 Comments
 
LVL 83

Expert Comment

by:Dave Baldwin
ID: 40497820
First thing is that Microsoft Access is only available with Microsoft Office Professional.  The current version is $399.99 from the Microsoft Store http://products.office.com/en-us/professional .  It appears that you can get it cheaper other places.  They all appear to be downloads.
0
 
LVL 18

Assisted Solution

by:Simon
Simon earned 100 total points
ID: 40497830
Id suggest the tables for the three entities (Diseases, Symptoms, Therapies), then junction tables that link pairs of these items together (Disease_Symptoms and Disease_Therapies).

You populate the dropdowns in the user interface:
a)  from the DISTINCT values in symptoms and can then query for matching diseases and matching therapies.
b)  from the DISTINCT values in therapies and can then query for matching diseases and matching symptoms.
0
 
LVL 23

Accepted Solution

by:
Eirman earned 350 total points
ID: 40497836
Assuming that you have set up Access ....
Perform a search for something like beginners guide to access
https://www.google.ie/search?num=40&newwindow=1&q=beginners+guide+access&oq=beginners+guide+access&gs_l=serp.3..0i22i30l10.895301.908985.0.914247.22.17.0.5.5.0.229.1308.16j0j1.17.0.msedr...0...1c.1.60.serp..0.22.1318.IjdQ9t6OvMU
youtube is a great resource for beginners and intermediate users.
There are also some excellent tutorials here on EE.  Start with this one.

Your project is fairly complex and rather than jumping in at the deep end you should start with a few simple projects. then you might be able to use/comprehend SimonAdept's response..

Before you tackle your main project, create a simple flat database for something like your DVD collection
Even as a beginner, it should take less than an hour.

Then create a somewhat more complicated database for your Contacts/Customers and your communications with those customers.  This will require two tables and a one-to-many relationship. You will also have a few forms, one of which will contain a subform. As a beginner this might take you 4-7 hours.

Once you have done that, you can then start your main project with much more confidence and you will be able to ask the right questions here. Just create the tables and relationships and post a description of the project here with a screenshot of the relationships.

Make sure you have read up on many-to-many relationships which involve junction tables

Read this guide when designing your main project
http://www.quepublishing.com/articles/article.aspx?p=27785
0
 
LVL 24

Expert Comment

by:Phillip Burton
ID: 40497868
Dave, Access is available separately, which would be a lot cheaper - less than $100. It is also available in Office 365 pay monthly form.
0
 
LVL 26

Assisted Solution

by:Nick67
Nick67 earned 50 total points
ID: 40498570
The fundamental skill required for starting a database from scratch is data normalization.
A VERY good tutorial is here
http://www.phlonx.com/resources/nf3/

Walk through it, with your prospective data in mind!
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question