MS Access 2003 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 3: MS Access Queries
Five Different Queries In Focus
In this chapter our sole focus would be on one of
very important objects in MS Access i.e. Queries. You can see drop down
list of all different kinds of MS Access Queries by first clicking
‘Queries’ object and then clicking ‘New’ as shown in the picture below.
As
a result of this action a window will popup having the title ‘New’.
Select the option of Design View and click the <OK> button. Basically
you are commanding MS Access that you would like to create a new query
in Design View.
MS Access then asks for tables/other existing queries required for this new query, click cancel for now. We can always add tables later. Once done we will be in MS Access query Design View. On the tool bar you will see the icon with the drop down arrow as shown in the picture below.
This
drop down menu will show you all different types of Query options we
have in MS Access. Now lets talk about each of these different types of
queries briefly one by one to comprehend the bigger picture of the whole
story. After this, we will be talking about each of these types in much
more detail.
Chapter 3: MS Access Queries
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: