1. Which of the following is not a database object?
Ans-Essay
2. Which of the following is not used while setting relationship between the table?
Ans-answer key
3. What is the general meaning of query?
Ans-Question
4. Query, form and report Wizard option are available on which tab?
Ans-CREATE tab
5. Which view allow the users to change the appearance of a form?
Ans-Form view
B. Fill in the blanks.
1. Parameter is a type of query.
2. The foreign key defines a relationship between the table.
3. Criteria row in the query design grid is used to set the condition.
4. The layout view button is present in the design view.
5. Report database object present data in the format required by a user.
C. Write true and false statements.
1. Columnar is the default layout for a form False.
2. Once a form is created it cannot be edited.false.
3. Query design window is divided into two section False.
4. Access does not save report,form, and queries .false.
5. Parameter is the type of query.true
D. Answer the following questions.
1. What is the utility of relationship feature of MS Access?
Ans-When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set. A relationship can also help prevent missing data, by keeping deleted data from getting out of synch, and this is called referential integrity.
2. What is query in Access question mark describe the use of option available in the query design grid.
Ans- A query can either be a request for data results from your database or for action on the data, or for both. A query can give you an answer to a simple question, perform calculations, combine data from different tables, add, change, or delete data from a database.
3. What do you understand by a form? List of formatting that can be apply to a form.
Ans- You can apply formatting to just about every element of your document, from a single character to entire paragraphs. Body text needs to be readable and easy on the eyes. Headings should be big and bold, and they should also be consistent throughout your document.
4. Explain the term report. Is state any two method to create a report in access.
Ans- You can then save the report and modify it in Layout view or Design view so that it better serves your purposes. In the Navigation Pane, click the table or query on which you want to base the report. On the Create tab, in the Reports group, click Report.
5. How are object like query report and form beneficial in creating and organising a database? Explain
Ans-It helps to remember that they all work with the same data. Every piece of data a query, form, or report uses is stored in one of your database tables. Forms allow you to both add data to tables and view data that already exists.
Sir i have done
ReplyDelete