Microsoft Office Access 2010

7 Hours per Level – Instructor Led Course

Center Benefits – Microsoft Office Courses
Free Online Skills Assessment Tests
Corporate Venue: Onsite or at NLP Tech for MA
UAE Ministry of Education Accredited Institute
International Curriculum
Certified Instructors
Computer Labs: 1 PC for each student
Certificate of Achievement (Ministry Attestation fees apply)Foundation Level 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
Intermediate Level Course Outline

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

Advanced Level Course Outline
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.

Linking Data
Linking an Excel Workbook to a Database.
Linking External Text Data In a TXT File
Linking External Text Data In a CSV File
Linking External Data to a Database using Existing Database Files.

Importing Data
Importing an Excel file.
Importing a CSV Text file
Importing a TXT file
Importing an XML file
Importing an Database File

Have a Question or
Need Information?