Access 2000 Foundation
Course
In London
Description
-
Type
Course
-
Location
London
-
Duration
2 Days
The aim of this course is to provide delegates with a practical introduction to Microsoft Access 2000. By the end of the course delegates will be able to build a database, link to external data sources and build expressions for use within queries and forms. Suitable for: This course is designed for new users of Microsoft Access.
Facilities
Location
Start date
Start date
About this course
Whilst no previous database experience is required, a basic understanding of Windows is required and a good knowledge of Excel would be an advantage.
Reviews
Course programme
Core Topics
Database Concepts
· What Is Data?
· What Is A Database?
· Basic Concepts
· The Telephone Directory - An Example Of A Database
· Tables And Relationships
· Types Of Relationships
· Why Use An Electronic Database?
· Why Use Access?
· An Introduction To Access
· Introducing Access Tools
· Using Access As Part Of Microsoft Office Professional
· Starting Microsoft Access
· The Access Application Window
Terminology and Usage
· Opening A Database
· The Access Database Window
· Closing A Database
· Opening A Table
· The Table Window
· Exploring The Table
· Table Design View
· Introducing Queries
· Introducing Forms
· Types Of Form
· Opening An Existing Form
· Form Design View
· Introducing Reports
Database Design
· Design And Document Your Database
· Questions To Ask Yourself
· Define Your Needs
· Basic Design Rules
· Determine Relationships
· Creating A Database
· Using The Table Wizard
· Adding Fields Using The Table Wizard
· Creating A Table Without A Wizard
· Adding Fields To A New Table
· Field Properties
· The Input Mask Property
· Setting A Primary Key
· Saving A Table
· Adding Records To A Table Datasheet
Formatting a Table
· Editing Records
· Selecting Records With The Mouse
· Selecting Records Using The Keyboard
· Selecting Fields With The Mouse
· Selecting Columns Using The Mouse
· Selecting Fields And Columns Using The Keyboard
· Deleting Records And Fields
· Viewing Or Setting Datasheet Default Values
· Re-Ordering Columns Within A Table
· Re-Ordering Fields In The Table
· Changing Column Width And Row Height
· Hiding And Un-Hiding Columns
· Freezing Columns
· Formatting Datasheet Cells
· Changing Datasheet Fonts
· Copying And Moving Fields And Records
· Another Look At The Database Window
· Printing
Access 2000 Foundation