The most prestigious law school admissions discussion board in the world.
|
 |
 
|
DrakeMallard, had a chance to do any MS Access stuff?
Poast new message in this thread
Date: October 29th, 2019 6:11 AM Author: Brass Private Investor Gunner Let me know if/how that is coming along. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39040932) |
Date: October 30th, 2019 2:00 AM Author: Brass Private Investor Gunner (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39045717) |
|
Date: October 30th, 2019 2:12 AM Author: insane turquoise therapy Why not just learn postgresql (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39045758) |
 |
Date: October 30th, 2019 2:21 AM Author: Brass Private Investor Gunner Total waste of time. You have to do these weird command line things just to set up a database. Access does all that for you.
Why learn things when you don't have to? |
|
Date: October 30th, 2019 2:31 AM Author: ebony razzmatazz organic girlfriend casino (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39045805) |
|
Date: November 15th, 2019 6:55 AM Author: Brass Private Investor Gunner (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39121374) |
|
Date: November 15th, 2019 8:04 AM Author: tripping stock car trump supporter there's almost no chance you need a database to solve your problem, let alone one that was already shitty and obsolete in the 90's. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39121495) |
|
Date: November 15th, 2019 9:06 AM Author: Brass Private Investor Gunner Probably 80 percent plus of what people are doing in Excel needs to be done with a relational database, and Access is the only one with a GUI that most people have available. And open-source ButtPlugSQL is not going to cut it either. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39121691) |
|
Date: November 15th, 2019 3:06 PM Author: tripping stock car trump supporter ExcelDNA. It’s fucking easy to use both a real database and excel’s GUI. But again, I really doubt anything that a dumbfuck like yourself is doing requires or even benefits from a database. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39123794) |
|
Date: November 15th, 2019 7:02 PM Author: Brass Private Investor Gunner Access bad. Great argument. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39124892) |
|
Date: November 15th, 2019 8:21 PM Author: tripping stock car trump supporter Literally the one post I never even mentioned Access in. This helps explain why you think Access is a good idea, though. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39125307) |
|
Date: November 15th, 2019 10:09 PM Author: Brass Private Investor Gunner Like I said, Access bad. Way to go. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39125746) |
|
Date: November 15th, 2019 11:12 PM Author: tripping stock car trump supporter You know what dumbfuck, go for it. Update us on your ‘progress’. I’m sure it’ll go better than all those times you tried to learn to code (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39125971) |
|
Date: November 15th, 2019 11:24 PM Author: Brass Private Investor Gunner I never tried to learn to code. And with Access, I never have to. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39126035) |
|
Date: November 15th, 2019 8:06 AM Author: avocado federal voyeur (xo 201 (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39121499) |
|
Date: November 15th, 2019 9:08 AM Author: Brass Private Investor Gunner MS Access is awesome. I draw strength from the fedora crowd's hatred of it.
There's precisely ONE video on all of YouTube, with its trillions of videos, talking about MS Access as a career booster. And it's some startup dork who complains about it not being a relational database (hint: it is). Unfuckingbelievable. The neckbeard crowd has really destroyed tech. |
|
Date: November 15th, 2019 10:14 AM Author: avocado federal voyeur Agreed that many companies and people would be better off if they knew how to use Access. So many people use Excel for things it's not meant for that Access would be a better option. And if you know Access, jumping up to SQL Server or equivalent isn't hard. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39122092) |
|
Date: November 15th, 2019 5:00 PM Author: tripping stock car trump supporter Close to half of my work is done in Excel and/or C#. I’m not some Clojure loving jerkoff. But Access is a terrible decision for any problem in 2019 (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39124368) |
|
Date: November 15th, 2019 9:33 AM Author: vermilion razzle-dazzle laser beams (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39121820) |
|
Date: November 15th, 2019 10:16 AM Author: charismatic henna round eye Big Excel user here, the gap between the usability of Excel and Access is huge. I realize that half of what I am doing should be done in Access or R, but fuck learning those things. (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39122103) |
|
Date: November 15th, 2019 10:29 AM Author: Brass Private Investor Gunner Nah I hear you - the user-friendliness of Access is poor.
Access consists of:
Tables, which store raw uncalculated data.
Queries, which manipulate and calculate one or more table(s). These are not directly editable like tables are. Basically they store commands for working with tables' data.
and Reports, which display the results of queries, and/or tables, in a non-table format. You can put the results of different tables and queries together, highlight stuff, format to show new pages, etc. Access' report making function is top of the line.
If it helps any, what people are often doing with pivot tables in Excel would qualify as reports in Access.
So the key thing is to "normalize" your data and get it into tables. Tables should store raw data, not calculated data like totals, averages, etc. That is what queries and reports are for. So if you want to move an Excel spreadsheet into Access directly as a data table (which can be done) you don't want it to take on the totals, averages, etc., you want that done by a separate query.
Tables and queries have to show data in a normalized format, meaning the same type of data shows up in each row within a column, all the way down, forever. And each table and each query handles one "thing" so you would want different tables to handle different "things" and then connect to each other in other queries.
But yeah - it's hard to get this presented in a more hand-holding way. Not being insulting. |
|
Date: November 15th, 2019 10:31 AM Author: Histrionic mental disorder party of the first part I have this as my holiday slow time task
right now I'm using pivot tables for a bunch of shit in multiple excel files
So yeah this sounds interesting its just I havent had a chance |
|
Date: November 15th, 2019 7:04 PM Author: Soul-stirring Genital Piercing Trust Fund coughMYSQLcough (http://www.autoadmit.com/thread.php?thread_id=4372143&forum_id=2#39124900) |