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]
A Microsoft Access issue: When I try to add a new variable to a pivot chart, the chart goes to a weird zoomed-in view. In this view, I can't add any new variables, nor see any trends. If I change to a different view, then back to pivot chart, everything appears as it should. [more inside]
Help me help myself- Please recommend books or websites that will help me to better understand SQL. [more inside]
Need help setting up a simple Access database. I'm trying to reconcile a bunch of inventory, which is all recorded in multiple Excel spreadsheets. I want to import all the Excel files into an Access database so I can match them up all at the same time. [more inside]
Complicated (or probably not complicated) MS Access question that I'm not sure how to google for. [more inside]
I'm a low- to medium-grade computer techie. I've recently fallen in love with the remote desktop concept (I've been using TeamViewer). I have my main PC with all my data and the software I use, setup how I like it, and then remote into that from mobile devices, friend's computers, work computers, etc., even my laptop I now prefer to use as a portal into my main PC. [more inside]
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?