A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How we create Telephone Directory in Access 2007 with sorting ?



 
 
Thread Tools Display Modes
  #1  
Old October 11th, 2009, 02:00 PM posted to microsoft.public.access.gettingstarted
aali
external usenet poster
 
Posts: 2
Default 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  
Old October 11th, 2009, 05:07 PM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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  
Old October 16th, 2009, 03:19 PM posted to microsoft.public.access.gettingstarted
Fred
external usenet poster
 
Posts: 1,451
Default 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  
Old October 17th, 2009, 12:40 AM posted to microsoft.public.access.gettingstarted
Al Campagna[_2_]
external usenet poster
 
Posts: 1,462
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:02 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.