Solved

How to set up a simple database?

Posted on 2016-09-28
5
29 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 18

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 13

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 8

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 18
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction: Often, when running a query with joins, the results show up "duplicates", and often, those duplicates can be "eliminated" in the results using DISTINCT, for example. Using DISTINCT is simple: just add it after the SELECT keyword, an…
This article describes some very basic things about SQL Server filegroups.
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…

708 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

19 Experts available now in Live!

Get 1:1 Help Now