For handling business card information (Entering New, Editing, Deleting) I am creating small database in Access. 2010
Thinking about tables, fields and relationships (database schema) I am wondering should I create
One or more tables.
Option with several tables:
tblAddress(Adrress_ID, Adress_1, Address_2,City, Province_State, Country,
tblContact(Contact_ID,Business _Phone_Num,Business_Fax_Num, Cell_Phone_Num ,E_mail, Web_Site)
Or should I put all fields in one table?
Is the table structure ok should I add some more fileds(Entry_Date,Last_Time_Updated…?) and what is good approach?