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

What is/are Pipeline Reports? [more inside]
posted by momzilla on May 28, 2009 - 6 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

Dirty database needs a good cleaning. But how? [more inside]
posted by greekphilosophy on May 5, 2009 - 14 answers

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

I have been asked to make a proposal to upsize an Access database to allow for a few more concurrent users (currently 10) and ideally improve the overall performance of the system. Am I getting in over my head? [more inside]
posted by cbrody on Mar 10, 2009 - 11 answers

How do I put a wildcard into the truepart of an IIf statement of an MS Access 2003 query criteria? [more inside]
posted by JeremiahBritt on Feb 11, 2009 - 9 answers

I am tasked with preparing a multi-category, filterable timeline as a work project. I think Access is probably the best way to do this, but I need some help with the mechanics, or suggestions on where to find a template. [more inside]
posted by Inkoate on Oct 11, 2008 - 1 answer

I can't believe I don't know how to select many checkboxes in Microsoft Access... [more inside]
posted by Foam Pants on Oct 7, 2008 - 9 answers

How can I merge two different Access databases? [more inside]
posted by nushustu on Aug 19, 2008 - 7 answers

How do I best store information about transactions with contacts and companies in an Access 2003 database? [more inside]
posted by canine epigram on Jul 24, 2008 - 4 answers

Can you recommend a forms based database like Filemaker, MS Access, or OoO Base, but lightweight? [more inside]
posted by Ookseer on Jul 21, 2008 - 3 answers

Access 2003: I have this database that is truly awesome along with some equally awesome queries. Co-workers have recognized this awesomeness and want to start running their own queries but know nothing of Access. Is there a user-friendly option? [more inside]
posted by Smarson on Jul 1, 2008 - 4 answers

What books / reference materials / training resources for Access 2003 can you recommend for a n00b? [more inside]
posted by protorp on May 14, 2008 - 3 answers

How can I mail-merge data from MS Access to Word from two different database tables? [more inside]
posted by ctmf on Mar 5, 2008 - 6 answers

At work, I'm being asked to maintain an older Access 2003 database. The database sits on a network drive, but it requires that network drive to be mapped to Y:/. This is a problem because all of the users have it mapped to different drives. How can I get it to stop referencing a specific drive letter? [more inside]
posted by logic vs love on Mar 3, 2008 - 3 answers

I need to query data from another table that I'm already writing to. [more inside]
posted by chrisfromthelc on Feb 6, 2008 - 6 answers

I want to make a dictionary database of words, where I can query part of speech, spelling patterns, pronunciation patterns, number of syllables, definitions, etc. Is Access best for this? Or are there other smaller, free applications you would suggest? Ideally I would like a lot of control over query output layout. Ease of use is important. (I never felt Access was so user-friendly [maybe that's true of all databases in general], but I'm a whiz at Excel. Unfortunately, using XL as a DB isn't very pretty.)
posted by strangeguitars on Jan 29, 2008 - 4 answers

Help me design a small Access application to run a prize drawing. As I see it, the MC will open the application and click the Draw button, which will select from the available prizes for that month. Once drawn, that prize becomes unavailable. MC will then type in the winner's name and click Save, setting the form ready for the next contestant. Specs and examples follow. [more inside]
posted by kc0dxh on Jan 16, 2008 - 8 answers

Good, inexpensive, (preferably free) online course or certification in MS Access or other database software? [more inside]
posted by shotgunbooty on Dec 6, 2007 - 1 answer

Please help me with a giant SQL-ish mess. I need a better solution than MS Access for dealing with millions of records and building queries. [more inside]
posted by loquax on Nov 19, 2007 - 12 answers

Forgive me for asking such an embarrassingly basic MS Access question. I have two voter lists. Each one has a list of voters, and each voter has a unique identifying number as well as some other fields. There are some voters who appear on both lists (having identical voter numbers on both lists) and some voters who appear on only one. I am only concerned with the voters who appear on both lists: how do I import some fields from one list to the other so that the unique identifying number for each voter is matched by that voter's data from the other list?
posted by Mr. Justice on Sep 9, 2007 - 7 answers

Rather continue to work with Microsoft Access, I'd love to move a few old databases I continue to maintain into a www database app, if one exists. I'd like something that feels Access-like, with the ability to structure queries and forms as Access does. I'd happily accept a script package that I can easily install and maintain on my own web server, or a full service. Is there such an Access corollary, either free or available for purchase?
posted by boombot on Jul 2, 2007 - 10 answers

How do I add a 4,000 name MS Excel file to an existing MS Access database? [more inside]
posted by 2bucksplus on Jul 2, 2007 - 3 answers

Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted by desjardins on Jun 6, 2007 - 5 answers

How can I make Microsoft Access 2002 crank out organized web pages that conform to my design ideas? [more inside]
posted by Servo5678 on May 14, 2007 - 2 answers

MS Access Question: I have two tables in a db file. One has a large list of single cell records and the other, a smaller list of records to be compared against the larger table. The issue is that I would like to use the values in the smaller table as wildcards to return like matches that are like the records in the larger table. Example follows. [more inside]
posted by lampshade on Apr 27, 2007 - 3 answers

Access SQL Query - I have multiple individuals each with an address. I need to make mailing labels, but if two or more people share an address, I would only like one label. [more inside]
posted by odinsdream on Apr 18, 2007 - 9 answers

Microsoft Access. An SQL "GROUP BY" query. How do I generate the mode of the values that it's grouping, when I want averages in other multiple fields? [more inside]
posted by Jimbob on Dec 13, 2006 - 3 answers

Help with MS Access needed please - I'm told it should be a fairly simple query to conduct, but I don't think I'm upto the task solo. Can the hive mind help? [more inside]
posted by dance on Nov 18, 2006 - 12 answers

Need to figure out the best kind of database for a small but growing business. MS Access isn't cutting it anymore. Of course there's [more inside]
posted by TayBridge on Nov 5, 2006 - 32 answers

What is the easiest way to get this data into a MySQL database? [more inside]
posted by rlef98 on Nov 2, 2006 - 19 answers

I've got an interesting question about MS Acess. It involves using lat/long data... Anyone care to help? [more inside]
posted by dance on Nov 2, 2006 - 15 answers

I got the job. Now I need a little help with it. Someone I briefly worked under while at this job has posed a Microsoft Access question to me. I understand a good amount of Access but this was immediately over my head. I told her that I would see what I could find out for her. [more inside]
posted by horseblind on Oct 18, 2006 - 10 answers

How can I increment a value directly using SQL? [more inside]
posted by samstarling on Jul 17, 2006 - 3 answers

OSX Databases: I have just migrated to Mac OSX from MS windows but have left behind several MS Access databases of varying complexity. [more inside]
posted by jonesor on Jul 3, 2006 - 6 answers

Dealing with no-records cases in Access [more inside]
posted by ROU_Xenophobe on Jun 14, 2006 - 6 answers

Infuriating Microsoft Access questionfilter: I have a database that I inherited in which queries are set up to pull records which have dates of birth between certain dates. It works right in one database but is not working right in another, for a very particular reason.. [more inside]
posted by By The Grace of God on May 2, 2006 - 7 answers

How can I print multiple MS Access Snapshot files (.SNP) in Windows 2000/XP at the same time? [more inside]
posted by selfnoise on Apr 26, 2006 - 1 answer

How can I implement bi-directional synchronized table changes in a mySQL database and Microsoft Access? [more inside]
posted by mic stand on Apr 19, 2006 - 6 answers