MS Access 2003 Introduction
Training
Inhouse
Description
-
Type
Training
-
Methodology
Inhouse
-
Duration
2 Days
To build a strong foundation in Access to provide new users with a good understanding of the basic concepts of Microsoft Access. Suitable for: New Access users, or self taught users.
Reviews
Course programme
Course Contents
Database Overview / Terms / Planning- An overview of databases, database objects and terminolgy
- Tables, Queries, Forms, Reports, Macros, Pages and Modules
- Planning a database structure and tables
- Creating a new database
Working with Tables
- Designing a Table, Rules for entering Field Names
- Enter data types, field descriptions
- Setting a Primary Key and Setting Multiple Primary Keys
- Removing a Primary Key
- Defining Field Properties(Default values, Input masks, Validation rules and text,
- Insert, Delete, Move and Rename Fields
- Table Wizards
Entering and Editing Data
- Switching Views in Access
- Entering and Editing Data
- Working in Data Entry Mode
- Sorting Data, Finding & Replacing Data
- Hiding and Unhiding Fields
Importing & Linking Data
- Importing from Access and Excel
- Linking to an external Access Database Table
- Linking to an Excel Workbook using the Wizard
- Renaming and Copying Tables
Quries and Filters
- Create a filter by selection
- Create a filter by form
- Save a filter by form as a select query
- Running a Select Query
- The Query Design Window
- Creating a query from the query window
- Adding fields to a query, Display/Suppress the display of a field
- Removing fields from a query
- Specifying Text, numeric, date, and logic criteria
- Specifying sub string searches using wild Card Characters
- Working with Conditions - BETWEEN, AND, OR, NOT, NULL
- Calculated fields
Relationships
- Why create relationships between tables?
- Different types of relationships
- Conditions for setting up a relationship
- Referential Integrity
- Cascade Update
- Cascade Delete
- Relationships Report
- Inserting Subdatasheets
- Removing Subdatasheets
- Expanding and Contracting Subdatasheets
Mutli Table Queries
- Multiple Table Queries
- Joining Tables for a query
- Join Properties - Inner and Outer Joins
- Find Unmatched Query Wizard
- Find Duplicates Query Wizard
Creating Forms
- Creating Forms using the Auto Form Tabular/Datasheet/Pivot Form wizard
- Creating Forms Using the Form Wizard
- Data Entry in Forms
- Resizing and Moving Controls
- Changing Text Attributes
- Resizing Forms
- The Field List Box
- Selecting Controls
- Formatting Controls
- Format Painter and AutoFormat
- Resizing and Moving Controls
- Properties of an item
Reports
- Standard Reports using Wizard
- Inserting, Moving, Sizing, deleting controls
- Customising Reports
- Grouping Data
- Using Expressions
- Mailing Labels
- Page setup
The course is run on a date that suits you! We do not run public scheduled courses.
Additional information
Students per class: 8
MS Access 2003 Introduction