# Anybody here good at 2007 MS Access? **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [June 1, 2009, 5:51am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573 "2009-06-01T05:51:29Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 1, 2009, 5:51am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/1 "2009-06-01T05:51:29Z")
im building a database for an entire dept here, and i’m rusty. i’ve been wanting to do this for a couple years, and i’m finally getting around to it. i have a 600pg book i used at UB and everything, but it’s still a pita, and i dont have the time or patience to relearn it. at the moment, i’m just making tables, but at some point i need to build the relationships and forms and whatnot. my first question is how to i do a “mail merge” from excel. i see where i can import from excel, but it’s not letting me choose which fields go to which, and it’s just not working, ugh… when it comes time to make the thing presentable and “finalized”, i may assume just pay someone to do it ---
**Author:** ![boxxa](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/boxxa/32/5045_2.png) [@boxxa](https://forums.speedlife.net/u/boxxa)\ **Post date:** [June 1, 2009, 6:08am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/2 "2009-06-01T06:08:39Z")
Ha. I took 3 years of Access for the Business and MIS majors and still hate it esp after having to find a way to make Access handle a 300,000 entry database of images and text. MySQL is your friend if you can build a frontend for it. ---
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 1, 2009, 6:13am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/3 "2009-06-01T06:13:39Z")
lol. i just figured out how to import the files how i want. you can’t “merge” the tables, but you can import the whole sheet, THEN work it the way you want… ---
**Author:** ![BuickGN](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/buickgn/32/7200_2.png) [@BuickGN](https://forums.speedlife.net/u/BuickGN)\ **Post date:** [June 1, 2009, 7:18am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/4 "2009-06-01T07:18:49Z")
lol ---
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 1, 2009, 7:21am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/5 "2009-06-01T07:21:51Z")
ugh ---
**Author:** ![ILC](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilc/32/5337_2.png) [@ILC](https://forums.speedlife.net/u/ILC)\ **Post date:** [June 1, 2009, 7:35am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/6 "2009-06-01T07:35:42Z")
access sucks… My Quality Assurance Database uses Access and it lags like a Mofo ☹ ---
**Author:** ![boxxa](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/boxxa/32/5045_2.png) [@boxxa](https://forums.speedlife.net/u/boxxa)\ **Post date:** [June 1, 2009, 7:37am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/7 "2009-06-01T07:37:21Z")
I love too when people use access and think that becuase teh mdb file is on a shared drive, multiple people can update it at once. Bahahahahha ---
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 1, 2009, 7:39am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/8 "2009-06-01T07:39:54Z")
> [@boxxa](#): > > I love too when people use access and think that becuase teh mdb file is on a shared drive, multiple people can update it at once. Bahahahahha yes, once this is done there will be a learning curve for sure. although, the same applies for the rest of our stuff thats on the common network drive as far as read only etc goes. ---
**Author:** ![Jack](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jack/32/7613_2.png) [@Jack](https://forums.speedlife.net/u/Jack)\ **Post date:** [June 1, 2009, 7:46am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/9 "2009-06-01T07:46:48Z")
> [@ILC](#): > > access sucks… My Quality Assurance Database uses Access and it lags like a Mofo ☹ Make sure the tables have indexes… this is overlooked all the time. > [@boxxa](#): > > I love too when people use access and think that becuase teh mdb file is on a shared drive, multiple people can update it at once. Bahahahahha You can set record based locks on the mdb so that it can be updated by multiple people. If you’re in a CITRIX environment, it is better to use a published application than just a file in a directory. I love access for my quick applications for tedious crap. I’ll throw a bunch of easter eggs in them too… makes it funny when you get a call asking what happens when they click on the Rick Roll button… and you ask them why they would click on something labeled Rick Roll? Unfortunately for them, it was too late. They got rolled. it locks the database… which is why I get the call, and get to harass them. Bill - I’m not sure what you’re actually stuck on right now… so I can’t help. ---
**Author:** ![boxxa](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/boxxa/32/5045_2.png) [@boxxa](https://forums.speedlife.net/u/boxxa)\ **Post date:** [June 1, 2009, 7:48am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/10 "2009-06-01T07:48:22Z")
> [@Jack](#): > > Make sure the tables have indexes… this is overlooked all the time. > > You can set record based locks on the mdb so that it can be updated by multiple people. If you’re in a CITRIX environment, it is better to use a published application than just a file in a directory. > > I love access for my quick applications for tedious crap. > > I’ll throw a bunch of easter eggs in them too… makes it funny when you get a call asking what happens when they click on the Rick Roll button… and you ask them why they would click on something labeled Rick Roll? > > Unfortunately for them, it was too late. They got rolled. it locks the database… which is why I get the call, and get to harass them. > > Bill - I’m not sure what you’re actually stuck on right now… so I can’t help. Coming from the IT pro who can’t build his own PC ---
**Author:** ![turbo\_ls1\_ss](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/turbo_ls1_ss/32/7303_2.png) [@turbo\_ls1\_ss](https://forums.speedlife.net/u/turbo_ls1_ss)\ **Post date:** [June 2, 2009, 12:00pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/11 "2009-06-02T12:00:20Z")
how do i insert a dropdown list for a certain field in every record? thanks ---
**Author:** ![ILC](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilc/32/5337_2.png) [@ILC](https://forums.speedlife.net/u/ILC)\ **Post date:** [June 2, 2009, 12:05pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/12 "2009-06-02T12:05:22Z")
[http://office.microsoft.com/en-us/access/HP052405811033.aspx](http://office.microsoft.com/en-us/access/HP052405811033.aspx) ---
**Author:** ![ILC](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/ilc/32/5337_2.png) [@ILC](https://forums.speedlife.net/u/ILC)\ **Post date:** [June 2, 2009, 12:06pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/13 "2009-06-02T12:06:03Z")
> [@boxxa](#): > > Coming from the IT pro who can’t build his own PC yea… I absolutely hate Access I refuse to even look at the database. I’m really in silent protest until they allow me to make a webclient 🙂 ---
**Author:** ![boxxa](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/boxxa/32/5045_2.png) [@boxxa](https://forums.speedlife.net/u/boxxa)\ **Post date:** [June 2, 2009, 1:10pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/14 "2009-06-02T13:10:49Z")
Access has its cool uses for a one system database where you don’t want to work on the GUI and database aspect. Its simple, easy to build and change forms, etc. It has no use being in any organization or multiuser environment and I am still waiting for someone who can argue otherwise. ---
**Author:** ![Jack](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jack/32/7613_2.png) [@Jack](https://forums.speedlife.net/u/Jack)\ **Post date:** [June 2, 2009, 6:45pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/15 "2009-06-02T18:45:27Z")
> [@boxxa](#): > > Coming from the IT pro who can’t build his own PC Actually… its built and running great… and significantly more complicated than any home PC you’ve ever built 🙂 Did you provide anything good to this thread? Oh yeah, there it is. > [@boxxa](#): > > Access has its cool uses for a one system database where you don’t want to work on the GUI and database aspect. Its simple, easy to build and change forms, etc. > > It has no use being in any organization or multiuser environment and I am still waiting for someone who can argue otherwise. Until you (preferably not) or someone you know (preferrably) can build a database properly, you would never understand when and where Access should be used in place of an app that was strictly in VB or anything else. I have several mdbs out there supporting entire departments with no complaints. They are very easy to maintain, and anyone with 5 minutes of training can manage them for me. Bill - Seems like a list box or a combo box would suit your needs pretty easily. Can you be more specific? ---
**Author:** ![boardjnky4](https://avatars.discourse-cdn.com/v4/letter/b/96bed5/32.png) [@boardjnky4](https://forums.speedlife.net/u/boardjnky4)\ **Post date:** [June 2, 2009, 7:05pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/16 "2009-06-02T19:05:48Z")
lol @ people still coding in VB ---
**Author:** ![boxxa](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/boxxa/32/5045_2.png) [@boxxa](https://forums.speedlife.net/u/boxxa)\ **Post date:** [June 4, 2009, 6:50am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/17 "2009-06-04T06:50:09Z")
> [@boardjnky4](#): > > lol @ people still coding in VB Hahahahaha ---
**Author:** ![jetlounge](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jetlounge/32/4994_2.png) [@jetlounge](https://forums.speedlife.net/u/jetlounge)\ **Post date:** [June 4, 2009, 9:00pm UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/18 "2009-06-04T21:00:20Z")
that’s [vb.net](http://vb.net) , thank you very much. ---
**Author:** ![justa4door](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/justa4door/32/7259_2.png) [@justa4door](https://forums.speedlife.net/u/justa4door)\ **Post date:** [June 5, 2009, 4:20am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/19 "2009-06-05T04:20:30Z")
I can has ues the Access very well ---
**Author:** ![duck](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/duck/32/7183_2.png) [@duck](https://forums.speedlife.net/u/duck)\ **Post date:** [June 5, 2009, 8:44am UTC](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573/20 "2009-06-05T08:44:23Z")
part of my job is building access databases to be used nationwide. It is on the share drive and yes, dozens of people go in at the same time and update it without problems. > [@boxxa](#): > > I love too when people use access and think that becuase teh mdb file is on a shared drive, multiple people can update it at once. Bahahahahha as far as the original post. a mail merge is for exporting a table into forms, letters, or envelopes. If you want to import your excel table into access, then go to the table section of access. right click. choose Import. change file type to Excel. bam. [Next page](https://forums.speedlife.net/t/anybody-here-good-at-2007-ms-access/68573.md?page=2)