Scribd
Upload
32 views2 pages

Notes-Raising Queries-Ch-4

ict

Uploaded by

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

Notes-Raising Queries-Ch-4

ict

Uploaded by

messyinformally
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

Chapter - 4 Raising Queries In MS Access 2016

ANSWER THE FOLLOWING:

1. Can you create relationship between two tables in MS Access and for what purposedo we
create relationship between tables.

Ans: Yes we can create relationship between two tables in MS Access. Relationships define how tables
are related to each other through common fields, andthey serve several important purposes:
∙ Maintaining Data Integrity: Relationships help maintain data accuracy andconsistency by
preventing redundant or conflicting data.
∙ Avoiding Data Duplication: Instead of duplicating data across multiple tables, relationships
allow you to store data in normalized form.
∙ Improving Query Performance: When tables are appropriately related, queries canbe constructed
to retrieve data from multiple related tables simultaneously. ∙ Enforcing Referential Integrity: By
establishing relationships, you can enforcereferential integrity, ensuring that records in one table
refer to existing records inanother table.

2. How can you filter Records in MS Access 2016.

Ans: Filtering records in Microsoft Access 2016 allows you to viewa subset of databased on
specific criteria. There are different ways to filter records. For example:
Steps for filtering records in MS Access:
∙ Open the table or query in Datasheet View.
∙ Locate the column by which you want to filter the records.
∙ Click on the filter arrow at the top of the column. This arrowappears whenyouhover over
the column header.
∙ A dropdown menu will appear. You can select various filtering options suchastext filters,
number filters, date filters, and more.
∙ Depending on the filter type, you'll be able to input filter criteria. For example, you can
choose specific values, ranges, or text patterns.
∙ Apply the filter to see the records that match the specified criteria. ∙ To remove the filter,
click the filter arrow again and choose "Clear Filter from[Column Name]."
3. Explain the process of raising a Query using a Query Wizard?

Ans : Step-by-step process for creating a query using the Query Wizard in Microsoft Access:
∙ Open Query Wizard:
Open your Microsoft Access database.
Click on the "Create" tab in the top menu.
Choose Query Type.
∙ In the "Queries" group, click on "Query Wizard."
∙ Pick the table or query you want to use as the data source for your query. ∙ Move the
fields you want to include in the query's results fromthe "AvailableFields" list to the
"Selected Fields" list.
∙ Set criteria to filter the data if necessary (e.g., show only records with a certainvalue).
∙ If you want to sort the results, select the fields you want to sort by and specifyif it should be
ascending or descending.
∙ Provide a name for your query or keep the suggested name. Click "Finish."
∙ View Query Results.
The query results will open in a new window, showing the data that meets your criteriaand
structure.
Save Query.

4. How does the criteria option help in defining the results of a query?

Ans:The "criteria" option in a query helps define the specific conditions or rules that records must
meet to be included in the query's results. It acts as a filter, allowingyou to narrow down the data
that is retrieved from the database based on certaincriteria. This is a powerful feature that lets
you retrieve only the informationthat isrelevant to your analysis or reporting needs.

5. How will you run a Query?

Ans: Running a query in Microsoft Access is a straightforward process: ∙ Open the


Database:
∙ Launch Microsoft Access.
Open the database that contains the query you want to run.
∙ Navigate to Queries: Look for the "Queries" section, usually located in the left sidebar.
Select the Query:
∙ Click on the query you want to run. It will open in "Datasheet View" or "DesignView."
∙ Run the Query:
∙ In "Datasheet View," you'll see the results of the query.
∙ In "Design View," check your query's design, and if everything looks good, clickthe"Run"
button (usually a red exclamation mark) in the toolbar.
∙ View Results: The query results will be displayed in a table-like format. You'll only see
records that match your query's criteria.

You might also like