Microsoft Access 2007/2010: Introduction for Beginners

Course Overview

This course is designed for new Access users, or self taught users. The course will cover all aspects of database design and objects.

This course is suitable for Access 2007 and 2010.

CourseMonster specialises in offering Microsoft training to corporations and individuals alike, we are happy to help with any of your Microsoft training requirements.

Related Courses

• Microsoft Access 2010: Introduction for Beginners
• Microsoft Access 2010: Advanced Level 3
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Fundamentals
• Microsoft Access 2007/2010: Advanced
• Microsoft Access 2010: Specialised
• Microsoft Access 2010: Intermediate
• Microsoft Access 2010: Advanced
• Microsoft Access 2007/2010: Advanced Skills
• Microsoft Access 2007 2010: VBA Programming

Audience

No previous experience of Access is required to attend this course. You must have good basic Windows skills, e.g. Mouse and Keyboard

Skills Gained

On completion you will be able to:

• Understand Database Concepts and Objects
• Create, Edit and Maintain Tables
• Create Queries
• Create Forms
• Create Reports
• Create Relational Tables, Forms, Queries and Reports

Course Outline

Database Overview / Terms / Planning

• An overview of databases, database objects and terminology
• 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

Queries 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

Multi 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