Open / Close contact form

MS Access

Course Overview

The Microsoft Access training will guide you through a wide range of aspects of Microsoft Access. You will gain hands-on, practical experience throughout, meaning you can put the theory into practice.

Course Outline

Database Concepts
  • Database
  • Relational Database
  • Table
  • Record (Row)
  • Field (Column)
  • Data Types

Opening A Database & Security Issues

  • Opening a Database
  • Trusted Locations
  • Setting the Default Folder Location
  • Closing the Access Program

Tables, Fields And Field Types

  • Creating a New Blank Database
  • Adding Fields and Setting the Field Type
  • About Access Data Types
  • Closing and Naming a Table

Table Navigation & Modification

  • Opening a Table within a Database
  • ‘Datasheet View’ vs. ‘Design View’
  • Adding Records to a Table
  • Navigating Through Records
  • Adjusting Column Width
  • Automatically Resizing a Column Widths
  • Rearranging the Column Order

Field Properties

  • Field Properties
  • Input Masks
  • Validating Numbers
  • Validating Dates
  • Data Entry Required / Not Required
  • Field Properties – Reference Materials
  • Field Properties – Logical Operators
  • Field Properties – General
  • Field Properties – Format
  • Field Properties – Input Mask Characters

Manipulating Tables & Records

  •  Renaming a Table
  •  Editing Data within a Record
  •  Deleting Data within a Record
  •  Using the Undo Command
  •  Deleting a Single Record
  •  Deleting Multiple Records
  •  Deleting a Table

Primary Keys And Indexing

  •  Defining a Primary Key
  •  Indexing
  •  Creating a Single-Field Index
  •  Creating a Multiple-Field Index
  •  Deleting Multi-Field Indexes

Filtering

  • Text Filters
  • Single Filter
  • Multiple Filters

Sorting

  • Sorting Records
  • Removing a Sort
  • Sorting on Multiple Fields

Searching

  • Searching Through Records

Relationships

  • One-To-Many Relationship
  •  Many-To-Many Relationship
  •  One-To-One Relationships
  •  Creating Relationships between Tables
  •  Referential Integrity
  •  Cascade Options
  •  Cascade Update Related Fields
  • Cascade Delete Related Records
  •  Enabling Cascade Options
  •  Deleting Relationships

Forms

  • Creating Forms
  • Modifying Forms
  • Saving a Form
  • Form View
  • Adding and Formatting Attachments
  • Modifying Data within Records
  • Deleting Records using a Form
  • Adding Records using a Form
  • Closing Forms
  • Deleting a Form
  • Filtering a Form
  • Removing a Filter from a Form
  • Inserting and Modifying a Form Header
  • Inserting and Modifying a Form Footer

Queries

  •  Creating a Query
  •  Adding Criteria to a Query
  •  Running a Query
  •  Editing Criteria In a Query
  •  Saving a Query
  •  Creating a Two Table Query and Sorting the results
  •  Refining a Query
  •  Wildcards
  •  Deleting a Query
  •  Hiding and Un-Hiding Query Fields

Reports

  • Creating a Report
  •  Using the Report Wizard
  •  Modifying the Layout of a Report
  •  Widening a Report Column
  •  Modifying the Report Title
  •  Adding a Logo to a Report
  •  Formatting a Form using Themes
  •  Modifying Field Names within a Report
  •  Inserting and Formatting the Date & Time
  •  Adding Existing Fields to a Report
  •  Resizing Reports For Printing
  •  Totals
  •  Closing a Report
  •  Deleting a Report

Exporting

  •  Exporting a Table As an Excel File
  •  Exporting a Table As a Text File
  •  Exporting a Table As a Text CSV File
  •  Exporting a Table As a PDF File
  •  Exporting a Table As an XML File

Printing

  • Print Previewing
  •  Portrait and Landscape
  •  Adjusting Layout In Print Preview
  •  Margins
  •  Printing a Complete Table
  •  Printing Selected Records
  •  Printing a Query or Reports
  •  Printing Forms

Reference: The Access 2010 Interface

  • Opening a Database
  •  Opening a Table
  •  The Ribbon (Toolbar)
  •  Ribbon Tabs
  •  Groups
  •  Dialog Box Launcher
  •  Navigating
  •  Contextual Tabs
  •  Minimising the Ribbon
  •  The File Tab
  •  Microsoft Access Help
  •  Closing Access 2010

Database Terminology & Theory

  • Database
  •  Table
  •  Record
  •  Field
  •  Field Data Types
  •  Field Properties
  •  Primary Key
  •  Types of Database

Trusted Locations

  • Setting a trusted location

Fields

  •  Creating a Lookup within a Field.
  •  Modifying a Lookup within a Field.
  •  Deleting a Lookup within a Field.
  •  Creating an Input Mask.
  •  Modifying an Input Mask.
  •  Deleting an Input Mask.
  •  Modifying a Field to Require Data Entry.
  •  Modifying a Field So That It Does Not Require Data Entry.

Relationships

  • Creating and modifying a One-To-One Relationship.
  •  Creating and modifying a One-To-Many Relationship.
  •  Creating and modifying a Many-To-Many Relationship using a Junction Table.
  •  Enforcing Referential Integrity.
  •  Automatic Updating of Related Fields.
  •  Automatic Deletion of Related Records.

Joins

  • Inner Join.
  •  Outer Join.
  •  Subtract Join.
  •  Self Join

Queries

  •  About Queries
  •  Update Query.
  •  Delete Query.
  •  Make Table Query.
  • Append Query.
  •  Crosstab Query.
  •  Find Duplicates Query.
  •  Find Unmatched Records Query.
  •  One Variable Parameter Query.
  •  Two Variable Parameter Query.
  •  Using Wildcards In a Query:
  •  Maximum or Minimum Values In a Query.
  •  Using Calculated Fields That Perform Arithmetic Calculations.
  •  Grouping Information In a Query using Functions.

Forms

  •  Types of Form Controls
  •  Bound Controls Vs. Unbound Controls.
  •  Text Box.
  •  Combo Box.
  •  List Box.
  •  Check Box.
  •  Limit to List
  •  Distinct Values.
  •  Arithmetic Expressions.
  •  Logical Expressions.
  •  Modifying the Tab Order in a Form.
  •  Creating a Sub-Form.
  •  Linking a Sub-Form.

Reports

  •  Formatting Arithmetic Calculation Controls
  •  Applying a Running Sum For a Group or Over All
  •  Concatenating Fields within a Report.
  •  Inserting a Data Field In a Report Group.
  •  Inserting a Data Field In a Report Page.
  •  Inserting a Data Field In Report Headers and Footers.
  •  Sorting and Grouping Records In a Report By Field(S).
  •  Forcing Page Breaks For Groups In a Report.
  •  Creating a Linked Sub-Report.

Macros

  •  Creating Macros
  •  Assigning a Macro to a Command Button.
  •  Assigning a Macro to an Object.
  •  Assigning a Macro to a Control.

Enquire Now

Learn Adobe Photoshop
Your name:
Email address:
Phone number:
Message:

Our google reviews

Other related courses