Access 2003

ELECTUS
Adelaide, SA, Australia

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this 2 day program, participants will be introduced to the fundamentals of database design and conventions and will be provided with the skills to use Microsoft Access effectively.



You will learn to

Ø Use databases and database objects

Ø Create and work with tables

Ø Set field properties

Ø Understand the concept of Normalisation

Ø Create relationships

Ø Analyse a Table

Ø Find, filter and sort records in a database

Ø Create Queries to analyse and view data

Ø Create basic forms and reports

Ø Use the design view



What skills you need

No prior knowledge of Microsoft Access is assumed, however those attending this course should be competent in the use of the keyboard, mouse and working in the Windows environment.

Course Content
Exploring Access

· Starting and exiting Access

· Opening a Database

· Changing Menu and Toolbar Options

· Using Database Objects

· Using the Database Window

Using On-Line Help

· Working with Online Help

Creating Tables

· Creating a New Database

· Designing Tables

· Creating in Design View

· Using Design View

· Adding Field Names

· Assigning Data Types

· Adding a Field Description

· Setting a Primary Key

· Using the Table Wizard

Working with Tables

· Using Datasheet View

· Navigating Fields in Tables

· Adding Records

· Moving through Records

· Selecting Records

· Editing, Saving and Deleting Records

Setting Field Properties

· Using Field Properties

· Limiting Field Size

· Setting Number Formats

· Date/Time Formats

· Yes/No Formats

· Setting Default Values

· Setting Validation Rules

· Creating an Input Mask

Editing Tables

· Changing the Row Height

· Changing the Column Width

· Changing the Font

· Changing a Cell Effect

· Selecting Columns

· Moving Columns

· Hiding/Unhiding Columns

· Freezing Columns

· Importing Data
Normalisation & Analysing Tables

· Normalisation

· Analysing a Table

· Using Relationships in Splits

· Using the Table Analyser Wizard

· Using the Performance Analyser

Creating Relationships

· Using Related Tables

· Creating a Relationship

· Setting Referential Integrity

· Viewing Subdatasheets

· Deleting the Join Line

Modifying Tables

· Inserting/Deleting Columns

· Renaming Columns

· Inserting a Lookup Column

· Inserting a Hyperlink Column

· Creating a Many-to-Many Relationship

Finding and Filtering Data

· Sorting Records

· Finding Records using Wildcards

· Using Replace

· Using Filter by Selection

· Applying/Removing a Filter

· Using Filter Excluding Selection

· Using the Filter For Feature

· Using Filter by Form

Using Simple Queries

· Using Queries and RecordSets

· The Simple Query Wizard

· Creating a Query in Design View

· Opening and Running a Query

· Adding a Table to a Query

· Joining Tables in a Query

Modifying Query Results

· Sorting and Printing a Query

· Adding Criteria to a Query

· Adding a Record using a Query

· Printing a Query
Using Operators in Queries

· Using Comparison Operators

· Using an And Condition

· Using an OR Condition

· Using the Between...And Operator

· Using the Expression Builder

· Using Wildcard Characters

Designing Advanced Queries

· Setting Top Values

· Creating a Calculated Field

· Creating a Function Query

· Creating a Parameter Query

· Creating a Concatenation in a Query

· Filtering a Query

Creating Basic Forms

· Using Forms

· Using The Form Wizard

· Viewing Records in a Form

· Printing Records in a Form

· Basing a Form on a Query

· Using AutoForm

· Adding a Record using a Form

Using Design View

· Hiding the Ruler

· Disabling Snap to Grid

· Displaying the Field List

· Adding a Field

· Moving Part of a Control

· Aligning and Spacing Controls

· Using the Toolbox

· Adding a Label

· Adding an Image

· Adding a Rectangle and a Line

· Editing an Unbound Control

Creating Basic Reports

· Using Reports

· Using the Report Wizard

· Working in Print Preview

· Printing Specific Pages

· Grouping and Summarising Report Data

· Basing a Report on a Query

· Using AutoReport

...''

Phone:08 8221 5517

School Address:

37 Angas St
Adelaide SA 5000

Jobs & Resumes: Adelaide
Houses & Roommates: Adelaide

Influencing & Negotiation
Minute Taking & Meeting Protocol
Customer Service
Report Writing
Speaking to Groups
Telephone Techniques
Indispensable Assistant
Leadership
Time Management
Access - Advanced
CorelDRAW 12
Dreamweaver MX 2004 Advanced
Dreamweaver MX 2004
Excel 2003 Advanced
Excel 2003 Intermediate
Excel 2003
FrontPage 2003 Advanced
FrontPage 2003
Outlook 2003

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Facts: This website holds more than 300,000 training course records worldwide, with hundreds of new postings daily. All services in this website are free!