CHAPTER 4 ACCESS: FROM QUERIES TO REPORTS

-
          
 CHAPTER 4 ACCESS: FROM QUERIES TO REPORTS  

A. Tick the correct option.
  1. Query, form and report are available under __________ tab.           Answer:  c. Create

  2. __________ view allows the users to change the look of the form.   Answer: a. Design

  3. Which of the following is not accessible within the query box?   Answer: c. Custom

  4. Which of the following is not a database object?                                Answer: c. Story

  5. Which tab holds all the format settings of the report?                       Answer: c. Design

B. Fill in the blanks:-

  1. Report option is used to display the data in the desired printed format.

  2. Form allows you to edit and manipulate data in the table.

  3. Criteria in query use two operators: AND and OR.

  4. A Query can only be based on the table.

  5. When a form is created, the Format tab gets activated automatically.

C. State True or False
     
  1. You cannot edit a query. False

  2. A form can be based on a query. True

  3. The Create tab holds all the format settings of a form. False

  4. You are not required to include fields in the query window. False

  5. You can create a query solely based on a table. True

D. Match the following:-
     
  1. Form - c. It allows you to edit, format and check the data of a table.

  2. Query - e. The data that is retrieved from a table.

  3. AND - d. This operator allows you to check for all the conditions given in the query.

  4. Sort - b. It arranges the output of the query in ascending or descending order.

  5. Report - a. It displays the data in the printable format.

E. Answer the following questions:-

  1. Define a query.  ANS- A query is a database element used to retrieve data from one or more tables based on specific criteria.

  2. What are the components of a query? ANS- The main components of a query include tables (data sources), selected fields, criteria for filtering, and sorting orders.

  3. What is the usage of the Format tab in Access? ANS- The Format tab allows user the modification of the visual appearance of elements within a form or report, including changes to font styles, colors, text alignment, and background colors.

  4. Write two ways to format a form in Access.

  • The Format tab provides tools to change fonts, colors, and styles.

  • Design View or Layout View enables the resizing of controls, the movement of fields and the adjustment of the overall layout.

5.      Name the layouts available in Access for forms and queries. 

  ANS- Columnar, Tabular, datasheet, justified.

6.      Describe a query and provide the steps to create one. 

ANS- A query is a method for extracting specific data from a database.

·         Select the Create tab.

·         Click Query Design.

·         Add the desired table and drag fields into the grid.

·         Enter conditions in the Criteria row and select Run.

7.      What is the difference between AND and OR operators in Access?

·      The AND operator requires all specified criteria to be true for a record to be displayed.

·         The OR operator requires only one of the specified criteria to be true for a record to be displayed.

8.      Write the steps to create a query in Access with multiple criteria.

  1.        Open Query Design and add the target table.
  2.         Add the required fields to the grid.
  3.         For AND logic, enter all conditions in the same Criteria row.
  4.        For OR logic, enter conditions in the "or" row situated below the first Criteria row.
  5.       Click Run.

9.      What is a form? Write the steps to create a form using the Form command. 

ANS- A form is a database element that allow user to edit, delete, view and input data in a table.

steps to create a form using the Form command. 

i.       Select the table in the Navigation Pane and it will open in Datasheet view.     

ii. Click on the form option located in the forms group under the create tab. 

iii. A form will appear in the layout view displaying all the fields in the table.

10.  Write the usage of report and steps to create one. 

ANS- A report is used to present data in an organized, professional and printable format.

i) In the navigation pane, select the table or query for the report.

ii) Click the Create tab.

iii) Click on the report button in the report group.

      



Comments

Post a Comment

Popular posts from this blog

TYPES OF HARDWARE CLASS IX

-
                 Types of Hardware (chap-2) 1. Hardware- Hardware refers to physical parts of the computer that can be touched physically. For example monitor, keyboard, hard drive etc. 2. Classification of Hardware-      1. CPU (Central Processing Unit)      2. Memory- A. Primary Memory (Internal Memory)         a. ROM (Read Only Memory)          b. RAM (Random Access Memory      3. Secondary Memory (Auxiliary Memory)          All Storage devices like hard disk, CD, DVD, pen drive etc.      4. Input Devices and  Output Devices 3. Memory in a Computer System- a. Main Memory or primary memory or internal memory- The memory that holds data and instructions during processing. It is temporary memory. b. Auxiliary or secondary or external memory- The memory that can store data or files for later use i.e. permanentl...
Read more

CLASS X SYLLABUS 2026-27

-
Image
Computer_Applications_SecP1X_2026-27.pdf   https://cbseacademic.nic.in/web_material/CurriculumMain27/SecPart1/Computer_Applications_SecP1X_2026-27.pdf CHAPTER 1                                     INTERNET BASICS      Internet - Internet is a global network of computer networks that enables information to be exchanged. In internet, most computers are not connected directly to the internet. Rather they are connected to smaller networks, which in turn are connected through gateways to the internet backbone. Internet is not governed by any particular body. It is coordinated by many volunteer organizations.   Advantages of Internet-  • Greater access to information reduces research times.  • Useful communication links  • Global reach enables one to connect to anyone on the internet.  • Easy communication with other people.  • Publishing documents on the...
Read more

Computer Applications Class IX Types of Software (Chap 3)

-
Image
  HARDWARE- Hardware represents the physical and tangible components of the computer i.e. the components that can be seen and touched. Input devices, output devices, CPU, floppy disk, hard disk, CD, DVD etc. are examples of computer hardware.  ● SOFTWARE- software represents the set of programs that govern the operation of computer system and make the hardware run.  ● SOFTWARE can be classified broadly into two categories.  1. System Software- refers to the programs that control internal computer operations and make best use of the hardware. The system software can further be classified into following categories: Operating system Language processor Utilities or Utility Software  2. Application Software- is the set of programs necessary to carry out operations for a specified application. These are the programs written by programmers to enable computer to perform a specific task such as processing words, inventory control, handling calculations and figures, medic...
Read more