Microsoft Access 2003 Level 1
Introduction to Databases
- Database Concepts
- Database Layout
- Launching Access
- The Access Menu System
- Dialog Boxes
- Getting Help
- Creating a New Database
- Closing a Database (vs exit Access)
- Opening a Database
Tables
- Database Design
- Creating Tables Using the Table Wizard
- Creating Tables in the Datasheet View
- Creating Tables in the Design View
- Data Types
- Field Properties
- Data Display Format vs Input Mask
- The Input Mask
- Data Entry Problems
- Moving and Copying Records
Working with Tables
- Pasting Records
- Sorting the Table
- Deleting a Table
- Table Layout Changes
- Find
- Replace
- Wildcards
Queries
- The Simple Query Wizard
- The Design View
- Modifying the Query
- Using Basic Criteria
- Additional Criteria
- Parameters
- Multiple Object Queries
- Custom Calculations in a Query
- Calculating Fields Continued
- Grouping Fields
Introduction to Reports
- Reports
- The Report Wizard
Course Benefits
It gives an introduction to database design concepts and gives you the ability to create the core objects of a database and covers an introduction to data manipulation and extraction.
Target Audience
People who intend to design databases from scratch or improve existing Access databases. Also conversion of databases made in other applications and spreadsheet (flat file) databases.
Pre Requisites
No previous experience is required. However, delegates with some experience in database design utilising another graphics package may find this useful.
Location of Course
Camberley
Course Trainer
Sue Parsons
Click here to view trainer's portfolio.
