Results 1 to 3 of 3

How to set up duplicate fields for one record

  1. #1
    Susan4730 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Jun 2019
    Posts
    1

    Post How to set up duplicate fields for one record

    I'm new to Access. I have taken a beginner online class to learn and I start the intermediate class next week. I work at a small resource center and food pantry. I want to set up a new data base to keep track of donations. I know how to set it up if each person only donated once a year but we have donors that donate multiple times a year. I'm not sure how to set it up to keep track of all the check numbers, dates, amounts and designations for the donation. Any help appreciated.


    Thanks, Susan

  2. #2
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    1,858
    Microsoft has a free charitable contributions template for Access. It's one of the selections on the screen when you start Access.

  3. #3
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    5,713
    did they dive right in to how to make things in Access or did they start with the foundation of normalization and entities/attributes in a relational database? This
    I'm not sure how to set it up to keep track of all the check numbers, dates, amounts and designations for the donation
    suggests they did not teach those concepts. A template will get you going but won't teach you much about the principles at play.
    In fact, knowing M$, they will use things in templates that don't follow those principles - things that you'd be better off avoiding, like multi value fields, table lookup fields and navigation forms - unless you understand the ramifications of those and use them anyway.
    - "doesn't work" is no help. Post err msgs and where.
    - Use code tags for code/sql. Implement changes in copies of your database.
    Sometimes I talk to myself - like when I need expert advice.

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

Similar Threads

  1. Replies: 5
    Last Post: 11-25-2014, 08:15 PM
  2. Replies: 1
    Last Post: 06-18-2014, 04:08 AM
  3. Replies: 3
    Last Post: 03-09-2013, 10:39 AM
  4. Replies: 1
    Last Post: 11-08-2012, 02:55 PM
  5. Replies: 6
    Last Post: 02-21-2012, 03:34 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