# Microsoft Access nerds come on in. **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [July 29, 2009, 6:00am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276 "2009-07-29T06:00:22Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 29, 2009, 6:00am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/1 "2009-07-29T06:00:22Z")
I am trying to create a client database… it needs to have about 100 fields. first name, last name, spouses name, dates of military service, income (in 6 categories), it needs medical expenses in like 10 categories, _they need to subtract from each other_, then i need a place for address, phone number, assets (in 6 categories, then a total), It needs to have a spot for last contact, identifier, and notes… I’m sure that there are more but thats the basic jist of it. How hard would this be to create? I can make this very easily in excel, but its too messy to print and I want it to look like a roll-o-dex… Who is good with access, who’d be willing to help me out a bit when questions come up. I dont feel like spending the time to relearn access. Who would have thought itd come back to haunt me. ---
**Author:** ![JayS](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/jays/32/15375_2.png) [@JayS](https://forums.speedlife.net/u/JayS)\ **Post date:** [July 29, 2009, 6:39am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/2 "2009-07-29T06:39:44Z")
This isn’t something you’re just going to pound out. You need to really think about your data layout and normalization of that data. Some good reading to start: [http://support.microsoft.com/kb/283878](http://support.microsoft.com/kb/283878) ---
**Author:** ![dezod](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/dezod/32/7467_2.png) [@dezod](https://forums.speedlife.net/u/dezod)\ **Post date:** [July 29, 2009, 6:57am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/3 "2009-07-29T06:57:24Z")
It’s been about a good 10 years since I used Access, but it should not be hard. ---
**Author:** ![Mankthetank19](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/mankthetank19/32/5295_2.png) [@Mankthetank19](https://forums.speedlife.net/u/Mankthetank19)\ **Post date:** [July 29, 2009, 7:04am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/4 "2009-07-29T07:04:28Z")
So your trying to have an interface for friendly use is your main concern/idea? It shouldn’t be difficult but it will probably be time consuming to develop it. If this is just a short term idea, I would just use excel. However, once you create a template with the fields within access, the most painful part would be data entry ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 29, 2009, 1:02pm UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/5 "2009-07-29T13:02:52Z")
I just want it to be user friendly and give me a nice :rolodex: style layout for me to get a brief and eventually more detailed overview of my existing clients and prospective clients. ---
**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:** [July 29, 2009, 3:20pm UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/6 "2009-07-29T15:20:40Z")
I deal with building qry and tbls and shit all day I could do it for you its easy from what you want if i had the file could have it dune in like 10 min ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 29, 2009, 3:54pm UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/7 "2009-07-29T15:54:16Z")
What file do you need? How comprehensive and user friendly could you make it? ---
**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:** [July 30, 2009, 8:44am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/8 "2009-07-30T08:44:00Z")
just give me some of the excel file … (justa4door@gmail dot com) I can make it how ever you want it… yes it will be user friendly … depends on the data and shit that i got … access really does all the work i just tell it how to pull the data ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 30, 2009, 9:09am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/9 "2009-07-30T09:09:57Z")
You’d be my hero… I’ll put something together tonight, this will be a huge help. I’ll obviously throw you something for the help too. Thanks. ---
**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:** [July 30, 2009, 9:15am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/10 "2009-07-30T09:15:32Z")
do you have access like if I was to make the whole database for you and sent you it would you be able to open it? ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 30, 2009, 9:17am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/11 "2009-07-30T09:17:21Z")
Yes sir… ---
**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:** [July 30, 2009, 9:22am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/12 "2009-07-30T09:22:38Z")
ok … and its not a big deal … Its something I do all day long at work :gotme: ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 30, 2009, 9:25am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/13 "2009-07-30T09:25:08Z")
Where do you work? whats your job ? I appreciate this so much. ---
**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:** [July 30, 2009, 10:52am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/14 "2009-07-30T10:52:39Z")
You guys should make sure you’re using the same Access… 00/03/07 ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 30, 2009, 11:04am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/15 "2009-07-30T11:04:37Z")
I have 07 on this computer… wouldnt it not matter then? Since I have the most up to date version? ---
**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:** [July 30, 2009, 11:16am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/16 "2009-07-30T11:16:28Z")
I have 03 but was able to pull his 07 files everythign is sent to you \<3 ---
**Author:** ![Willybeen](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/willybeen/32/7351_2.png) [@Willybeen](https://forums.speedlife.net/u/Willybeen)\ **Post date:** [July 30, 2009, 11:18am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/17 "2009-07-30T11:18:52Z")
I replied… \<3 ---
**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:** [August 5, 2009, 7:29am UTC](https://forums.speedlife.net/t/microsoft-access-nerds-come-on-in/71276/18 "2009-08-05T07:29:59Z")
> [@Willybeen](#): > > I have 07 on this computer… wouldnt it not matter then? Since I have the most up to date version? I was worried about you-\> him 07 may have had stuff 03 didnt… but it worked for you guys. Assuming you sent him an excel spreadsheet and he just put it into access 03… your access 07 would be able to open it no problem.