Microsoft Access How To

Does anyone know of the best resource to use to learn how to set up a Microsoft Access database? I currently use an Excel spread sheet for my data, but each spread sheet only last for one week. I would like to change over to a database so I can keep entering data and pull reports from history as needed.

Stacey

Conversation 6 comments

  • anoldamigauser

    Premium Member
    24 May, 2022 - 9:38 am

    <p>Sort of an open ended question, so besides the obvious File/New reference you should probably take a look here:</p><p>https://docs.microsoft.com/en-us/office/client-developer/access/access-home</p><p><br></p><p>It sounds like you could just start with a blank database, then create a table that mirrors your spreadsheet. You could even import all of your weekly spreadsheets if you want the historic data.</p>

  • anoldamigauser

    Premium Member
    24 May, 2022 - 9:40 am

    <p>First link was to developer stuff, here is the desktop reference.</p><p>https://docs.microsoft.com/en-us/office/client-developer/access/desktop-database-reference/</p&gt;

  • anoldamigauser

    Premium Member
    24 May, 2022 - 9:42 am

    <p>Would be great to be able to edit posts. That was developer stuff too. Here is the user help/training:</p><p>https://support.microsoft.com/en-us/access</p&gt;

  • wright_is

    Premium Member
    24 May, 2022 - 9:50 am

    <p>What sort of information are you trying to save? How many rows? Can you not do it with filtering on the Excel table?</p><p><br></p><p>Access is overkill, if you are just adding a date column to an Excel table.</p><p><br></p><p>Have you looked at Airtable? It has apps available for Windows, Mac and mobile platforms, as well as a webapp. It is very good and easy to use. You can set up a simple test for free, to see if it could help you out. It is more flexible and friendly than trying to learn Access, unless you really need the relational features of Access.</p>

Windows Intelligence In Your Inbox

Sign up for our new free newsletter to get three time-saving tips each Friday

"*" indicates required fields

This field is for validation purposes and should be left unchanged.

Thurrott © 2024 Thurrott LLC