Tables in Microsoft Access (Ch – 9) Solution | Computer Science 7th | ICSE

Ch 9 (Tables in Microsoft Access)

Ex. 4

a.    Text Data Type
This is a genera-purpose
field containing any data. It has a limit of 255 characters.

b.    Memo Data Type
This type has a limit of
63999 characters; used for detailed, descriptive fields.

c.     Lookup Wizard Data Type
This type creates either
a lookup list forms the data that you specify or a lookup list from the values
in another table.

d.    Attachment data Type
This type works only in
Access 2007 and Access 2010 database. You can attach data files form word
processing programs, spreadsheets, graphic editing programs and so on.

Ex. 5

a.    What is the purpose of
Datasheet view?
Datasheet view is useful
when you need to create a table quickly.

b.    Name all the Data types of
MS-Access
Name of Data type in
MS-Access are following:
Text, Memo, Number, Data/time, Currency, Auto Number, Yes/No, OLE object,
Hyperlink, Lookup Wizard, Attachment, Calculated.

c.     Name all the Field properties
of database.
Field properties of
database are following:
Properties Pane, General Tab, Drop-down list, Property Information, Yes/No
properties.

d.    What is the use of default
value in the properties?
By using default value,
we can take same value making that value the default. For example, if 90%
students take Kathak as dance, you can make Kathak the default value in the
Dance field.

e.    Define Primary key.
A primary key is a key
that differentiates the records in a file. The data stored in the key field is
unique to a specific record. A primary key filed cannot be deleted in
MS-Access.

Ex. 6

a.    What is the function of
Design view? Explain.
Through Table Design
View window, you can create whatever fields you like and select the data type
of each field.

b.    What do you mean by Data
type? Name various data types.
Each field has a data
type that defines what you can store in it. Data entry is restricted to valid
entries for the type you choose. For example, you cannot enter letters in a
field set to Number. Name of various data types are Text, Memo, Lookup
Wizard, Number etc.

c.     What do you understand by
field properties? Explain any two of them.
Each field has a set of
properties that defines and controls it. These properties include basics such
as its size and format, as well as rules for entries in it.
General Tab: The general tab contains most of the properties you will
work with.
Lookup Tab: The Lookup tab is primarily used for setting up lookup
lists.

d.    What is a validation rule?
What will happen if we do not follow it while entering data in a table?
A validation rule is
used to limit a field entry to meet certain criteria. By validation Rules, you
can ensure that the correct value is entered in the field. If the user makes an
incorrect entry. Error alerts can stop the user, provide a warning or just
provide information.