Std - 8 - Chapter 3

MS Access 2007: Queries, Forms and Reports

1.	When do you use a Form? Form is a graphical representation of a table.  Forms are useful to add, update and delete records in a table.
2.	What is the use of Criteria row in the Query design grid? Criteria row helps to filter the records according to a given criteria.
3.	Name the three views in which a form is displayed. Form View, Layout View and Design View.
4.	How do you adjust the design of your form? By clicking the design button and adjust our form accordingly.
5.	How do you create a form? 1.      Select the table for which you want to create the form 2.      Click the Create tab on the Ribbon 3.      Click Form in the Forms group.
6.	Define a query, form, report. Query: a query displays specific records from a table that meet a certain criteria. Form: A form is a graphical representation of a table. Report: A report is an effective way to present the data in a printed format.
7.	Explain the design grid of the query window. Design grid helps to add fields to the query and also specify the criteria.  Design grid contains a)      Field row: displays the fields from the selected table. b)      Table row: displays the name of the table c)      Sort row: is used to filter the data in ascending or descending order. d)     Show row: displays check mark which indicates that this field will be visible when the query is run. e)      Criteria row: is used to specify the condition on the basis of which the records will be filtered. f)       Or row: is used to specify multiple criteria.
8.	How do you apply multiple criteria to the same table? Explain through an example. You can apply multiple criteria to the same table. If you place two criteria on the same line, Access will only retrieve records where both criteria are met. For example, if you want all records where the State is equal to "DE" and the Last Name is equal to Smith, you would set the State field to = "DE" and the Last Name field to = "Smith" and you would place both criteria on the same line. If you place one set of criteria on the Criteria line and the second set of criteria on the Or line, Access will retrieve records if either criteria are met. For example, you want all records where the State is equal to "DE" or the Last Name is equal to Smith. You would set the State field to = "DE" and the Last Name field to = "Smith" and you would place one set of criteria on the Criteria line and the other set of criteria on the Or line. Access will bring back all records where the state equals DE and all records where the Last Name is equal to Smith no matter what the State is. You can add additional AND, OR statements by using the lines below the Or line. For And clauses, place the criteria on the same line; for Or clauses, place the criteria on separate lines.
9.	Lab Practicals 1.      Page No: 34 (Practical in Computer Lab) 2.      Page No: 37 (Hands-on Activity)

for extra reading
http://www.baycongroup.com/access2007/05_access.html

Std - 8 - Chapter 2

MS Access: Learn to use Access 2007

1.	What is RDBMS? RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables.
2.	What are forms and reports used for? A form is simply a way to enter data into the database and reports are designed to be printed.
3.	Name all the data types available in MS Access. Text Field, Numeric Field, Currency Field, Date/Time Field, Memo Field, Yes/No field.
4.	Name the shortcut key to quit MS Access. Alt + F4
5.	Mention the different ways to create a database. Creating a blank or empty database, Using the database Wizard, and using a template.
6.	What are the manipulation operations that can be done on a table? Add, Update and delete a record are the manipulation operations on a table.
7.	Define the terms: Record, Field, Table, and Query. Record: records describe information sources. Field: are the building blocks of records.  Fields are the sections of a record where information is stored. Table: A table is a collection of data about a specific topic. Query: A query is used to extract information from a database.
8.	Differentiate Datasheet View and Design View Datasheet View displays the view, which allows us to enter raw data into the database.  Design view displays the view, which allows us to enter fields, data types and the description into the database table.
9.	What is a primary key? State its use in a table. The primary key is the unique identifier for each record, such as an employee number or admission number of a student.
10.	Write some advantages of a database. Easy retrieval of data Easy sharing of data Reduced data redundancy Reduced updating errors and increased consistency Greater data integrity Data security Easy manipulation of data etc.
11.	What do you understand by table structure? A table structure identifies the name, size and types of various fields.
12.	What is the use of creating relationships between tables? We can create queries, forms and reports to display information from several tables at once.
13.	Explain the text and numeric field types. Text Field: A text field contains letters, numbers and symbols.  The numbers in a text field are considered as text and cannot be used for calculation. Numeric Field: It contain numbers and does not accept letters or other symbols except numbers.