Solved

Online Database Applications: choosing one for my client that has these requiremtns

Posted on 2013-01-05
3
419 Views
Last Modified: 2013-01-05
I am exploring using Access to do this, but I have never put a database for access online, so I'm not sure how current version of MS Access scales for this, can anyone fill me in?

I need about 20 managers to be able to access and edit all elements of data. Its for a training database, with teachers, students, classrooms, etc. I need all managers to be able to enter data online.

Major requirement is that it have a "calender dashboard" so a good scripting features to create something a little more custom or if the database has a great detailed calender dashboard built in.

I'm looking for something like Access or if Access would work, please let me know details. Thanks.
0
Comment
Question by:BackToWorking
  • 2
3 Comments
 
LVL 21

Accepted Solution

by:
mcsween earned 500 total points
ID: 38747275
MS Access is not recommended for more than 5 users and has severe limitations.  I would suggest using sharepoint for this.  You can do a lot with the free version running on Windows Server 2008 R2.  There are many advanced scripting options as well as a ton of web parts (free and for purchase from third parties) that  do advanced calendaring and all types of things.

http://sharepoint.microsoft.com/en-us/Pages/default.aspx
0
 

Author Comment

by:BackToWorking
ID: 38747290
In terms of development, I'm not understanding is sharepoint a relational database like access? And if some of my users are on macs, they wont be able to use it, because windows 7,8 is required?
0
 
LVL 21

Assisted Solution

by:mcsween
mcsween earned 500 total points
ID: 38747319
Sharepoint is an intranet which uses Microsoft SQL server as the back end.  You can run the standard edition of Sharepoint with SQL Express (Sharepoint internal database) for free (you have to pay for the Windows Server Standard license though).

Sharepoint uses Sites, Pages, and Web Parts/Lists/Document Libraries.  Sites cover a department, topic, project, etc and contain pages.  Pages contain web parts, lists, document libraries, etc.  A calendar would be considered a web part.  There are a lot of customizable web parts included (including calendars) and many more for free and for purchase.  If you are good with Access you should pick up Sharepoint pretty quickly.

As Sharepoint is accessed from a browser (usually IE) Macs will mostly be fine; they may experience some minor glitches here and there.  This blog talks about some of the issues/differences you might encounter on a MAC.

http://blogs.msdn.com/b/opal/archive/2010/11/13/sharepoint-2010-on-a-mac-with-office-for-mac-2011.aspx
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Launch app from Access custom ribbon 8 33
Why can't I get rid of record selectors on my form? 9 28
Mysql Left Join Case 10 44
Filter a form 8 12
Any business that wants to seriously grow needs to keep the needs and desires of an international audience of their websites in mind. Making a website friendly to international users isn’t prohibitively expensive and can provide an incredible return…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

813 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

18 Experts available now in Live!

Get 1:1 Help Now