Datasheet

Forms
A form presents data from a table or query in a structured view instead of the row and
column format that a table shows. You create forms to
 Make data entry easier and more intuitive.
 Limit fields the user sees and changes.
Reports
A report presents information from your database in a printed format. You can format
reports to display lists sorted by one or more columns. They can display totals and sub-
totals and pull data from one or more tables. You can apply a common theme to your
reports to ensure that the printed output from your database has a consistent look
and feel.
Macros
A macro is an action or set of actions that performs database operations. Macros let you
automate your database by automatically performing tasks or performing tasks at the
touch of a button. Macros perform such database functions as opening forms, printing
reports, and manipulating data.
Modules
A module is a set of functions and procedures written in the Visual Basic for Application
(VBA) programming language. Like macros, modules are also used for performing opera-
tions on your database, but go far beyond the limitations of macros.
VBA isn’t covered in this book. If (after you’re done with this workbook) you’re interested
in learning how to use VBA to perform operations in your databases, pick up a copy of
Access 2007 VBA Programming For Dummies, coauthored by yours truly and Alan Simpson
(Wiley).
Launching Access
In order to be proficient in its use, you need to be familiar with all the various ways of
launching Access.
Exercise 1-1: Launching Access
You can use any of the following techniques to start Access:
 Click Start on the Windows taskbar and then choose All Programs➪Microsoft
Office
➪Microsoft Office Access 2007.
 Double-click an Access database file in any folder on any drive to which your com-
puter has access.
 Double-click the Microsoft Access program icon on your computer’s desktop.
 Click the Microsoft Access icon on the taskbar’s Start menu.
 Click the Access icon on the Quick Launch toolbar.
11
Chapter 1: Getting Started with Access
05_179536 ch01.qxp 10/29/07 7:47 AM Page 11