WORKING WITH QUERIES
A. Fill in the blanks:
1. Table 2. Criteria 3. Or 4. Sort 5. Design Grid 6. Report
B. State True or False:
1.True 2. False 3.True 4. False 5.True 6. False 7. False 8. True
C. Application Based Questions:
1. In Criteria field of Design grid type <50 in the Marks field. 2. Form
D. Multiple Choice Questions:
1. (b) Update 2. (b) Two 3. (b) Create
4. (a) Selected table 5. (b) Three 6. (a) Primary key
E. Answer the following:
A. A Query is a database object that is used to extract some information from the database.
A. The Query window has two panes: Top and Bottom. The top pane displays the table(s) selected for the query. The bottom pane displays the Design Grid.
A. Criteria is a condition on the basis of which the records are filtered in the Query output.
· Select query
· Update query
· Crosstab query
· Append query.
A. You can add fields to the query by dragging them from the field list to the design grid or by double-clicking on the field.
A. A form is an Access object that allows the user to add and update data in one record at a time in a table. Data can be easily inserted, updated and deleted from a table using a Form. If you change a record in a form, it will be reflected in a table also.