Brain Teasers

Section Section Name Answer

E Case Study

A. 1. Mr. Geebal can do so in the following way:

1) Open up the database.

2) Select the field containing the ages of all the robots.

3) Click on “Filter.”

4) Since age is a number field, from the menu, choose Number filters and select Less Than.

5) A box appears asking for a numerical value. Enter 18, since we want robots who are less than 18 years old.

2. The data type most suitable for this situation is Date/ Time.

B. 1. Mel and Conji can create a database in MS Access and use form to keep the record of the attendees of TechFest.

2. They can create a table named TechFest_Attendees which has required columns such as, Sr.No., Name, Address, and Phone_Number.

F Answer in Detail

1. To create a form, the following steps can be followed:

1) Go to the Create tab in the menu.

2) In the Forms ribbon, select the Form Wizard.

3) From the Table dropdown, select the table for which you want to choose information.

4) Select the fields you want and use the arrow to put them in the form.

5) Click on Next.

6) Select the format of the form.

7) Click on Finish.

2. To add rows using a form, the following steps can be followed:

1) Open the form.

2) Go to the Home tab.

3) Click on “New” from the Records ribbon.

4) Enter the information in the form.

5) Click on Save from the Records ribbon.

6) Open the table and click on Refresh All in the Records ribbon.

3. We need to filter data to hide irrelevant information and get only the useful data from the database. The steps for filtering data are as follows:

1) Select the field based on which we want to filter the data.

2) In the Home tab, click on Filter from the Sort & Filter ribbon.

3) A menu opens up for the field, with checkboxes on the different values for the field. Choose the data you want to keep by checking the boxes.

4) Click on OK.

4. Advantages of using Forms are as follows:

● Automation: The data is automatically entered into the database when someone fills in the form.

● Data Consistency: The form can smartly check whether the entered data is valid or not.

● Data Formatting: To maintain uniformity in data, we can give options to the customer using a drop-down menu that contains valid options.

A Answer in Short

1. A form is a database object that can be used to collect and store information.

2. A Form is used to collect information and store it in one place.

3. Custom Filtering is filtering data based on your requirements.

4. Data formatting is a way of maintaining uniformity in data, by providing a dropdown menu of valid options.

5. Data type is the type of data for a column in the table. For example, if a column of a table should contain only numbers (like age, and price), then the data type for that column should be Numbers.

Chapter 6

D Fill Up

E Case Study

In a multi-table query, we should first know what the question is. Once that is clear, we must determine what criteria will answer the question. Then, we must determine the fields from the chosen tables based on the question. Finally, we must identify the tables based on the query.

1. Types of queries in MS Access:

● One-table Query: A one-table query is one of the easiest queries, as we are working on only one table.

● Multi-table Query: A Multi-table Query is a little more tricky than a one-table query as it involves multiple tables.

2. Mel’s Query: Select table1.name, table1.age, table2.blood_type from table1, table2 where table1.age >30 and table1. name=table2.name

3. Geebal’s Query: Select table1.name, table1.entry_time, table2.day from table1, table2 where table1.name IN (’Mel’, ‘Conji’)