Keeping your database environment tuned, optimized and high-performance is key to achieving business goals. If your database goes down, so does your business. Percona experts have a long history of helping enterprises ensure their databases are running smoothly.
Course Of The Month
2 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Online Database Applications: choosing one for my client that has these requiremtns
Posted on 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.
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.
[X]
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
2
3 Comments
Active 5 days ago
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
http://sharepoint.microsoft.com/en-us/Pages/default.aspx
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?
Active 5 days ago
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
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article was originally published on Monitis Blog, you can check it
here
.
Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
- Web Development
- Magento
- Server Software
- Analytics
- Monitis
- Networking, *magento2, *Monitoring tool, *pageloader, *Monitoring Software
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
- Software-Other
- Databases
- MySQL Server
- MongoDB
- NoSQL Databases
- Percona, *Monitoring tool
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.
Suggested Courses
Course of the Month2 days, 9 hours left to enroll
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.