Results 1 to 5 of 5

I am new to access i need alot of help

  1. #1
    sf49ers164480 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    6

    I am new to access i need alot of help

    I want to create a nfl football schedules. I do not have file yet

    Thanks You

  2. #2
    kd2017 is online now Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    443
    The more specifics you can provide the more help you'll get. Based on what little you've told us you're probably looking at just two tables, one to hold a record for each team, and another table with two foreign keys both linked to the single teams table for each game in the season.

  3. #3
    sf49ers164480 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    6
    I not sure what you table I am new to ms access

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,441
    Quote Originally Posted by sf49ers164480 View Post
    I not sure what you table I am new to ms access
    If that means you don't know what a table is, then I'd say you've come to the wrong place. Mostly we help people solve problems but that means they already know something. Maybe an analogy would be that you are asking for lessons on how to drive but you've never seen a car. If that's the case, you need a lot of tutorial type assistance/information and that's not likely to happen here. Here's a few links to get you started

    Normalization Parts I, II, III, IV, and V
    http://rogersaccessblog.blogspot.com...on-part-i.html
    and/or
    http://holowczak.com/database-normalization/

    Entity-Relationship Diagramming: Part I, II, III and IV
    http://rogersaccessblog.blogspot.ca/...ng-part-i.html

    How do I Create an Application in Microsoft Access?
    http://rogersaccessblog.blogspot.ca/...cation-in.html

    Important for success:
    Naming conventions - http://access.mvps.org/access/general/gen0012.htm
    https://www.access-programmers.co.uk...d.php?t=225837

    What not to use in names - http://allenbrowne.com/AppIssueBadWord.html
    About Auto Numbers
    - http://www.utteraccess.com/wiki/Autonumbers
    - http://access.mvps.org/access/general/gen0025.htm

    The evils of lookup fields - http://access.mvps.org/access/lookupfields.htm
    Table and PK design tips - http://www.fmsinc.com/free/newtips/primarykey.asp
    About calculated table fields - http://allenbrowne.com/casu-14.html
    About Multi Value Fields -http://www.mendipdatasystems.co.uk/multivalued-fields/4594468763
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.

  5. #5
    sf49ers164480 is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2019
    Posts
    6
    I need more help. I create acesss a table and form. I want somewhat copy of excel. read TXT file first.

    Get file from link below

    https://1drv.ms/u/s!AnJwxxiz0Ezpg8of...PRGcw?e=AOiHoF

    Thanks You
    Thomas

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

Similar Threads

  1. Importing alot of Excel Workbooks at once
    By gbmarlysis in forum Access
    Replies: 5
    Last Post: 07-02-2015, 05:28 AM
  2. first attempt to build a database but need alot of help !
    By komet122 in forum Database Design
    Replies: 3
    Last Post: 03-07-2013, 12:09 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
  •  
Tech Forums: Microsoft Office Forums