Chapter 4 Working with Tables
Brain Developers
A. Fill in the blanks:
1. In Memo data types, we can store a maximum of 65,536 characters.
2. The AutoNumber generates a sequential number, whenever a new record is added to a table.
3. A field property is an attribute that defines the field’s appearance or behaviour within a database.
4. Tab key is used to move to the next column.
5. Hyperlink stores up to 1 GB of data.
6. The text data types is used to store text.
7. The Primary key is a toggle key.
8. To delete a row, first select the row and then click on delete rows button on the Design tab.
B. State True or False:
1. A table can have only one Primary key. (True)
2. Remove Sort command is located in the Sort & Filter group. (True)
3. Access saves the table automatically after saving it once. (True)
4. The Primary key button is available on the Design tab. (True)
5. Shift + Tab key moves the cursor to the next field. (False)
Correct Answer: Shift + Tab key moves the cursor to the previous field.
6. It is not essential to specify data type for a field name. (False)
Correct Answer: It is essential to specify data type for a field name.
7. A number data type can store only integer values. (False)
Correct Answer: A number data type can store integer values as well as decimal values.
8. OLE data type stores a link to a web page. (False)
Correct Answer: OLE data type is used to embed an object created in another application
C. Application Based Questions:
1. Your teacher has shown you the following table structure:
In your opinion, which column header should be chosen as the Primary key for this table? Please note that the column header ID is inserted by default. Hence, do not include this in your answer.
Answer: Mobile number
2. Apex corporation is designing a database for all its employees. The designers want to store the passport size photograph of each employee linked to their respective names. Can you suggest, which data type should they use?
Answer: OLE object
D. Multiple Choice Questions:
1. Which key moves the cursor to the previous field in Datasheet view?
a) Shift + Tab
b) Shift + F6
c) Ctrl + Tab
Answer: a) Shift + Tab
2. What is the maximum number of characters that can be used to define a field name?
a) 46
b) 62
c) 64
Answer: c) 64
3. What do you call the area, where you can view the record numbers you have entered in a table?
a) Record Bar
b) Record Tab
c) Record Navigation Bar
Answer: c) Record Navigation Bar
4. Which shortcut key combination is used to go to the specific record by using the Current record box?
a) Alt + F6
b) Alt + F5
c) Alt + F4
Answer: b) Alt + F5
5. Which of the key combination is used to save the changes and close the table?
a) Ctrl + W
b) Ctrl + V
c) Ctrl + M
Answer: a) Ctrl + W
6. Which icon indicates the Edit mode in Access?
a) Eraser
b) Pen
c) Pencil
Answer: c) Pencil
E. Answer the following:
1. Define the term Table with respect to Microsoft Access.
Answer: A table is a database object, which is used to store information in an organised manner. It consists of rows and columns with small rectangles called cells, where rows and columns intersect. These records and columns are referred to as records and fields respectively.
2. What do you mean by Data types?
Answer: Data types are used to declare the fields of a table. A data type determines the type of data, a particular field can accept.
3. Explain the use of Primary key in a table.
Answer: Primary key is a standard feature of every database management system. A Primary key is a sort of check on the table that uniquely identifies each record in a table. It doesn’t contain any duplicate data. A table can have only one Primary key. The value in the Primary key field is different for every record and thus helps in uniquely identifying the record.
4. State the difference between OLE and Hyperlink.
Answer:
• OLE: This is used to embed an object created in another application, such as Microsoft Word document, Excel spreadsheet, or PowerPoint presentation into the Access table. Stores up to 2 GB of data.
• Hyperlink: The Hyperlink data type can store links to web pages, web sites, files on an intranet or LAN on your computer. It stores up to 1 GB of data.
5. What do you understand by the term Field Property?
Answer: A Field Property is an attribute that defines the field’s appearance or behaviour within a database.
6. How will you sort the data within a table?
Answer:
• Select the field that has to be sorted.
• Click on the drop-down arrow next to the right of the field.
• Select either Sort Smallest to Largest or Sort Largest to Smallest option from the drop-down list.
• The database will be sorted.
7. Name the views in which a table can be displayed.
Answer: Design view and Datasheet view are the two views in which a table can be displayed.
No comments:
Post a Comment