I would like advice on creating a dynamic graphing website to display clinical data on a intranet website to better aide clinicians. What my superiors are seeking is a "Data Mall." My programming/server-admin. experience is minimal, but my Linux-hobbyist mentality
hates the MS Access solution that is being built.
[more inside]
posted by rosswald
on Jan 16, 2013 -
4 answers
Our small office uses a MS Access database daily for non profit work. The database is small enough where I'm not certain it warrants upgrading to SQL. Most of the work done in the database is remote (7 users total) so we are looking to move from a standalone PC w/remote access to the cloud.
I would greatly appreciate any advice with regard to moving the DB to a cloud service provider that supports MS Access. One that is reliable, is relatively easy to admin e.g., backups and lastly, inexpensive.
posted by Sagres
on Dec 3, 2012 -
4 answers
I need to organise some kind of database for my non-profit training organisation, to track students, courses taken, etc in Moodle, and possibly to integrate with a Joomla site as well. I've been told that Access will not work for us. Will a Customer Relations Management thing suit us, or is something more required? If so, what should we be looking for? Requirements and constraints inside.
[more inside]
posted by harriet vane
on Sep 18, 2012 -
4 answers
Microsoft Access Training/Classes in New York City (Manhattan), or your best suggestion of online materials.
[more inside]
posted by rosswald
on Jul 20, 2012 -
4 answers
Microsoft Access: Help me streamline (or completely automate) creating weekly reports that include tables and charts. I'm almost there, but I just can't wrangle the formatting. Is it me or is it Access?
[more inside]
posted by GPF
on Mar 17, 2012 -
6 answers
MS Access / relational database question. I'm trying to set up a database for a gradebook for multiple classes, that I can maintain indefinitely. I've got the basics in terms of tables for students, classes, etc. But in my ideal world, I'll be able to do item analysis, too -- like seeing what proportion of students got Question 17 correct on a certain exam, or pulling up the specific items that a student missed on Exam 3. The only way I can think of to get this level of detail is with a junction table that has a separate record matching up each test item with each student for each exam. Of course this will eventually swell into hundreds of thousands of records (students * test items * exams * classes * years). Am I thinking about this correctly? Is there a better way of designing this? Are there any examples you can point me to of databases that accomplish similar things? Thanks!
posted by svenx
on Feb 10, 2012 -
15 answers
How do I connect, dsn-free, to a passworded Access (.mdb) database with php (5.2.4)? Google throws up lots of methods - none seem to work.
posted by monkey closet
on Jan 9, 2012 -
5 answers
MS Access 2010 Help - I need to create something that allows a small group of people to add records and search records within a database and after much googling I'm thoroughly confused.
[more inside]
posted by heavenstobetsy
on Dec 30, 2011 -
5 answers
How do I efficiently pull this data from an Access 2003 database.
[more inside]
posted by VTX
on Oct 25, 2011 -
6 answers
MS Access: I have responsibility for a large database in Access 2007. How can I create a dev copy to experiment with changing forms/layout/queries, etc. which shows record data, but does NOT link to and make changes to data in the tables in the "real" original database? I do not know SQL.
[more inside]
posted by cuddles.mcsnuggy
on Jun 9, 2011 -
4 answers
Need ideas on how to keep track of people making multiple payments for large trips or activities, with the ability to report how much they still owe. Much more detail inside.
[more inside]
posted by kraigory
on May 23, 2011 -
5 answers
Ok, here's a stupid-sounding idea: can someone point me to a guide to how to manipulate an Access database client-side on a web page?
[more inside]
posted by ctmf
on Feb 21, 2011 -
14 answers
I have a MS Access 2000 table with approx 300,000 records. I need help with constructing a query.
[more inside]
posted by selton
on Feb 13, 2011 -
3 answers
How can I obtain access to ProQuest's Historical St. Louis Post-Dispatch [1874-1922] database?
[more inside]
posted by Atreides
on Jan 3, 2011 -
8 answers
Microsoft Access 2007 - how on earth do I cut / copy / export / do
anything with my Pivot Chart, besides print it?
[more inside]
posted by Jimbob
on Nov 23, 2010 -
12 answers
[MSAccess Filter] HELP! I have been thrust into Access with no understanding of how it works beyond a 10-minute "use this" and "do that" session. Now I think I inadvertently deleted a couple of essential "forms." Can I get them back? Or rebuild them? I know the data must still be in there, but I don't know how to display it.
[more inside]
posted by AnOrigamiLife
on Sep 16, 2010 -
7 answers
MS Access question. I have a table of references and a query that returns case numbers. Another table lists the references and case numbers that are linked to each other. I need to find a way to list the references for each case that are NOT linked to that case. Difficulty level inside.
[more inside]
posted by charred husk
on Aug 11, 2010 -
6 answers
I need help visually and clearly showing/analyzing surname data retrieved from 23andme.com's Relative Finder feature.
[more inside]
posted by angelaas525
on Jul 9, 2010 -
4 answers
No one here knows anything about databases or web stores, and our current ones are very bad. Do you know things?
[more inside]
posted by quadrilaterals
on May 21, 2010 -
8 answers
I need to create an Access 2007 database to confirm tuition payments for students and I am not sure how to set up the tables. Details within.
[more inside]
posted by jeather
on May 5, 2010 -
2 answers
Sharing an Access database among several small groups using replication. Doable? Am I on the right track?
[more inside]
posted by Simon Barclay
on May 3, 2010 -
20 answers
Is there something newer/better than XML/XLST Maker that will let me automate putting data from an Access database into a clean HTML page that can be edited?
[more inside]
posted by eleanna
on Apr 6, 2010 -
3 answers
How can I get a form in an Access database (I'd like to make a web app, but my hands are tied and I
must use Access) to let me use images in a dropdown as the choices?
[more inside]
posted by Brian Puccio
on Mar 25, 2010 -
6 answers
Create a table of html snippits in microsoft access from data already in the database.
[more inside]
posted by mtstover
on Mar 15, 2010 -
2 answers
What is best method to create a non-techy local interface for a 40M+ record database that I'd like to host on my web server? I'd like to regularly import new data, crunch it, and export specific CSV reports (which will be much smaller than 40M rows).
[more inside]
posted by mtstover
on Feb 5, 2010 -
2 answers
DatabaseFilter: I know more about Access than the average person, but I'm at the point where I need to know more than what I am finding on the Access db sites and in books. I need a faster and more reliable response than I would get from posting on forums.
[more inside]
posted by sio42
on Jan 11, 2010 -
8 answers
How do I make a database of vocabulary terms and definitions to use for teaching? What software, settings, etc. should I use?
[more inside]
posted by washburn
on Dec 10, 2009 -
6 answers
MSAccessFilter: How do I create a printable report in MS access, with a click-through interface to choose my data?
[more inside]
posted by Seeba
on Dec 3, 2009 -
4 answers
Is there a limit to the # of users who can share a Microsoft Access database across a network?
[more inside]
posted by cg1
on Nov 23, 2009 -
12 answers
Are there any Access-like tools for building data access pages in a web+sql format?
[more inside]
posted by gjc
on Sep 25, 2009 -
3 answers
I have to compile a database for work to track about 300 separate data trends, but Access isn't cutting it. Suggestions for the next step up?
[more inside]
posted by ricochet biscuit
on Aug 19, 2009 -
10 answers
Crazy excel help needed... again. Every month I have a monotonous series of tasks to perform in excel and I have exhausted all of the possibilities I know of to make things easier- more details inside.
[more inside]
posted by TheBones
on Aug 11, 2009 -
17 answers
I have two questions about setting up MS Access forms:
1) Currently, I have a form to enter the volunteer id, shift start time and shift stop time, but the client doesn't want to have to look up the id in a report. Is there a way to create a selection list from the volunteer's names? What other options are there?
2) On the "add/edit a volunteer" form, I'd like to be able to choose tasks from a selection list. The tasks table has id and name. The "tasks of volunteers" join table has volunteer id and task id. How do I set this up? I can't seem to get the right combination of configurations.
[more inside]
posted by philomathoholic
on Aug 5, 2009 -
7 answers
I need the hive's help. Which computer class should I choose: Database Management Systems or Database Management with MS Access?
[more inside]
posted by atm
on Jul 15, 2009 -
15 answers
Microsoft Access question: I have an Access 2007 database hosted on a server. I have 10 staff members who use the database. I can get in the database even if someone else is in it. One of my coworkers cannot. Is this typical?
[more inside]
posted by bibbit
on Jul 14, 2009 -
9 answers
MS Access Alternatives? I have a user that needs to keep data in a relational database, but I'd like to advise her against Access because of it's various limitations. She has no programming knowledge. Any suggestions?
[more inside]
posted by SpecialK
on May 19, 2009 -
13 answers
I'm an adult education teacher computerizing our attendance recording and reporting using MS Access. The reports need to be laid out in a particular way, and I'm not sure how to make that happen. Can you help me?
[more inside]
posted by miraimatt
on May 10, 2009 -
1 answer
I have become comfortable with maintaining an inventory database using MS Access. I want something more powerful now. Where do I go?
[more inside]
posted by wayofthedodo
on Apr 26, 2009 -
19 answers
How to extract data automatically from a group of HTML pages to an Excel file or to a database?
[more inside]
posted by elgilito
on Apr 22, 2009 -
5 answers
