Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Microsoft Access/Database for beginner.

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views 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 Microsoft Access…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

828 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