Ch 11: Queries in Base
What is a Query?
Query: a question asked from a database. Based on given criteria, specific records are retrieved from one or more tables and displayed in tabular form.
Three ways to create a query: 1. Using a Wizard 2. In Design View 3. In SQL View.
Query in Design View
Add tables → double-click fields into the grid → set Alias, Sort, Criterion, Visible. Run with F5.
Operators: all relational operators can be used — <, >, <=, >=, != and =. Functions: Group, Sum, Average, Count, Minimum, Maximum.
An Alias is a friendlier name shown as the column heading. The Visible check box decides whether a field appears in the result.
Summary
- A query retrieves the desired records from one or more tables using criteria.
- Three ways: Wizard, Design View, SQL View.
- Alias renames a column heading; functions work on numerical data.
Query क्या है?
Query: database से पूछा गया सवाल। दिए गए criteria के आधार पर एक या अधिक tables से records निकलकर tabular रूप में दिखते हैं।
Query बनाने के तीन तरीके: 1. Wizard 2. Design View 3. SQL View।
Design View में Query
Tables जोड़ें → fields grid में double-click करें → Alias, Sort, Criterion, Visible सेट करें। F5 से run करें।
Operators: सभी relational operators — <, >, <=, >=, != और =। Functions: Group, Sum, Average, Count, Minimum, Maximum।
Alias column heading के रूप में दिखने वाला आसान नाम है। Visible check box तय करता है कि field result में दिखे या नहीं।
सारांश
- Query criteria से मनचाहे records निकालता है।
- तीन तरीके: Wizard, Design View, SQL View।
- Alias column heading बदलता है; functions numerical data पर काम करते हैं।
Frequently Asked Questions
What are the three ways to create a query in Base?
A query can be created using a Wizard, in Design View, or in SQL View.
What is an Alias in a query?
An alias is an alternative, readable name given to a field so it appears as the column heading in the result.