Solved Exercise:
Chapter-3
A. Multiple choice questions:
1. ___ is a relational database management system.
a. excel b. word c. power point d. access
Answer: Access
2. ______ is the main part of the database.
a. query b. table c. form d. module
Answer: Table
3. One field is the collection set of_______________.
a. database b. tables c. data items d. forms
Answer: Data items
4. Queries are used for tables to convert____, ____, ____and ____.
a. store, forms, update
b. for delete, create table, update
c. for store, paste, copy
d. copy queries, make modules, create reports
Answer: for delete, create table, update
5. Important setting for a field is called_____________.
a. database b. macro c. data types d. reports
Answer: Data types
6. They are useful because they allow you to look upon on specific records.
a. sorting b. filtering c. macros d. forms
Answer: Filtering
B. Write T for true and F for false statements:
1. Access 2010 is a relational database management system(RDBMS). T
2. The data type is decided before creating a table. T
3. Text consists of digits/numbers, letters or their combination. T
4. A primary key prevents the entry of duplicate data. T
5. Forms is a graphical representation of a table. T
6. Whenever we change any record in form, it will automatically change in table. T
C. Fill in the blanks:
1. ___________ is used for database creation and management.
Answer: MS Access
2. The ___________ limits and describes the kind of information in the field.
Answer: Data types
3. _____________ is used in all numeric programs it automatically give increment to a number.
Answer: Auto number
4. _______________ can also be used in mathematics or scientific functions.
Answer: Currency data types
5. A ___________ is a database object that you define and use to store data update DATA.
Answer: Table
6. The _______________ automatically indexed, which makes information retrieval faster.
Answer: Primary key
D. Match the following:
1. Text a. View only the data you want to see
2. Number b. It is used for links to the WWW or e-mails
3. Memo c. Up to 255 characters.
4. OLE Object d. Long integer, integer single and double bytes.
5. Hyperlink e. Up to 65535 characters.
6. Filters f. For pictures, sound, video, or any other docs.
Answer:
1. c.
2. d.
3. e.
4. f.
5. b.
6. a.
E. Answer the following questions in short:
1. Write the name of components of MS-Access.
Answer:
1. Table
2. Relationship
3. Queries
4. Forms
5. Reports
6. Macros
2. Write data types that used in MS-Access.
Answer:
1. Text
2. Number
3. Date/time
4. Currency
5. Auto number
3. What are the advantages of MS-Access?
Answer:
1. Quick and easy to create database systems.
2. It produces very user friendly applications
3. MS access produces flexible and adaptable database systems.
4. What do you mean by record?
Answer: A Table consists of records and fields. Records is also known as Rows. Every record consist of one or more fields.
5. What is table? Name the different ways to create table.
Answer: A table is a database object that you define and use to store data update DATA.
A Table consists of records and fields. Records are also known as Rows and fields are also known as Columns.
6. What do you mean by form?
Answer: It is a graphical representation of a table.
7. What is report?
Answer: It allows you to print assembled data in a custom layout.
F. Answer the following questions in detail:
1. What are the instructions to design database? Explain it.
Answer: 1. Identify all the fields needed by you to produce the required information.
2. Organize each piece of data into its smallest useful part to make the design perfect.
3. Make group related fields into tables.
4. Determine each table's primary key which will uniquely identified.
5. You will have to include a common field in related tables.
2. Write steps to make table through datasheet view.
Answer:
1. On the create tab, in the tables group, click the table button. A new blank table opens in the object window in datasheet view.
Adding fields by entering data:
Entering data in datasheet view is very similar to entering data in an excel worksheet. The main restriction is that data must be entered in contiguous rows and columns, click on the upper-left corner of the datasheet. The table structure is created while you enter data.
3. How do the table create in design view? Write steps.
Answer:
1. On the create tab, in the table design button. A new, blank table opens in the object window in design view.
2. In the field name column, type a name for the first field. Field names can be up to 64 characters long.
3. In the data type column click the down arrow and select a data type from the list.
4. In description column, type description for the field.
5. Repeat steps 2 through 4 to add additional fields to the table.
4. What are the filters? Write steps to implement it.
Answer: Filter is the concept in MS-Access which allow you to view only the data you want to see. When you want to create a filter, you have to set criteria for the data you want to display.
1. Click the drop-down arrow next to the field you want to filter by.
2. A drop-down menu with a checklist will appear. Only checked items will be included in the filtered results.
3. Click OK. The filter will be applied.
5. What is sorting? How do you implement it on your document?
Answer: The record, as you have seen them so far, are shown in the order that they were first entered into the database.
1. Select a field in the cell you want to sort by.
2. Click the sort & filter group.
3. Sort the field by selecting ascending or descending command.
4. The table will now be sorted by the selected field.
5. To save the new sort, click the save command on the quick access toolbar.
Some other links:
No comments:
Post a Comment