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 1: Overview
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 tool bar click on drop down menu
as shown in the screenshot below.
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.com
MS Access Reports
If you would like to create Reports, the first step would be to click on the “Report” object under the “Objects” group and then click “New”. With this action “New Report” window will popup. The reports are integral part of any data related business process model. In a big enterprise database environment we first create query to pull information from server to local repository (in our case it’s MS Access). We then present the data in a very good looking format to utilize full abilities of our color printers. We build column header colored with colored underlies. We put date and page numbers on the footer and title of the report pertaining to the extracted data in the header. All and similar kind of tasks can be achieved with Report building.
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: