Hello,
I'm beginner in Access. I started study and try some basic "databases" as database for Library. Now I would like to try prepare some easy CRM database for my small company. I'm solving problem how to grab base concept. I have everything in excel and I understand excel quite good and deep. No I'm finding out that Access has completely different concept. So my easy question is:I've in excel "database" names of companies and some dates about it as address, email etc. Also I have there columns about type of collaboration, types of products which we deal with or other actions. For these columns I'm using only "YES" or "NO". Or some other short list. If I'm preparing new database in Access I started with tables. I don't know if is better to create one table with same columns company data and "YES" and "NO" columns or more tables as company data, types of product, types of collaboration (small table only with two columns and 2 lines "YES" and "NO") etc. and link it by some relation. I mean every column in my excel database should be separated table? Please advise me which way and why should I prefer. In reference to following steps and Access.
Thank you all for advice.