Results 1 to 3 of 3
  1. #1
    Vrbic00 is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Jul 2016
    Posts
    28

    Basic concept of database

    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.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I suggest you find some tutorials on Database concepts and Access. Access/database is quite different than spreadsheet/Excel as you are finding.
    Here is a series of videos by 599CD Richard Rost that should help.
    Other tutorial that may help you are:

    Database videos by Dr. Daniel Soper
    RogersAccessLibrary has a lot of info and some example tutorials that you can work through to get some experience with table design, relationships and normalization.

    Good luck.

  3. #3
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    377
    To get you started...

    Jeff Conrad's resources page...
    http://www.accessmvp.com/JConrad/acc...resources.html

    The Access Web resources page...
    http://www.mvps.org/access/resources/index.html

    A free tutorial written by Crystal (MS Access MVP)...
    http://allenbrowne.com/casu-22.html

    MVP Allen Browne's tutorials...
    http://allenbrowne.com/links.html#Tutorials

    UtterAccess Newcomer's Reading List
    http://www.utteraccess.com/forum/New...-t1998783.html
    Help with Normalization
    http://www.access-programmers.co.uk/...57&postcount=2

    Sample data models...
    http://www.databasedev.co.uk/table-of-contents.html
    http://www.databaseanswers.org/data_models/

    Naming Conventions…
    http://www.access-diva.com/d1.html

    Other helpful tips…

    Setting up a Model Database
    http://www.access-diva.com/d11.html

    My Database Standards...
    http://regina-whipp.com/blog/?p=102

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Basic Database Design - Confirming my Learning
    By robbeh in forum Database Design
    Replies: 2
    Last Post: 01-02-2015, 02:26 PM
  2. The concept of updating a database
    By hect1c in forum Import/Export Data
    Replies: 3
    Last Post: 11-16-2014, 08:45 PM
  3. Help With VERY basic Database
    By Burky in forum Access
    Replies: 2
    Last Post: 09-16-2013, 08:33 PM
  4. Replies: 1
    Last Post: 04-29-2013, 05:46 AM
  5. A basic question about database design
    By guitarbinge in forum Access
    Replies: 2
    Last Post: 11-05-2010, 03:29 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums