IRIS EDUCATION

Working with Queries, Forms and Reports Exercise Solution A. Tick the correct option – 1. (d) Datasheet View 2. (c) Three 3. (c) Four 4. (b) Datasheet View 5. (d) Filter 6. (b) Create B. Fill in the blanks – 1. Query 2. Form 3. Objects 4. Design 5. Report 6. Result C. State True or False – 1. T 2. F 3. T 4. T 5. F 6. T D. Answer the following questions – 1. What is Query? A query is a method of getting answers to questions on data. It is used to retrieve selective data satisfying specific criteria. 2. Differentiate between Form and Report. Forms allow you to add and update data in a table, one record at a time, while reports are an effective way to present data in printed format. You can customize the appearance of tabular data on a report. 3. How can you specify multiple conditions while designing a query? Specifying the condition in the Criteria row for more than one field will result in a query that will select only those records...

D. Answer the following questions 1. What is database? A database is an organised way of storing information. It helps us to manage and access large amount of information quickly and efficiently. 2. What do you understand by term RDBMS? A DBMS that stores data in the form of tables and enables you to join the tables by creating a link between them is called Relational Database Management System (RDBMS). 3. Explain any two advantages of database. The advantages of database are given below: (i) Facilitates sharing of data – Different users can use the same database to extract data based on their individual needs. (ii) Ensures data security – In a DBMS the database administrator has complete control over the database and ensures that the data is accessible only to authorized people. 4. Define the term ‘tables’. Tables are the building blocks of a database. They store the complete data in a structured manner in the forms of rows and columns. 5. What do you mean by the t...

Exercise A. Tick the correct option -  1. (c) AutoNumber 2. (a) Date/Time 3. (b) Primary Key 4. (d) Primary Key 5. (c) Validation Rule 6. (d) Record B. Fill in the blanks -  1. Datasheet 2. Design 3. Rows, Columns 4. Memo 5. Text 6. Required C. True or False 1. False 2. True 3. True 4. True 5. False 6. True D. Differentiate between – 1. Record and Field The rows in a table are known as records. A record stores complete information about an object or an item. The columns in a table are known as fields or attributes. The fields contain only single type of data. Every field has a data type that determines the type of values that can be stored under it. 2. Number and Auto Number data type The number data type accepts number type data whether it can be an integer or a decimal number. The users have to manually input the data in the fields. While Auto number data types are need not to be entered manually, it automatically increment it value when the records are entered. ...

Working with tables in MS Access Views of a table The tables in MS Access have only two views – Design and Datasheet View. Design View In design view of the table, you can enter the field names, their data types and description. The design view window is divided into two parts – Field grid panes and Field property pane. Field grid pane – It is used for entering field names and their data types. You can also give a description to the fields in this pane. This description column is optional. Filed property pane – This section is used to set properties of the fields in the table. Datasheet View Datasheet view is used to enter data in a table. When you double click the table name in the left hand side pane window, it opens the datasheet view of the table. Switching between views Microsoft Access allows you to switch from one view to another by following options: Option 1 – Click on the View Option in the View Group on the Home Tab to change from one view to ...

Field Data Types The various data types in Microsoft Access are described below in the table: Data Types Description AutoNumber It stores an integer that increments automatically as you add records. Text It is used to store combination of text and numbers that does not require calculations, such as address, mobile number, name, etc. The field of this data can hace a maximum of 255 character. Memo When you have more than 255 characters to enter, then you should use this data types for entering large text. Like detailed description of a student or items or products, etc. Number This data type is used to enter number in the column or fields. Date/Time It stores date and time values. You can display the dates and times in various format. You can change the format from field property menu. Currency This data type stores the currency value. It shows the value in decimal format with $ sign. Yes/No This data type accept only one value Yes/No or Trye/False. ...

Microsoft Access Microsoft Access is data management software. In this software you can store, retrieve and manipulate data. Microsoft Access is similar to excel but the major difference is that in excel all the column heading is dynamic you can make any new column for entering data and in access before entering any data you have to create the column heading along with its data type. Microsoft access is also called database software. Database means to store the data in an organised manner. The database has four components Table, Query, Forms and Reports. All the data in database are stored in tables. Tables in Access A table is a database object, which is used to store data in an organised manner. It consists of rows and columns. A database can have more than one table. Components of table The important components of a table are: 1. Fields or Attribute – The columns in a table are known as fields or attributes. The fields contain only single type of data. Every field ...