Scribd
Upload
15 views2 pages

Understanding Relationships in Access

Chapter 2 discusses the functionalities of queries, forms, and reports in MS Access. It covers the relationships feature, the purpose of queries for data retrieval, the role of forms for data management, and the methods for creating reports. The chapter emphasizes how these database objects streamline the process of extracting specific information from large datasets.

Uploaded by

jyotirmaybarui97
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views2 pages

Understanding Relationships in Access

Chapter 2 discusses the functionalities of queries, forms, and reports in MS Access. It covers the relationships feature, the purpose of queries for data retrieval, the role of forms for data management, and the methods for creating reports. The chapter emphasizes how these database objects streamline the process of extracting specific information from large datasets.

Uploaded by

jyotirmaybarui97
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Chapter 2: Queries, Forms, and Reports in Access

Let’s Review (Pg. 40)


Consider the Query Design Grid below, and answer the questions that follow.
1. 5
2. Teacher’s info
3. Sort
4. Criteria

Exercises (Pgs. 47–49)


A. Tick (✓) the correct answers.
1. c. 2. a. 3. b. 4. c. 5. a.
B. Fill in the blanks.
1. SQL
2. Report Command, Report Wizard
3. table
4. Design, Format
5. Query
C. Write ‘T’ for True and ‘F’ for False.
1. F 2. F 3. T 4. T 5. T
D. Answer the following questions.
1. The Relationships feature in Access lets a user bring the information stored in different
tables together. Relationships are links that are used to associate a field in one table with
the exact same field in another table.
2. In MS Access, a query is a database object. It is used to retrieve data or information from data
tables based on certain conditions (or criteria). Creating a query using the Query Design
option lets you have more control over the query. This option lets you create a query from the
scratch.
3. A form is a database object that facilitates the users to enter, edit, delete, and view data in
a table.
The different formatting features that can be applied to a form are as follows:
➤ Adding a Logo
➤ Adding the Title
➤ Adding Date and Time
➤ Formatting the Text
➤ Adding Background Colour

4. A report is a database object used to display or get an output of the data in a desired format.
It collects the data and generates the reports as per the user’s required format. It is an
effective method to organise, view, and present data.
The methods used to create report in MS Access are as follows:
➤ Report Command
➤ Report Wizard

5. Database objects, such as queries, reports, and forms make it easier to extract specific
information from a huge database that includes thousands of records with multiple tables in
it.

You might also like