106 posts tagged with access and database.
Displaying 1 through 50 of 106. Subscribe:

Tracking reimbursements for employees

I'm in charge of a tuition reimbursement process in my company-- people give me their approved applications along with their grades and receipts and I calculate the reimbursement and send it along to accounting. Part of this process is keeping tabs on what's being spent on what. Right now, I'm using a massive Excel sheet to do this and it is messy. [more inside]
posted by thefang on Sep 25, 2014 - 3 answers

How do I create a multivalue column from delimited text in Access 2010?

I want to take a comma delimited list of values e.g. "bacon, sausages, eggs" stored as a single text field and store these as selected values in a single multi-value lookup field. [more inside]
posted by tsh on Feb 24, 2014 - 6 answers

Looking to extract more info from this database

We are storing information about application hits in a database. Sadly my database/excel skills are pretty limited and I'd like some help getting more info out of the information we have. [more inside]
posted by Admira on Jul 17, 2013 - 11 answers

MS Access Combo Box Fields behaving strangely.

I'm putting together an Access database (woe is me), which includes some "multiple choice" fields, that contain a defined list of options. I've got some code that puts together a query, and generates a report. The way these fields are displayed in this report is inconsistent, and I'm trying to figure out why. [more inside]
posted by Jimbob on Jun 9, 2013 - 1 answer

Data Driven Clinical Care - Dynamic Graphing Website

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

Advice needed: moving a MS Access DB to the cloud..

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

What sort of database for a non-profit training organisation?

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

Relational database on the cheap

I'm looking for a free/cheap alternative to Access or Filemaker for simple relational database work. [more inside]
posted by philosophygeek on Sep 13, 2012 - 9 answers

Accessible Access Training?

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

Formatting MS Access report with subreports and subforms in pivot views

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

Complicated (or probably not complicated) MS Access question that I'm not sure how to google for. [more inside]
posted by Just this guy, y'know on Feb 20, 2012 - 5 answers

Designing a gradebook database

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

Connect to access with php

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 newbie needs advice!

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

I want to do this the easy way but I don't know how.

How do I efficiently pull this data from an Access 2003 database. [more inside]
posted by VTX on Oct 25, 2011 - 6 answers

Database from Word.doc

How to make a database from word doc? [more inside]
posted by Ideefixe on Sep 7, 2011 - 7 answers

MS Access is making things harder than they need to be

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

Keeping track of payments?

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

Best practice in implementing a two-part unique identifier?

Best way to implement a two-part unique identifier in Access? [more inside]
posted by jsturgill on May 9, 2011 - 14 answers

Database to INI file

How could I export a Access Database to an ini file? [more inside]
posted by millerizer on Mar 31, 2011 - 6 answers

Help me Do it Wrong

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

SQL Query help in Access 2000

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 to get access to ProQuest's Historical St. Louis Post-Dispatch database?

How can I obtain access to ProQuest's Historical St. Louis Post-Dispatch [1874-1922] database? [more inside]
posted by anonymous on Jan 3, 2011 - 7 answers

Microsoft Acess Charts dead-end.

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

Newbie to MS Access deleted something essential. HELP!

[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

A Link to the Reference Table Past

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

Analyzing Surname Data

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

Effing Access combo boxes, how do they work?

I'm trying to make a combo box populate properly in an MS Access form (oh, the pain), and I need some help. [more inside]
posted by middleclasstool on Jul 8, 2010 - 2 answers

Here are some tech questions that I don't really understand

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

Access database design help

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

Access and Replication

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

MS Access data to pretty HTML?

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

Moving the database

How can I move an MS Access file to another PC? [more inside]
posted by MrMulan on Mar 30, 2010 - 3 answers

How can I get a form in an Access database to let me use images in a dropdown as the choices?

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

HTML snippits out of microsoft access

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

Giant but simple database - how to build

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

Unscrewing an Access d/b permissions

How do I regain write permissions for an Access database. [more inside]
posted by diode on Jan 28, 2010 - 6 answers

Databases for collaboration: Is Access the way to go?

Is there an online Access-like database? [more inside]
posted by mateuslee on Jan 14, 2010 - 7 answers

Querying the hive mind...

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 set up a simple database for vocabulary terms?

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?

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

MS Access - Limit to # of shared users

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

Point me to the web...

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

Find me better database software.

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

Serious help needed with Excel

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

Please help me set up some Access forms.

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

Which computer class is right for me?

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

MS Access...Access Problem

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

What is/are Pipeline Reports?

What is/are Pipeline Reports? [more inside]
posted by momzilla on May 28, 2009 - 6 answers

Alternatives to MS Access?

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

Page: 1 2 3