Question

Q.1- What is the relationship in MS Access? Explain the process of building
relationships in MS Access.
Q.2- Write the difference between the query and the filter,
Q.3- What is a query? Explain the process of saving the run to query.
Q.4. Explain select and find duplicate record queries,
Q.5-Explain the validation rules and field properties of table.
1.6- How to add hcader and footer to the form?​

Answer 1

Answer:

Access relationships Explained

A relationship in Access helps you combine data from two different tables. Each relationship consists of fields in two tables with corresponding data. ... When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set.