How we create Telephone Directory in Access 2007 with sort..

AAli · External Since: Oct 11, 2009 Posts: 1

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 .

Al Campagna · External Since: Jan 08, 2009 Posts: 27

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" <AAli.TakeThisOut@discussions.microsoft.com> wrote in message
news:4BD3694D-F814-4684-94DB-E497779D02A8@microsoft.com...
> 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 .

Fred · External Since: Jun 26, 2006 Posts: 84

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.

Al Campagna · External Since: Jan 08, 2009 Posts: 27

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" <Fred RemoveThis @discussions.microsoft.com> wrote in message
news:CCB6C9BF-4D8D-48CF-A079-E7028D8B8B0C@microsoft.com...
> 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.
>