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!
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.
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]
Can I get 3G access on a new Macbook Pro? If not, what is the least expensive alternative for my situation? [more inside]
I'm trying to write a SQL query on an 8 year old broken Access database that I didn't build, now on Access 2007. It's fun, I tell you what. I'm having trouble with a left outer join. [more inside]
How do I efficiently pull this data from an Access 2003 database. [more inside]
In Canada, does the Access to Information Act apply to provincial and municipal governments?
Does anyone know of an Android password manager app with online browser access? [more inside]
I want to learn Visual Basic and Microsoft Access. Where do I start, what resources and special tricks can you recommend and how do i learn it quickly and efficiently?
What's the best way to upload an Access DB using PHP and read its contents into MySQL?
I'm trying to merge multiple month's worth of data into one master spreadsheet with a master column on the left, and individual month's counts on the right. My data is laid out as such: [more inside]
How to make a database from word doc? [more inside]
I "don't have permission" to go into the desktop XP folders on my network from my Windows 7 laptop, but the reverse is fine. Help me? [more inside]
I want to turn a short play into a short film. If completed, it'll be a low-budget affair seen at a few festivals and hopefully online; the play was first performed in 1990 and the playwright is still alive. How do I go about getting the rights to film his play, or see if I can even think about affording it?
Can't access my wifi. Both my Dell & iPhone show it's available, & it worked earlier this morning, but now, not only doesn't it default me in, but if I request access it doesn't recognize my PW. This doesn't make sense to me. What are my next steps? Thanks
Last minute (Australia-filter) hopefulness: how can I contact a band and get them to acknowledge a 13 year old fan who is now on crutches and can't be up the front of the mosh pit? [more inside]
How do I access the bottom buttons of the RAW image editor in Photoshop Elements? The window is too wide, and can't be resized to fit my screen in Windows 7. [more inside]
MS Access Database Relationship Help. I am relatively new user of MS Access and need to figure out the ideal or proper relationship between the tables I have created for multiple company's financial statements that will provide the most flexibility when viewing and comparing the financial statements. [more inside]
Which programming languages are best suited to creating a timetabling application? [more inside]
Windows Server 2008: Tech support advice needed! What are the options for helpdesk staff to remotely control client computers? Details inside. [more inside]
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]
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]
I make mailing labels by pulling information about specific real-world locations into small database files. I used to get MS Access-ready DBase files, but now I have to work with CSV files, which don't seem to play well with Access. Please help me get more use out of Access, find out how to convert CSV to DBase or similar file types, or figure out better ways to use Excel. Long version inside. [more inside]
I've never used Access; I'm a SQL snowflake and don't take naturally to its norms. Pretend I'm your technology-challenged elderly relative, and tell me how to set up tables to run queries on survey results. [more inside]
Best way to implement a two-part unique identifier in Access? [more inside]
Is there a digital-media/arts-type place in San Francisco that provides access to computers and digital technology - something like The Edge in Brisbane? [more inside]
How could I export a Access Database to an ini file? [more inside]
Will symantec PC anywhere 12.5 work for me? I want to access my desktop office pc from other locations over wifi. Ideally would be able to access all desktop functionality programs etc. [more inside]
In a few days my uni library is going to cut off my sweet, sweet access to its electronic resources, including full text e-journals and online references like OED. I can get an alumni account for $50 a year, but that only gives me physical borrowing rights, not e-resources. Does anybody offer comprehensive access to full-text online journals to non-students for a fee? I don't have a particular field in mind - I want it all. I'm an Australian in Australia, if it matters.
Pulling data (in label sheet formatting) from Word 2003 to Access 2003. I'm a special snowflake details after the jump... [more inside]
What is the best solution for my problems with allowing users (students) to restrict view permissions of their own content in Drupal? [more inside]
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]
I have a MS Access 2000 table with approx 300,000 records. I need help with constructing a query. [more inside]
I'm going to be requesting my psychiatric records; what should I know beforehand? [more inside]
I need to create a query in Access that shows the percentage of a total. I can't grasp the SQL statement I need. [more inside]
I need to pretty quickly get up to speed on how to integrate an Access database with SharePoint. I know Access well, but I don't know SharePoint at all and don't understand how data connections work. The really fun part: I have Access 2002. [more inside]
How can I obtain access to ProQuest's Historical St. Louis Post-Dispatch [1874-1922] database? [more inside]
How do I append rows to a table in Access from two related tables? [more inside]
I'm having trouble formatting a report in Access that ONLY shows checkboxes that are not checked. I probably need some help on the SQL front. [more inside]
I have a database in Access that is essentially a list of projects and associated tasks. I have a query that lists all projects due in the next 30 days. How can I automatically generate an email from this query? Ideally this would just magically send an email whenever the query is populated with a new project. [more inside]
I'm interested in dishwashing practices in the developing world. If you were one of roughly the half of the people in the world without running water in your home, how might you wash your dishes? What kind of set up would you have? Are sinks common even if you collect water from a public well or water truck? Or would you have a washbasin/plastic tub? On a countertop, table, or floor? Cloth or tarp outside? Would you use non-potable water to do the washing up? Save the graywater for next time or for other cleaning tasks? [more inside]
How can I reformat some rows into columns in Excel? [more inside]
Microsoft Access 2007 - how on earth do I cut / copy / export / do anything with my Pivot Chart, besides print it? [more inside]
Is it possible for someone on foot to walk into Heathrow Airport? I was sure it was, a friend insists it isn't and according to this, the answers are a mixed bag (and four years out of date). Has anyone done this recently or work there and can confirm one way or the other?
Leaving Friday for a monthlong stint out of town; how to maintain access to essential software on a different computer running a different OS? [more inside]
I have a Linksys WRT110 router. Although it has some access controls, I find them difficult to use and counterintuitive, and I say this as someone who has been using computers since the days of the TRS-80. Is there a router out there that will let me limit access times by MAC address of different devices, either by a daily quota or a cutoff time? [more inside]
MS ACCESS question (or maybe not?): I need to enter data from hundreds of marketing-type surveys. Most of the questions are free-form, but lots of people give the same answers. How can I make this easy for myself? [more inside]
I'm an environmental scientist. I just received an email from a group called "Intech Open Access Publisher", referencing one of my papers, and asking me if I'd like to submit a chapter for a book. My first thoughts were "Oh man, I didn't think that paper was that great...". My second thoughts were "Hmm...I bet this is a form email sent out to thousands of researchers based on a keyword search, and it may well be a waste of time to submit an abstract." Has anyone else had experience in this sort of thing? Is it legit?
I've just successfully installed Win7 onto an older but servicable PC in order to use it as a streaming media player in another room. Problem is that although it can see all of the shared files, folders and drives on my main machine it keeps telling me I don't have the correct permissions whenever I click on them - but permissions are set to 'Everyone' and another machine (a netbook) I do the same thing with can see and play everything perfectly... can anyone offer any help or suggestions please, I'm at my wit's end! Thanks in advance!
[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]