Solved

How to set up a simple database?

Posted on 2016-09-28
5
34 Views
Last Modified: 2016-10-18
I need a database for this information.

Date
School
Teacher
Grade
Half-Day/Full Day
0
Comment
Question by:Gina Barlow
5 Comments
 
LVL 95

Accepted Solution

by:
Lee W, MVP earned 251 total points (awarded by participants)
ID: 41820534
The simplest thing to do is use Excel.  Otherwise, if you have Microsoft Access, you could use that... but if you don't know databases - REAL databases, then you should probably pick up a book / google for Access Database Tutorial for Beginners and pick one you like.

In excel, setup a column for each and just make an entry for each each day.  If you can be more specific, we may be able to be more specific.  You could probably setup a gig and have someone create this for you...
0
 
LVL 19

Assisted Solution

by:crystal (strive4peace) - Microsoft MVP, Access
crystal (strive4peace) - Microsoft MVP, Access earned 83 total points (awarded by participants)
ID: 41820574
in my opinion, especially if you will expand and add more related information and an easy way to create reports and queries, Access is the way to go.

if there is one book you read, and read again till you know everything in it, it is this one:

Access Basics
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access

I have a playlist on YouTube for learning Access.  The numbered lessons start from total beginner ... and then I am not done with the numbered lessons so I put more basic videos after them.  They are free.  Look at each video description for more information and referenced links.

Learn Access Playlist on YouTube
http://www.youtube.com/view_play_list?p=1B2705CCB40CA4CA
1
 
LVL 15

Assisted Solution

by:John Tsioumpris
John Tsioumpris earned 83 total points (awarded by participants)
ID: 41820631
There is starting tutorial from Microsoft
Although is for Visual Studio the principles are the same...
0
 
LVL 9

Assisted Solution

by:davidanders
davidanders earned 83 total points (awarded by participants)
ID: 41822298
Knowing the OS, number of people accessing the data, one computer, local network or internet access would help.

There are free database applications, most require some database knowledge.
The Top 7 Free and Open Source Database Software Solutions
http://blog.capterra.com/free-database-software/

Alternative To  lists application options
http://alternativeto.net/software/microsoft-access/

There are online customizable database apps. Google searches are drowned out by Zoho, Knack, and other commercial apps.
https://www.fusioo.com    is one
0
 
LVL 19
ID: 41847965
This thread has been inactive for 14 days.

Good answers were given but the original poster did not add any comment.

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
understanding output of mysql version 2 65
Sql Join Problem 2 53
Documenting Data flow 4 48
form builder not starting 3 56
I annotated my article on ransomware somewhat extensively, but I keep adding new references and wanted to put a link to the reference library.  Despite all the reference tools I have on hand, it was not easy to find a way to do this easily. I finall…
CCModeler offers a way to enter basic information like entities, attributes and relationships and export them as yEd or erviz diagram. It also can import existing Access or SQL Server tables with relationships.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

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