You can enter data into a Microsoft Excel sheet or run a bit of M code in Microsoft Excel Power Query when you need to create a table.

In Access, you can create forms by using the Form tools found on the Create Tab; in the Form Group, these Form Tools are: Form: Create a Form that allows you to input data into one record at a time.

Make a pivot table using the Explore button Click the Explore button in the lower-right corner of the window to open the Explore pane. Click Pivot Table to see a preview of the table.

Once you decide the default Auto Date table isn’t adequate, you can create one that fulfills your grouping and filtering requirements in Microsoft Power BI.