Answer the following 1. Define custom filtering. Give one example of custom filtering. 2. Define query. Why do we need a query in MS Access 2010? 3. Why do we use forms in MS Access? 4. Name the two views of Form Design window. 5. Give any one use of the report feature of MS Access.
Answers
Answer:
One of the most common uses of a Custom Filter is screening transactions for fraudulent use of credit card account numbers. ... Use Custom Filters and the Product Watch List to hold certain products (such as computers or televisions) when a large number are found in a single order.
A query is one of the most important features that MS Access provides. Using a query, you can search or compile data from one or more tables in a database giving specific search conditions so that you can be able to view the exact data that you want. You can
A form is a database object that you can use to enter, edit, or display data from a table or a query. You can use forms to control access to data, such as which fields of data are displayed. For example, certain users may not need to see all of the fields in a table. then review, add, change or delete data from your database.
Layout view and Design view are the two views in which you can make design changes to forms.
report is a database object that comes in handy when you want to present the information in your database for any of the following uses:
Display or distribute a summary of data.
Archive snapshots of the data.
Provide details about individual records.
Create labels.