Results 1 to 2 of 2
  1. #1
    CPR is offline Novice
    Windows 8 Access 2013
    Join Date
    Aug 2015
    Location
    Nature Coast of Florida USA
    Posts
    6

    Basic Concepts of Using Access Parts


    Very basic question. There are Tables and Queries and Reports and VBA and other tools in ACCESS.
    I understand database and relationship design and programming but I'm not sure about the best way to use Forms and Queries when designing a system for users.
    Do you allow the users access only to forms and have the forms call queries and/or Reports?

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    Yes.
    Tables contain data--that's where the data is stored
    Queries are used to select, add, or edit data in tables
    Forms are really "windows" by which the user can interact with the data( using queries, forms and reports) as you said.
    Here is a link to some info that may help put things into context.
    There are some good youtube videos on Access by 599CD and Steve Bishop and others.

    Good luck.

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

Similar Threads

  1. Replies: 5
    Last Post: 06-26-2013, 11:40 AM
  2. Replies: 3
    Last Post: 08-02-2012, 11:37 AM
  3. parts inventory in access 2007
    By eiron in forum Access
    Replies: 1
    Last Post: 07-25-2012, 05:48 AM
  4. Access 2010 Concepts
    By zipmaster07 in forum Access
    Replies: 4
    Last Post: 01-31-2012, 12:51 AM
  5. Prohibiting access to parts of a database?
    By Delta223 in forum Access
    Replies: 1
    Last Post: 01-05-2011, 07:31 AM

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