MS Access 2007 Step By Step - Asim Abbasi
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Chapter 1: Overview
Design Queries Visually
Most of the time we use the ‘Design View’ option to create new queries.
New queries can be based on existing tables or queries or both. The
knowledge of SQL language statements/commands helps but it’s not
required. No need to write SQL code to build query. While you build
query visually using click, drag and drop operations, MS Access writes
the corresponding SQL code in the background. Remember that in RDBMS
environment the only communication protocol for database systems is SQL.
Figure 1-6: MS Access’s visually query designing
environment.
________________________________________
Once we are in the Design View of query builder as
shown in Figure 1-6, all we have to do is to select the tables and
queries we want for this new query. Next step would be to build the
relationship in between these tables/queries and select the columns and
fields we would be looking for in the output of our new query.
Relationship between tables/queries helps in limiting the number of
records in output of the query or you can say that it helps in bringing
information scattered in two or more tables in the output of a query.
It’s worth mentioning over here that once you run your query and if the
result is up to your desire then save it. The data you see in the output
of the query can be exported from MS Access database in nearly all
different famous data formats including but not limited to MS Excel, CSV
(Comma Separated Values), Tab delimited values, MS Word, HTML etc.
We will be learning about queries in great details in the chapter ahead.
Chapter 1: Overview
CH1: Overview | CH2: MS Access Local & Linked Tables | CH3: MS Access Queries | CH4: MS Access Reports & Forms | CH5: MS Access Modules & Macros | CH6: MS Access Data Import/Export Feature | CH7: MS Access Built-In Functions
Share with others: