- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Any Microsoft Access Experts?
Posted on 1/17/14 at 12:24 pm
Posted on 1/17/14 at 12:24 pm
I've started this topic ~3 times before. Need some help. 
4
Posted on 1/17/14 at 12:25 pm to TheOcean
As amazing as I am in Excel, it just seems funny that I literally have no idea what Access even looks like.
Do I even database, bro?
Do I even database, bro?
Posted on 1/17/14 at 12:26 pm to TheOcean
I worked extensively with it in my last job.
What do you need to know?
What do you need to know?
Posted on 1/17/14 at 12:26 pm to Schmidt
quote:
Do I even database, bro?
I took a class on it years ago but I couldn't tell you a thing about it.
Posted on 1/17/14 at 12:28 pm to MThawg
quote:
I took a class on it years ago but I couldn't tell you a thing about it
It's the Tito of the MS Office Suite
Posted on 1/17/14 at 12:28 pm to MThawg
What is this, 2007?
There was a time when we thought that Access would replace Excel....and then Excel expanded row restrictions.
IMO, nearly anything you want to do in Access and be done in Excel, typically in bad-arse pivot tables.
There was a time when we thought that Access would replace Excel....and then Excel expanded row restrictions.
IMO, nearly anything you want to do in Access and be done in Excel, typically in bad-arse pivot tables.
Posted on 1/17/14 at 12:29 pm to Breesus
I got stuck with a campus job trying to design a database, so I've been teaching myself from scratch. I have the framework built, I'm just missing one very important concept.
Let's say you have the main database with alumni, and then you have 4/5 other tables for competitive teams that represent the university. How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
If that isn't clear I can try to make it clearer
Let's say you have the main database with alumni, and then you have 4/5 other tables for competitive teams that represent the university. How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
If that isn't clear I can try to make it clearer
Posted on 1/17/14 at 12:30 pm to LSUfan20005
quote:
nearly anything you want to do in Access and be done in Excel, typically in bad-arse pivot tables.
That depends on how much data you have
Posted on 1/17/14 at 12:31 pm to TheOcean
like...you want to copy records from table 1 to table 2...or you want to reference the information in table 1 in table 2?
Posted on 1/17/14 at 12:31 pm to TheOcean
quote:
How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
You mean from excel to access or from one database in access to another one?
Posted on 1/17/14 at 12:31 pm to LSUfan20005
I'm fairly fluent in Excel but I sure don't know how I would get it to do the things Access does. Maybe I'm not fluent in Excel
Posted on 1/17/14 at 12:32 pm to TheOcean
quote:
Let's say you have the main database with alumni, and then you have 4/5 other tables for competitive teams that represent the university. How can I automatically transfer the unique alumni ID from the main database to the separate competitive teams tables?
We talking vlookup here?
Posted on 1/17/14 at 12:32 pm to LSUfan20005
quote:
What is this, 2007?
There was a time when we thought that Access would replace Excel....and then Excel expanded row restrictions.
IMO, nearly anything you want to do in Access and be done in Excel, typically in bad-arse pivot tables.
obvious you have no idea what you are talking about
Posted on 1/17/14 at 12:32 pm to Doldil
So the main database will have all of the alumni info tied to the unique ID. I then have completely separate tables for the the competitive teams. The only info I would like to go from the main database to the competitive teams is the unique ID and the first name + last name. That way queries will be easy to run.
Posted on 1/17/14 at 12:33 pm to Schmidt
I have no idea what vlookup is. I'm assuming that's got something to do with a database.
Posted on 1/17/14 at 12:35 pm to TheOcean
vlookup would allow you to populate data in a table based on associations and values in another. Sounds like what you need but not entirely clear
Posted on 1/17/14 at 12:35 pm to TheOcean
quote:
I have no idea what vlookup is. I'm assuming that's got something to do with a database
Vlookups allow you to move data from one place to another using a unique identifier..your Alumni ID in this case.
That's in Excel though, not sure how it works in Access
I could do it in a second in excel if you really need help now
This post was edited on 1/17/14 at 12:36 pm
Posted on 1/17/14 at 12:36 pm to Schmidt
Yeah, excel would be no bueno for this type of stuff.
Posted on 1/17/14 at 12:37 pm to TheOcean
quote:
So the main database will have all of the alumni info tied to the unique ID. I then have completely separate tables for the the competitive teams. The only info I would like to go from the main database to the competitive teams is the unique ID and the first name + last name. That way queries will be easy to run.
Maybe use a query with a join putting the only the data you want as a join between the two
Posted on 1/17/14 at 12:37 pm to Schmidt
quote:
That's in Excel though, not sure how it works in Access
I believe its a query in access
Page 1 of 4
Popular
Back to top
Follow TigerDroppings for LSU Football News