1. How many tables are there in MS Access?
2. Why do we need multiple tables in access?
3. What is the difference between a MS Access table and query?
4. What is the difference between a MS Access table and a report?
Answers
Answer:
i) 2,048 including linked tables and the tables opened internally by Access
ii)Normalization, thus can be defined as the process of decomposing i.e. reducing the data to a set of relations (a single data table reduced to multiple tables with each data table having certain relationship among each other). This is to ensure data integrity as well as eliminate anomalies.
iii)A table is a set of rows that holds data that can be updated and the results are permanent. A query is a “on the fly” results or sub set of data that only exists in memory and is discarded after you use the results
iv)Forms allow you to both add data to tables and view data that already exists. Reports present data from tables and also from queries, which then search for and analyze data within these same tables. ... The data submitted in the form is used in a database query, which draws its data from relevant tables.
plz mark my ans brainliest
Answer:
1. How many tables are there in MS Access
=Those results show that there are 229 tables in the database.
2. Why do we need multiple tables in access?
=Normalization, thus can be defined as the process of decomposing i.e. reducing the data to a set of relations (a single data table reduced to multiple tables with each data table having certain relationship among each other). This is to ensure data integrity as well as eliminate anomalies.
3. What is the difference between a MS Access table and query?
=Here a summary of the differences between queries and tables… Data is not physically stored in a query whereas a table is the physical data archive. Data can be organised and filtered dynamically in a query without the need to re-apply the criteria and sorting