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.