Solved

Microsoft Access/Database for beginner.

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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Office 365 home questions 7 65
Create tables in access db (2016)  using vba 13 42
Access report groups with sums 5 28
Trying to force an answer in a combobox 7 18
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

778 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