Page 29 - ModularV1.1 _c8_flipbook
P. 29
3. The maximum size of the Number data type is 32 bytes. ............................
4. Field name can begin with underscore ( _ ). ............................
C. Fill in the blanks using the words given below.
datasheet, field grid, primary key, navigation
1. ............................ buttons help in navigating through the records.
2. The ............................ view is the default view of the table in MS Access.
3. The ............................ pane is used to define the field names and their data types.
4. A ............................ is a field in a table that uniquely identifies each record in the table.
D. Short answer type questions.
1. What is MS Access?
...........................................................................................................................................................................
2. Explain any three features of MS Access.
...........................................................................................................................................................................
3. Write the names of any three data types of MS Access.
...........................................................................................................................................................................
4. What is primary key?
...........................................................................................................................................................................
E. Long answer type questions.
1. What is the difference between Text and Memo data types?
2. Explain the types of views in a database.
3. What are the rules for writing a field name in a database?
In the lab Subject Enrichment
Create a table using the ‘Design View’.
Roll No. Name Date of Birth Phone No. Place
A001 Manan Gupta 12/09/1987 2354667667 Delhi
A002 Ryansh Sharma 09/05/1986 3435555555 Chhattisgarh
A003 Rahul John 02/05/1990 656554432 Mumbai
• Set Roll No as the primary key.
• Delete the record no. A002.
• Add another record.
1. Explain the concept of different types of keys such as composite keys and foreign keys.
2. Discuss the procedure to apply a primary key on a field. .
Introduction to MS Access 2010 27

