how to build a catalog with pictures

H

Hector

I currently have a catalog with a huge list of people that i need to insert
but i mean it 's huge 800 +, I would like to know if there is a way to do
this in one shot and I would also like to include pictures of them as well.
Kinda like a member catalog with there id's. Please help!
 
S

Sprinks

Hi, Hector. Not knowing what form they're in now, I can't advise you how to
import them into an Access database, or whether you can do it in "one shot"
or not. Please give us some detail as to what form your current data is in.

As for the design of your table, based on what you've told us so far, you'll
want a table called something like People or Members, with a structure
similar to the following:

Members
------------

FieldNam DataType
------------ --------------------------
MemberID AutoNumber (Primary Key)
FirstName Text
LastName Text
Address Text
City Text
State Text
Zip Text
HPhone Text
WPhone Text
Extn Text
Email Text
Photo Hyperlink
BirthDate Time/Date
JoinDate Time/Date

Don't embed the picture in each record, merely a hyperlink to the photo file
stored on disk. See the Northwinds sample database that comes with Access
(Help, Sample Databases from the database window).

Sprinks
 
H

Hector

Hi Sprinks thanks for your quick response, ok here's the deal I'm helping a
friend down in Mexico, she has pictures of members, and she want's to have
their signatures in the data base so they can be compared when they sign for
something. I'm aware that there is software that may do that at this time but
just want to make sure if it's possible through Access....
 
S

Sprinks

Hi, Hector.

Sorry. Don't know whether you can plug-in signature-recognition sw or not.

Good luck.
Sprinks
 
Top