Results 1 to 4 of 4
  1. #1
    Cuasitos is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    7

    planning a proyect

    hi i want to develope a pos software in acces have the next functions i going to list but i dont know wich order are the best for dont get lost, messy and waste time
    1 form to enter user name and password
    2 form for enter product and price


    3 form with buttoms linked with the product and price
    4 sub form in the last form showing the items i choose from the buttoms
    5 reports of sales
    6 form to crete user name nd password
    in this case wich is the correct order to start first creating all the tables and later all the forms or start in an specific order if is the second one wich order is better to follow

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    My approach is

    1. Plan thoroughly on paper. Ensure normalised.
    2. Create tables and relationships
    3. Create forms adding queries / module procedures where appropriate
    4. Create reports for each form as you make them.

    All developers will stress the importance of step 1 being done before doing anything in Access
    Some developers do step 4 before 3.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Cuasitos is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    7

    than,s

    Quote Originally Posted by ridders52 View Post
    My approach is

    1. Plan thoroughly on paper. Ensure normalised.
    2. Create tables and relationships
    3. Create forms adding queries / module procedures where appropriate
    4. Create reports for each form as you make them.

    All developers will stress the importance of step 1 being done before doing anything in Access
    Some developers do step 4 before 3.
    thats the answer i needit

  4. #4
    orange's Avatar
    orange is online now Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with Colin/ridders52. Plan and model using pencil and paper.
    Identify what must be "outputted" from your application, that will identify most of what has to be stored in the database.
    Mock up some test data and scenarios and test you model (paper based) before getting too deep into physical database.
    Here is info on various aspects of database planning and design.

    Getting tables and relationships designed to support your business is critical to database.
    Good luck with your project.

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

Similar Threads

  1. Database planning
    By dniezby in forum Programming
    Replies: 13
    Last Post: 11-28-2018, 08:42 AM
  2. Planning timeline
    By paultje_bos in forum Queries
    Replies: 5
    Last Post: 09-07-2016, 03:50 AM
  3. Planning Process
    By bleyden in forum Access
    Replies: 2
    Last Post: 08-09-2016, 07:31 PM
  4. Help with Database Planning
    By dgaletar in forum Access
    Replies: 12
    Last Post: 03-21-2014, 10:31 AM
  5. Planning/strategy?
    By Bryan021 in forum Access
    Replies: 4
    Last Post: 04-18-2011, 11:40 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