CLASS 8: LESSON 03 LOG on to Access

LESSON 03 LOG on to Access

Section A

A.      Fill in the Blanks

1.       Database

2.       DBMS

3.       Relational

4.       Sorting

5.       Primary

6.       Long Text

7.       Auto Number

8.       Datasheet

9.       Forms

10.   Report

B.      State true/false

1.       T

2.       T

3.       T

4.       F

5.       T

6.       F

7.       F

8.       T

C.      Application based

a.       She should click on table option under the create Menu.

b.      Design View

c.       Primary Key

d.      Answers:

                                                               i.      Auto Number / Text

                                                             ii.      Date/Time

                                                            iii.      Number/ Currency

Section B

A.      Multiple Choice Questions:

1.       A. ACCDB

2.       B.  TWO

3.       A. DBMS

4.       B. LONG TEXT

5.       B. 64

6.       C. PENCIL

7.       C. RIBBON

B.      Answer the following:

1.       Database is a collection of information stored in an organized way. Ex Telephone Directory, Maintaining list of students.

2.       A flat file database stores data in a single table structure where as a relational database uses multiple table structure, cross referencing between tables. tables in both organize records.

3.       Tables are the building blocks of a database. They stores the complete data in structured manner i.e. in the form of rows and columns. Every table has a finite number of records. The elements  are:

a. Fields

b.Records

c. Data

4.       A data type determines what type of data you can enter in a field. For example a field whose data type is number can only store numeric data and does not allow you to enter test data into it. the following list depicts the available data types in ACCESS.

a. Short Text

b.Long Text

c. Number

d.Data/Time

e.Currency

f.  Auto Number

g. Yes/No

h.OLE Objects

i.   Hyperlink

j.  Attachment

k. Calculated

l.   Lookup Wizard

5.       Sorting is a process of arranging items systematically. Steps to sort data items is as follows:

a. Select the field you wish to Sort.

b.Click the drop down arrow.

c. Select SORT A TO Z or Z TO A.

6.       Filter is a useful way to see only the data that you want displayed in Access database.

7.       Short notes

a. This property lets you customize the error messages which appear when you enter a value that violates the validation rule.

b.Caption Property specifies a label for a field to be displayed as a column heading. Whenever a table is displayed in datasheet view.