COURSE TITLE

Access 2003 Course

DURATION

8 Hours of Interactive Training

COURSE OVERVIEW

Relational databases are a critical component of the infrastructure that allows our electronic society to easily store, index and share information. In this Access 2003 course, you'll learn basic and advanced capabilities of this popular database tool from Microsoft.

Expert instructor Erin Olsen will soon have you building databases, querying data, designing forms and generating reports. At the conclusion of this course, you'll understand how to use Access 2003 to organize, retrieve, and share information.

BENEFITS

  • Gain valuable database management skills
  • Acquire leverage to better career opportunities
  • Learn the latest information technology

CONTACT

Website:

Email:

Telephone:+961+8+9404 7041

Fax:+961+8+9467 9132

PRICING

Contact Mobile MOUSe for pricing.

ADVANTAGES OF ONLINE COURSES

  • Session times are at your discretion
  • You can pick and choose which sessions to cover and in any order
  • Learn at your own pace
  • Free repetition (for a period of 6 months)
  • Multiple course levels at a discounted price
  • Many of the courses are internationally accredited
  • Training from the comfort of your home or workstation
  • Training can be accessed from any location

MOBILE MOUSe

ACCESS 2003ONLINE COURSE OUTLINE

Session 1

Section A: Introduction

  • Relational Databases
  • Flat System
  • Relational System
  • Database Components

Section B: Database Objects

  • Tables
  • Queries
  • Forms
  • Reports
  • Macros
  • Modules
  • Data Access Pages

Section C: Database Planning

  • Naming Conventions
  • Convention Examples
  • Database Design
  • Plan Purpose
  • Plan Tables
  • Plan Fields
  • Plan Relationships

Section D: Examining Access

  • Opening a Database
  • Opening Tables
  • Switching Views
  • Opening Queries
  • Opening Forms
  • Opening Reports
  • Creating Databases
  • Database Wizard

Section E: Database Tables

  • File Formats
  • Creating Tables
  • Choosing Data Types
  • Create Descriptions
  • Assign Primary Key
  • Saving
  • Saving Tables

Section F: Text Field Properties

  • Field Size
  • Format
  • Caption
  • Default Value
  • Required
  • Allow Zero Length
  • Numbered Text Fields
  • Input Mask

Section G: Number Field Properties

  • Number Field Size
  • Format Date
  • Validation Rule
  • Validation Text
  • Validation Data
  • EndDate Validation Rule

Session 2

Section A: Working with Data

  • Moving Through Tables
  • Adding Records
  • Editing Records
  • Deleting Records
  • Keyboard Shortcuts

Section B: Working with Datasheets

  • Datasheet Formatting
  • Modifying Font
  • Modifying Column Widths
  • Hiding/Showing Columns
  • Moving Columns

Section C: Manipulating Data

  • Sorting Data
  • Finding Data
  • Filtering Data
  • Filter Excluding Selection
  • Filter For Input
  • Filter By Form
  • Save As Query

Section D: Working with Table Structure

  • Manipulating Fields
  • Changing Data Types
  • Deleting Fields
  • Moving Fields
  • Using Name AutoCorrect
  • Property Update Options
  • Creating Lookup Fields
  • Using Lookup Wizard

Section E: Dependencies and Datasheets

  • Object Dependencies
  • Subdatasheets
  • Controlling Subdatasheets

Section F: Shaping Up Tables

  • Copying
  • Renaming
  • Deleting
  • Printing

Section G: Importing and Exporting

  • Importing
  • Import Wizard
  • Exporting

Section H: Relationships

  • Understanding Relationships
  • Referential Integrity
  • Join Types
  • Join Type Example
  • Relationship Types

Section I: Creating Relationships

  • Relationship Setup
  • Show Tables
  • Arranging Tables
  • Permanent Relationships
  • Printing Relationships

Session 3

Section A: Select Queries

  • Creating in Design View
  • Sorting
  • Adding Additional Tables
  • Join Properties
  • Show Box

Section B: Filtering with Criteria

  • Exact Entries
  • Comparison Operators
  • Filter Range
  • Is Null/Is Not Null
  • Using And Statements
  • Using Or Statements
  • Unique Values

Section C: Calculations

  • Formulas
  • Group By
  • Concatenation

Section D: Intro to Forms

  • Creating AutoForms
  • Form Components
  • Working with Controls
  • Aligning Controls
  • Removing Controls
  • Adding Controls
  • Using the Forms Wizard

Section E: Working in Forms

  • Formatting Forms
  • Control Properties
  • Navigating a Form

Section F: Data Access Pages

  • Save Form As
  • Using the Page Wizard
  • Apply Themes
  • Preview in Browser

Section G: Working with Reports

  • AutoReports
  • Report Wizard
  • Controls and Sections
  • Modifying Controls
  • Sorting and Grouping
  • Controlling Page Breaks
  • Report Output Options

Section H: Maintaining the Database

  • Compact and Repair
  • Backing Up Data
  • Convert Database

16/12/2018PAGE 1