Solved

Microsoft Access/Database for beginner.

Posted on 2014-12-13
5
163 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 82

Expert Comment

by:Dave Baldwin
Comment Utility
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:SimonAdept
SimonAdept earned 100 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

762 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now