If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How we create Telephone Directory in Access 2007 with sorting ?
Hi , iam a new user access 2007 any body tell me how we create telephone
directory in access 2007 using user picture and sorting form . |
#2
|
|||
|
|||
How we create Telephone Directory in Access 2007 with sorting ?
AAli,
First...that's too "broad" a question for a specific response. Secondly... you shouldn't have to build an application to handle a telephone directory. There are many freeware applications out there that should do that for you... for free. I happened to find this http://www.snapfiles.com/reviews/kurlo/kurlo.html, I have no connection to them, but... try it... it might be just what you need. Often, people post questions about building a "checkbook" application, and the majority of advice is... don't bother... purchase a reliable checkbook program like Quicken or any of the many inexpensive Shareware and Freeware checkbook apps available on the web. ---------------------- OK... say you still want to build a directory app. You should have a clear picture, ahead of time, as to what this directory will/will not do. The first part of any Access application design, is the table/s. Let's drop the "image" requirement for now, and just deal with "data" fields. My suggestions for a "basic" telephone directory... (just a simple example) tblDirectory EmployeeID - Autonumber LastName - Text FirstName - Text MiddleInitial - Text Department - Text Position - Text PhoneNo - Text PhoneExt - Text FaxNo - Text EMail - Text etc... as you decide. Try that first, and when your table/s are set up you can move on to designing forms to allow users to enter and maintain the data. -- hth Al Campagna Microsoft Access MVP http://home.comcast.net/~cccsolutions/index.html "Find a job that you love... and you'll never work a day in your life." "AAli" wrote in message ... Hi , iam a new user access 2007 any body tell me how we create telephone directory in access 2007 using user picture and sorting form . |
#3
|
|||
|
|||
How we create Telephone Directory in Access 2007 with sorting
Al,
Quick comment on the first part of your post. There can be a lot of good reasons for creating an application in Access even though it is available as a (even free) application elsewhere. |
#4
|
|||
|
|||
How we create Telephone Directory in Access 2007 with sorting
Fred,
I agree... I hope I didn't discourage the OP too much. His "telephone directory w/images" made me think the OP was developing this for his workplace. It was in that regard that I proposed he consider "bang for the buck" canned software over costly and lengthy manual development. Heck... I've rebuilt my personal "address book" in every database since Jim Button's PCFile... purely for learning. Fred, your point is well taken. Thanks, Al Campagna "Fred" wrote in message ... Al, Quick comment on the first part of your post. There can be a lot of good reasons for creating an application in Access even though it is available as a (even free) application elsewhere. |
Thread Tools | |
Display Modes | |
|
|