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
Queries
MS Access is not only an excellent data analysis tool but a wonderful
RDBMS (Relational Database Management System). Once we have all the
tables in MS Access (both Local and Linked), the next step would be to
run queries or in other words to analyze the data residing in those
tables.
Figure 1-5: Query Wizard lies under the Create
command.
________________________________________
MS Access treats external linked tables as if those
tables are MS Access Local tables when it comes to queries discussion or
in other words as if those tables are created locally and the data
inside them resides in the MS Access database. So while writing queries
always treat linked tables as if the tables residing locally to MS
Access database.
If you want to create a brand new query then click the “Create” command
as shown in Figure 1-5 and then “Query Wizard”. On the other hand if you
want to edit the already existing query, first right click the query and
from the popup menu select the “Design” command to enter into Query
Design View.
Clicking “Query Wizard” command will result in a “New Query” window with
all different options pertaining to new query development. Most of the
time we use the “Design View” option to build new queries visually just
by click and drag operations.
If you want to find duplicate records information in any table or
already existing query then use the option “Find Duplicates Query
Wizard”. Moreover, if you want to find unmatched information between two
tables or two queries or between the query output and a table then
select the “Find Unmatched Query Wizard” option. We will be discussing
about these queries in great details in the later in this book.
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: