MS Access 2007 Introduction
Training
In London
Description
-
Type
Training
-
Level
Beginner
-
Location
London
-
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.
Facilities
Location
Start date
Start date
Reviews
Course programme
Our accessible but thorough approach to your training is designed to take you through the fundamentals principles of Access and leave you with a functional knowledge of the necessary skills for today’s workplace.
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
Time: The course starts at 09:30 and runs until 16:30
The course is run on a date that suits you! We do not run public scheduled courses.
Additional information
MS Access 2007 Introduction