Please answer this 6 questions.
1.How will you add a criterion to a query?
2.Write the steps to save a query?
3.What is the purpose of forms?
4.How can you add a new record using a form?
5.What is the use of reports?
6.Can you add records using report?
Answers
Answer:
1::Open your query in Design view. In the query design grid, click the Criteria row of the field where you want to add the criterion. Add the criteria and press ENTER. You can use several types of criteria like text, dates (read about applying criteria to text and using dates as criteria) and functions.
2::Launch Query Design View. Click Query Design from the Create tab in the Ribbon.
Select the Tables. Select each table that you need in the query and click Add to add it to the query. ...
Add Fields. We are now in Design View. ...
Enter Criteria. ...
Run the Query. ...
The Result.
3::A form is a document with spaces (also named fields or placeholders) in which to write or select, for a series of documents with similar contents. ... Also there are forms for taxes; filling one in is a duty to have determined how much tax one owes, and/or the form is a request for a refund
4::Open the table in Datasheet View or the form in Form View.
On the Home tab, in the Records group, click New, or click New (blank) record, or press Ctrl+Plus Sign (+).
Find the record with an asterisk in the record selector, and enter your new information.
5::
The Purpose of Reports. Reports communicate information which has been compiled as a result of research and analysis of data and of issues. Reports can cover a wide range of topics, but usually focus on transmitting information with a clear purpose, to a specific audience.
6::After you create a report, you can modify it. You can add groups or sorts, add fields, change labels, and perform many other tasks. You can view a report in Report view, Layout view, Design view, and Print Preview.
Answer:
1)Open your query in Design view. In the query design grid, click the Criteria row of the field where you want to add the criterion. Add the criteria and press ENTER. You can use several types of criteria like text, dates (read about applying criteria to text and using dates as criteria) and functions.
2)Step 1
Open Access 2007 and select a database you created earlier. Select the "Office" button and select "Open." Browse your computer and locate the database. Click on the database and click "Open." The database opens.
Step 2
Create a query by using the "Create" tab on the ribbon. Select "Query Design." The Show Table dialog box appears. Click on the table that the query will be applied to. Click "Add." Click "Close."
Step 3
Double-click on the fields you want included in your query. Add criteria you want to include in your query. Type the criteria in the "Criteria" field. Run the query by clicking on the "Run" button. View your query results.
Step 4
Save your query by clicking on the "Save" icon on the Quick Access Toolbar. Give your query a name that identities it. Your query can begin with "Qry_" to indicate that it is a query. Click "OK" once you have named your query. Your named query appears in your query list.
3)A form is a document with spaces (also named fields or placeholders) in which to write or select, for a series of documents with similar contents. ... Also there are forms for taxes; filling one in is a duty to have determined how much tax one owes, and/or the form is a request for a refund.
4) I)Open the table in Datasheet View or the form in Form View.
ii)On the Home tab, in the Records group, click New, or click New (blank) record, or press Ctrl+Plus Sign (+).
iii)Find the record with an asterisk in the record selector, and enter your new information.
iv)Click or otherwise place the focus on the first field that you want to use, and then enter your data.
v)To move to the next field in the same row, press TAB, use the Right or Left arrow keys, or click the cell in the next field.
vi)In a table, to move to the next cell in a column, use the Up or Down arrow keys, or click the cell you want.
vii)When you view another record or close the table or form, Access saves the new record that you added. To explicitly save changes to the current record, press Shift+Enter.
5) Reports communicate information which has been compiled as a result of research and analysis of data and of issues. Reports can cover a wide range of topics, but usually focus on transmitting information with a clear purpose, to a specific audience.
6) After you create a report, you can modify it. You can add groups or sorts, add fields, change labels, and perform many other tasks. You can view a report in Report view, Layout view, Design view, and Print Preview.