Primary Key Fields.

Q4.

  1.  Name two possible primary key fields for an Employee table.
  2. How do the Text and Memo field types differ from each other? Explain with the help of an example.

Ans 1. Employee_ID and Employee_PAN_Number are two possible primary key fields for an Employee table.

Ans 2.  The Text data type field allows the user to enter textual data of a specified length. On the other hand, the Memo data type allows the user to store large textual data up to 2 GB. For example, in the Product table, the product name can be stored in the field with the Text data type, but the product description information cannot be stored in the field with the Text data type. To store such type of information, the Memo data type is used.

Memo data type and Text data type.

Q3.

  1. What happens when you enter numbers in a Text data type field?
  2.  When is the Memo data type preferred over the Text data type for a field?

Ans 1. Numbers are accepted, but these numbers are treated as text values.

Ans 2. The Memo data type is usually preferred over the Text data type when a user needs to enter large textual data in a field. The Memo data type allows the user to store textual data up to 2 GB.

Properties in MS Access.

Q1.

  1. What is the field size property of an AutoNumber datatypes in MS Access?
  2. Give the difference between MEMO and TEXT type field used in MS Access.
  3.  What is the caption property for a field in MS Access? What caption is assigned by default?
  4.  Explain the validation text and validation rule properties for a text type field.
  5. Name two data types in which field property allow zero length is available in MS Access.

Ans 1.The field size property of an auto number datatype is 4 bytes.

Ans 2.MEMO type field is used to contain long blocks of text whereas TEXT type field is used to contain short text.

Ans 3. The Caption property can be defined as a string to declare a name for a field. The default caption for the field is FieldName.

Ans 4. The validation TEXT property is used to require specific values whereas validation Rule property used to alert user for a mistake.

Ans 5. The field property ALLOW ZERO LENGTH is available in MS Access for text and memo datatype.

Data Validation.

Q8. What do you understand by data validation?
Ans.
In a database, data validation plays an important role while entering data in tables. Data validation is a process of ensuring that only valid data is entered in a table. In data validation, certain conditions are set that a user needs to meet to enter data in a table.

Components of the user interface of BASE.

Q3. Define the various components of the user interface of BASE.
Ans.
The various components of the user interface of BASE can be defined as follows:

  1. Title Bar: Display the title of the BASE document. The Title bar is located at the top center of the BASE window.
  2. Menu Bar: Contains various menus such as File, Edit, View, Insert, Tools, Window and Help. The Menu bar is located below the Title bar.
  3. Tool Bar: Contain various tools for performing standard tasks such as creating a new database, opening an existing database, saving a database. The toolbar is located below the menu bar.
  4. Database Object Buttons: Allow us to create various objects of the database such as tables, queries, forms and reports. These buttons are located in the left pane of the BASE window. Read More …