Results 1 to 4 of 4
  1. #1
    low44 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Toronto, Ontario, Canada
    Posts
    2

    Deciding what Access database option to use for new client

    Hi everyone,



    So I am new to the forum and relatively new to the industry and I am looking forwards to getting involved in this forum over the next few months.
    I have more of a design question. I am deciding between whether or not my client needs an Access 2013 app database or a Access desktop database probably written in Access 2010. The client seems to be inclined more towards the former but I myself am not so sure about this.

    Here is a brief outline of the situation:
    - A couple other people who dont have sharepoint or microsoft access would need to be able to access the database, their skill level when it comes to access is basically non-existant
    - The database would consist of around 5 forms and 5 tables and would need to generate reports and queries such as creating email lists
    - The client does not want to spend too much money, i could see him spending 50-100 a month to be able to have this database online.

    Can any one give me some advice? Am I missing something? Your help would be greatly appreciated.

    Thanks,

    M

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    As I understand it, Access 2013 has more functionality for integrating with SharePoint and deploying web database but it should be able to be used for a desktop version as well. Access 2013 drops some functionality (Collect Data, pivot table/chart, support for dBase tables).

    I have seen web forms/reports and non-web forms/reports built into the same database.

    Multi-user database should be split design.
    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
    low44 is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Jun 2014
    Location
    Toronto, Ontario, Canada
    Posts
    2
    Thank you for your help! Yes the database would be split designed for sure. Do you have any resources for me on developing an access database that runs on sharepoint? I have found that the microsoft resources are all crap.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,902
    Sorry, no. I've never developed web database.
    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. Need help deciding between tables and fields
    By Tar73 in forum Database Design
    Replies: 2
    Last Post: 03-31-2014, 02:03 PM
  2. Help me figure out a client database? Thanks you.
    By KaelAltreul in forum Database Design
    Replies: 1
    Last Post: 02-28-2013, 10:04 PM
  3. Replies: 0
    Last Post: 02-27-2013, 01:06 PM
  4. Replies: 3
    Last Post: 07-20-2011, 01:04 AM
  5. Client Server Database
    By vaikz in forum Database Design
    Replies: 4
    Last Post: 08-02-2010, 04:33 AM

Tags for this Thread

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