Results 1 to 3 of 3
  1. #1
    abomb987 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    2

    just starting out - need help

    Hi all,

    i am just starting an NVQ and require some info on databases in-order to understand how an access database work and to then create a functional database.

    so if anyone can answer the following i will be ever so thankful

    1. what are the components of database design?

    2. what are "field characteristics"?

    3. what are "field types"?

    thanks in advance for all who help

    P.S.



    yeah i am a total noob with databases.

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Wow...you should get a book or something if you are starting from scratch because it cant be answered in a text...but here's some notes.

    All data is stored in tables
    each table has fields that hold specific data types (characteristics)...integers (for whole numbers), currency, text, single & double for long division fractions, & dates.
    Normalized tables each hold ONLY that thing...(ie. tStates), ONLY holds US State info ...keyed by STcode. A keyed field means it cannot be repeated in the list.

    Once you have all your tables..you build queries to retrieve the info...
    you have a tCustomer tbl, tStates tbl and say tPhones.
    1 customer can have MANY phones.. this is a 1 to many RELATIONSHIP.

    that should get you started.
    Good luck.

  3. #3
    abomb987 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2014
    Posts
    2
    hi thanks for the reply and i have ordered a few book just thought i would ask about this on here as it is one of the first things in the essay i need to write about. ill be going through lots of beginner guides and what not on here and other places of the internet.

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

Similar Threads

  1. trouble starting code
    By mejia.j88 in forum Programming
    Replies: 2
    Last Post: 02-17-2012, 02:08 PM
  2. trouble starting code
    By mejia.j88 in forum Programming
    Replies: 32
    Last Post: 12-15-2011, 11:57 AM
  3. Questions about starting first database
    By JM9x in forum Access
    Replies: 15
    Last Post: 09-10-2011, 04:26 AM
  4. Starting a new database
    By JFo in forum Access
    Replies: 9
    Last Post: 08-25-2011, 11:00 PM
  5. Replies: 9
    Last Post: 04-28-2009, 05:42 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