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
Access writes SQL Statement behind the Scene
As mentioned before whenever you are building query, MS Access in the
background creates the corresponding SQL code for you. Whenever you
want, you can view that code. The SQL code can be better viewed by first
having the query in the Design View and then selecting “View” from the
ribbon bar. Next click “SQL view” command as shown in Figure 1-7. Once
you are in the SQL view you can see the SQL code as shown. You can also
edit this SQL code according to your likeness. If you make mistake, you
will see error message showing up once you go back to the Design View by
clicking “View” and then “Design View”.
Figure 1-7: Moving from Design View to SQL View of
query.
________________________________________
Six Different Access Queries
MS Access provides six different query options, all with visual power,
no need to drink deep into the SQL coding stuff. Once you are in the
Design View of MS Access query builder, on the ribbon bar you can see
all of them, as depicted in Figure 1-8.
Figure 1-8: Query Design View and Create command have
all different MS Access Queries options e.g. Select, Append, Make Table
etc.
________________________________________
Depending upon the type of query you would like to
build, select the corresponding option to achieve the goal. The options
at your disposal are as follows.
Select Query
Make-Table Query
Update Query
Append Query
Delete Query
Crosstab Query
The study of crosstab query is beyond the scope of this book but rest of
them will be discussed in detail later in this book. For advanced MS
Access users please check our recommended book: Oracle Data
Manipulation, Knowledge Discovery & Reporting Using MS Access (ISBN:
0-9770739-1-2) on Amazon (http://www.amazon.com).
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: