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
MS Access Reports
If you would like to create Reports, the first step would be to click on
the “Create” command on the menu bar, under which you will find all
different options of creating new reports as shown in Figure 1-9.
Difference between report and query is that in case of reports the
queried data is presented in a cosmetic fashion with header, footer,
high-lighted text etc. where as in case of query there is no such
formatting.
If you want to edit the already existing report, the first step would be
to expand the “Reports” object under the “All Access Objects” group.
Then right click on the selected report and finally click on the “Design
View” from the popped up menu as shown in Figure 1-9.
The reports are integral part of any data related business process
model. In a 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 make 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 MS Access
Report.
Figure 1-9: Create new reports using the Report Wizard
under the Create command or edit the exiting report with right click and
then clicking “Design View” from popped-up menu.
________________________________________
MS Access Macros
Macro helps in automating certain tasks in MS Access e.g. if you would
like to run 12 queries or more, one way to do this to run one by one
manually the other way is to create a macro and click once and let the
macro take the control over running those 12 queries one after the
other. Again you don’t have to write any code as in C or C++. Everything
is done using click and select operation. Whenever you want to create a
macro, click the “Create” command on the menu bar and then click/expand
“Macro” on the ribbon bar as shown in Figure 1-10.
On the other hand, if you want to edit the already existing macro, the
first step would be to expand the “Macros” object and then right click
on the selected macro and finally click the “Design View” command from
the popped-up menu. We would be learning about macros in detail later in
the book.
Figure 1-10: Create new macro using the Macro design
view under the Create command or edit the exiting macro with right click
and then clicking “Design View” from popped-up menu.
________________________________________
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: