Microsoft Office Access
2010 | 2007 | 2003
Basic | Intermediate
Microsoft Office Access Basic
The course focuses on:
The basic aspects of Microsoft Office Access. You will understand how a database work and which components it comprises of. At the end of the day you will be able to set up a basic database, with fields and relationships. You will be able to create forms and queries and format reports.
Who should attend this course?
This course is aimed at anyone who wishes to perfect their Microsoft Access skills.
The following people will find this course helpful:
-
Anyone who wish to create a basic database
-
Anyone who has basic knowledge of Access and wish to improve their skills on the program
-
Sales staff, marketing managers
-
Data captures
-
Business Analysts
Duration: 1 Day
Outline:
Introduction to Access
Exploring Access Databases
Database components
What is an Access Database?
Create a Access Database
Help
Tables
Field, Control and Object Names
Create a Data Table
Set Field Properties
Manipulate the Table Design
Manipulate Table Data
Delete a Table
Relationships
Set Primary and Foreign keys
Create Table Relationships
Edit Relationships
Explore Sub-data sheets
Queries
Create Select Queries
Run a Query
Extend Queries with Criteria
Use Calculated fields in Queries
Apply Record Grouping and Calculations
Forms
Use AutoForm
Use Form Wizards
Create a Form Manually
Modify a Form
Set Print Options
Print a Form
Reports
Explore AutoReports
Use the Report Wizard
Add Calculated fields to a Report
Format a Report
Set Print Options
Print a Report
Return to
soft skills course list | computer course list
To book for this course click here