Datasheet View It provides a visual way to create a table. It is a simple view which arranges the data in rows and columns and allows to edit the data, but not allows to change the format of the database, other than minor changes (such as insert or delete columns).
Design View It allows you to create or change the table. You can set or change every available properties for each field and can open existing tables in Design View, add, remove or change fields.

Question - 12 : - Write down the steps to insert a new row into the table.

Answer - 12 : -

Insert a Record

Steps to insert a record in a Datasheet View are as follows:

Step 1 When you create a table, a new blank record automatically appears in the second row of the table

If you enter data in the last record, a new blank record will automatically appear at the end of the table.

Step 2 Type data into the fields.

Step 3 When you have finished adding records in the datasheet, save it and close it

Question - 13 : - How can you delete an Access table from a database?

Answer - 13 : -

Steps to delete a table are as follows:

Step 1 Find a table in the All Access Objects list.

Step 2 Right click on a table and select Delete.

Step 3 Now, MS-Access will display the prompt message to confirm that you want to delete the table or not.

Step 4 Click on Yes button to delete a table with its contents.

Question - 14 : - When Memo data type is preferred over Text type for a field?

Answer - 14 : - When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length can not be more than 255 characters so, Memo data type is preferred over Text data type.

Question - 15 : - When is AutoNumber data type preferred over Number data type?

Answer - 15 : - When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.

Question - 16 : - Write one example of data field for which you would set the Required property to Yes?

Answer - 16 : - In a table, when we declare a field as a primary key, then the field’s Required property must be set to Yes because in a primary key field, we need to enter data always.

Question - 17 : - What is the purpose of Default Value field property?

Answer - 17 : - If there is a situation when you want to enter same value for all records. Then, to avoid typing the same thing many times, you can set as a Default Value property.

Question - 18 : - What do you mean by the Entry Required field information?

Answer - 18 : - Entry Required field decides whether entering data in the field is necessary or not. So, if Entry Required is set to Yes, then that field must have some value in it. By default, Entry Required is set to Yes.

Question - 19 : - Give any one difference between freezing a field and hiding a field.

Answer - 19 : - When you freeze a field, then no matter how far you scroll down in a datasheet, you will always see the frozen field. But, when you hide a field, then it means that field is not displayed on the screen.

Question - 20 : - What is database template? Give the description of five templates, used in Microsoft Access

Answer - 20 : -

Template is a complete tracking application with predefined tables, forms, reports, queries, macros and relationships. Each template creates a complete end-to-end solution that you can use either with no modification or customise to suit your business needs.

MS-Access 2007 includes a collection of database templates, which are as follows:

Assets It is used to create an assets database to keep track of assets, including asset details and owners.
Contacts It is used to create a contacts database to manage information about people such as customers, partners etc.
Issues It is used to create an issues database to manage a set of issues or problems. You can assign priority and follow the progress of issues from start to finish.
Events It is used to create an events database for tracking, upcoming meetings, deadlines and other important events.
Marketing projects It is used to create a marketing projects database to track time-sensitive deliverable and vendor status for projects.
Projects It is used to create a projects tracking database to track multiple projects and assign tasks to different people.

Free - Previous Years Question Papers

Chapter 4 Microsoft Access Solutions

Subscribe Now!