Question

How can we analayse data imported into a table.​

Answer 1

Answer:

In MS Access a table is named collection of records related to a single entity. Table acts as a place holder for your data it is place where all the data is stored it represents a single entity and stores the attribute of the entity in different fields.

Methods Of Saving A Table In MS Access :

⟹ After you have set all the fields and their properties, it is the time to save your table, To save the table, you can follow any of these commands.

(i) Click on File menu from the keyboard OR

(ii) Press Ctrl+S from the keyboard OR

(iii) Click on the save button on the standard toolbar, when Access displays a dialog box.

(iv) Enter the name of the table in the dialogue box and click OK button.

(v) You will now see the name of the table in the database window, when you press Tables object button.

Answer 2

Select the PivotTable Report option, which imports the tables into Excel and prepares a PivotTable for analyzing the imported tables, and click OK. Once the data is imported, a PivotTable is created using the imported tables.