Results 1 to 7 of 7
  1. #1
    mayapredco is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5

    Creating form to enter data regardless of table


    I'm working on a project for a class. The last step is

    " Create a form to enter the Sales Representatives data regardless of which table the information is stored."

    I'm not sure what this means or how to do it. Any ideas?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Neither do I. Why would there be multiple tables storing the same kind of data?

    Provide your db design or the file itself for analysis. Follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    mayapredco is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5

    db

    this is the db file

    Quote Originally Posted by June7 View Post
    Neither do I. Why would there be multiple tables storing the same kind of data?

    Provide your db design or the file itself for analysis. Follow instructions at bottom of my post.
    ACase01a1 - Copy.zip

  4. #4
    RagJose is offline Seasoned user
    Windows XP Access 2002
    Join Date
    Apr 2012
    Location
    Brazil
    Posts
    42
    Some context might help understand the meaning of this last step of your class project. Could you list the preceding steps? Also, please save and reattach your db as ".mdb", as many members, like me, don't have Access 2010 and cannot open .accdb.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Second time today I can say I've seen something I've never seen before:
    Relationships set up between MySys tables. Why are you doing this?

    The project has three tables:

    Sales Rep Data

    Outlet Data

    ACase2Data - has all the fields of the other two tables. Why? This table seems totally unnecessary.

    Seeing this structure does not clarify the assignment instruction.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    mayapredco is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Apr 2012
    Posts
    5
    ACase2 Data was the excel file my teacher provided us with to import into the blank database. The excel document had two separate tables, but when I imported it into access they stayed in one table so I manually separated them into the two different tables, Sales Rep Data and Outlet Data.

    The instructions are:

    Problem: An electronics store wants to keep track of its sales representatives for its various outlets. Construct a database which will meet the following requirements.

    • Create a new database to store an appropriate set of tables related to the electronics store. The fields should be logically named, structured with appropriate field types, attributes and keys. Tables should be appropriately related and relationships built. Follow good database practice and minimize redundant fields and incorporate normal forms.
    • Save the database as ACase01.
    • Import the data as possible into the constructed database.


    Then it has a list of different things to do in access, which I believe I have done all except the one that says


    • Create a form to enter the Sales Representatives data regardless of which table the information is stored.


    If you want some examples of what the other ones are, they are like


    • Create a simple form to enter the demographics of the sales representatives.
      • Save as Sales Rep

    • Create a report listing the sales representative’s identifier and name, outlet quota, YTD sales. Provide the total of the Quota and YTD Sales for each sales representative and for all representatives.
    • Provide the following queries:
      • Display all fields for all the records in the Sales Representative demographic table.
        • Save as Sales Rep List

      • Displays the sales representative located in HME 11.
        • Save as Sales Rep HME 11

      • Displays the sales representative with a Gender of M.
        • Save as Sales Rep Male

      • Display sales representative name/ID, age, and hire date for all sales representatives with a hire date after June 1, 2005.
        • Save as Sales Rep Hire2006

    The guidelines are

    Guidelines

    Be sure that your database objects are:

    • Formatted professionally – fonts, colors, column widths, etc.
    • Fields are named and formatted consistently
    • Correct formulas and functions are used
    • Minimal fields are declared and relationships presented.
    • Intelligent use of the features covered in the first 4 chapters of the textbook
    • Queries and reports are saved as outlined above
    • Reports are prepared for printing with logical headers and/or footers



    Those are really the only instructions she has given us.






    Quote Originally Posted by June7 View Post
    Second time today I can say I've seen something I've never seen before:
    Relationships set up between MySys tables. Why are you doing this?

    The project has three tables:



    Sales Rep Data

    Outlet Data

    ACase2Data - has all the fields of the other two tables. Why? This table seems totally unnecessary.

    Seeing this structure does not clarify the assignment instruction.

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    If I understand correctly that a sales rep can have only one outlet then the tables seem correct to me.

    And you have already built a form to enter sales rep data.

    What you don't have is a table for entering sales data on daily/weekly/monthly basis, if the instructor is looking for that. You have annual quota and YTD fields in the SalesRep table. The YTD value would have to be manually adjusted, not calculated from detail sales records. Maybe that's a level of complexity the instructor didn't feel was necessary for this exercise.

    However, I am still no more enlightened about the task at issue. I suggest you get clarification from instructor.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 4
    Last Post: 02-27-2012, 10:29 AM
  2. Enter Data into a Junction Table
    By darkwan75 in forum Database Design
    Replies: 3
    Last Post: 04-13-2011, 08:55 PM
  3. Using composite keys to enter data in a form
    By kymmyg in forum Database Design
    Replies: 2
    Last Post: 09-08-2010, 01:20 PM
  4. Adding a table cannot enter data
    By tak4 in forum Queries
    Replies: 0
    Last Post: 02-03-2009, 10:04 AM
  5. can't enter data in some form fields
    By ashiers in forum Forms
    Replies: 1
    Last Post: 09-18-2008, 12:37 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