Microsoft Access Introduction
Dates
This course is designed to give you an understanding of some of
the major features and functions within Access. An introduction
to database theory and practice, plus hints and tips on good database
design techniques are also given. On day 2 additional l skills and
knowledge on using the many features and functions of this software
to make them more efficient and effective when processing data are
introduced. This entirely 'hands on' course will give participants
experience in producing database applications and the ability to
create a variety of data views, queries and reports.
Introduction to Access
What is a database? • Computerising a database • Designing
an Access database • Defining a data store • Populating
a database • Extracting information from a database •
Reporting data • Year 2000 best practice
Getting started with Access
Starting Access • Access opening screen • The Title Bar
• The Menu Bar • Toolbars • The Status Bar •
Menus and Submenus • SpeedKeys • The Database Window •
Scroll Bars • Exiting Access
Getting assistance with Access
Using the Office Assistant • Getting help without the Office
Assistant • Manipulating the help Window • Help for screen
objects - ScreenTips
Creating tables and adding records
Creating a table using the Table Wizard • Datasheet view •
Adding a record • Saving changes • Moving around the datasheet
• Finding a record • Modifying and deleting records
Designing table structures
Table design - hints and tips • Creating tables • Switching
between views • Saving tables • Field properties •
Field size property • Format and input mask properties •
Caption property • Default value property • Required property
• Allow zero length property • Indexed property
Working with data
Sorting data • Filtering data • Using advanced filters
Forms
What is a form? • Using AutoForm to design forms • Using
Wizards to design forms • Entering data using a form
Simple select queries
What is a query? • Creating a query • Modifying a query
• Restricting records returned by a query • Simple calculated
fields • Summary queries
Simple reports
Reporting from Access • Printing from datasheet view •
AutoReports • Designing a report Using Report Wizards •
Label reports • Modifying reports
Database design
What is a relational database? • Primary and foreign keys •
Relationships
Using field properties for protection
Required • Default value • Input mask • Validation
rule and validation text • Lookups
Table relationships
What is a relationship? • Relationship types • Creating
and editing relationships • Using lookups for referential integrity
• Multi-table datasheet view
Queries
Multi-table queries • Calculated fields • Adding a calculated
field to a query • The Expression Builder • Calculating
summary information • Crosstab queries • General query
properties • Checking referential integrity
Forms
What is a form? • Form sections • Form controls •
Form control layout • Using form controls • Control properties
• Control Wizards • Multiple table forms
Reports
Using Report Wizards as the basis for reports • Report sections
• Report controls • Report control layout • Using
specific controls • Publishing datasheet views on the Internet
• Adding hyperlinks to datasheet views • Adding hyperlinks
to HTML pages
Access tools
Importing from other data sources • Importing data using Drag-and-Drop
• Backing up and restoring a database • Compacting and
repairing a database
|
