Phone: 009714 3858511
E-Mail: sales@nlptechforma.com
NLP Courses
Leadership Skills Courses
Human Resource Courses
Management Courses
What is NLP
Weight Loss
Anxiety
Quit Smoking
Life Improvement
Depression
Motivation
Confidence
Hypnosis
Anger Management
Career
Success
NLP Just for Doctors
NLP Just for Kids
NLP Just for Women
 
Cisco
CCNA
CCNP
MicroSoft
Microsoft Windows Server
2012 Certification & Training
MCITP
MCTS
MCSA
MCSE
 
Technical Courses
Internet Marketing Course
Oracle / Java
IT Security
 
Languages
English
IELTS
TOEFL
GMAT
 
Management
Communication
Leadership
Customer Service
Human Resource
Project Management Pro
 
Additional Courses
SAT
 
1 Day Workshops
Success Leaves Clues
Get What You Want
 
Microsoft Office / ICDL
Photoshop CS4 Syllabus
Personal Life Coach
Online Training
Special Discount
Course Calendar
Clients List
 
 
 
Microsoft Office Access 2007
 
 
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)

Level 1 Course Outline
Access 2007 Database Concepts
What is a database?
What is a relational database?
What is a table?
What is a record (row)?
What is a field (column)?
What is data?
Data types

A FIRST LOOK AT ACCESS 2007
Opening Access 2007
Exploring the Access 2007 window
The Ribbon (Toolbar)
Ribbon tabsError! Bookmark not defined.
Groups & Dialog Box Launcher
Navigating - Quick keys (shortcut keys)
Navigating - Pointer keys & quick keys
Navigating - Mouse wheel
Contextual tabs
Minimising the Ribbon
Quick Access Toolbar
The Office ButtonError! Bookmark not defined.
Microsoft Access Help

OPENING A DATABASE & SECURITY ISSUES
Opening a databaseError! Bookmark not defined.
Security warnings
Trusted Locations - Trust Centre
Setting the default folder location within Access

CREATING A DATABASE & USING VIEWS
Creating a new database
Creating a new blank database
Saving a table
Adding and renaming fields
Using Datasheet View
Using Design View
Changing the view

TABLE MODIFICATION AND NAVIGATION
Adding Fields - Design View
Data Type - Overview
Data Type - Descriptions

Using the Attachment data type

Adjusting column width
Moving a column to rearrange the column order
Adding records to a table
Navigating through records within a table
Closing a database
Navigation Pane

FIELD PROPERTIES, VALIDATION & INPUT MASKS
Field Properties
Input Mask
Validation Rules
Field Properties - Guides Tables

MANIPULATING RECORDS & TABLES
Closing an Object - Table
Renaming an Object - Table

Editing data within a record
Deleting data within a record
Using the Undo command
Deleting a single record
Deleting multiple records
Save As - Database Object
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 & SORTING
Text Filters
Applying a single filter
Clearing a single filter
Creating multiple filters
Clearing multiple filters
Sorting

RELATIONSHIPS
Table 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

ACCESS 2007 FORMS
Forms overview
Creating forms
Modifying forms
Modifying a form title
Modifying a form logo
Modifying a form label
Saving a form
Form View
Adding and formatting attachments
Modifying records
Deleting records
Adding records
Closing forms
Opening forms
Deleting a form

ACCESS 2007 QUERIES
What are queries?
Creating a simple 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
Deleting a query

ACCESS 2007 REPORTS
What are reports?
Creating a simple report
Using the Report Wizard
Modifying the layout of a report
Widening a report column
Modifying the report title
Adding logos to a report
Autoformating a report
Modifying field names within a report
Inserting and formatting the date & time
Adding available fields to a report
Resizing reports for printing
Closing a report
Deleting a report

ACCESS 2007 PRINTING ISSUES
Considerations before printing
Print previewing
Which orientation, portrait or landscape?
Adjusting layout in Print Preview
Setting margins
Printing a complete table
Printing selected records
Printing a query or reports
Printing forms


Level 2 Course Outline
WHAT’S NEW

New features in Access 2007
Database templates
Using local templates
Downloading templates
Enhanced Datasheet View
New Layout View
Improved Interface

SECURITY ISSUES & THE TRUST CENTER
Security warnings
Trusted Locations - Trust Centre
Setting the default folder location within Access

TABLES
MODIFYING FIELDS

Applying and modifying data types
Modifying column data types
Formatting Text data type
Formatting Memo data type
Examples of formatting a text box or memo
Formatting Hyperlink data type
Formatting Currency data type
Formatting Date/Time data type
Database object naming conventions
Data types
Converting between data types
Changing a field to a different data type

LOOKUP FIELDS
Creating and editing a lookup in a field or column
Creating a lookup from values in a table or query
Creating a lookup from values you type in

VALIDATION RULES
Creating a validation rule within a field

INPUT MASKS
Creating an input mask in a field

DEFAULT VALUES
Applying a default value to a field

MANDATORY FIELDS
Setting a required field

CREATING A TABLE
Creating a new table

RELATIONSHIPS
BASICS OF RELATIONSHIPS

Issues relating to creating valid relationships
Identifying a related table
Creating a relationship

Deleting a relationship
Creating a primary key and a composite key

TYPES OF JOINS IN A RELATIONSHIP
One-to-one
One-to-many
Many-to-many

CREATING RELATIONSHIPS
Creating a one-to-one relationship
Modifying one-to-one relationship
Creating a one-to-many relationship
Modifying one-to-many relationship
Creating many-to-many relationships

APPLYING INNER AND OUTER JOINS
Applying an inner join
Applying an outer join

APPLYING AND USING REFERENTIAL INTEGRITY
Setting referential integrity

APPLYING AUTOMATIC DELETION OF RELATED RECORDS
Setting cascading options

QUERIES
QUERY TYPES

Enabling the content
Creating and using a query to update data in a table
Populating data in the tables
Creating an Update Query
Creating and using a query to delete data within a table
Creating a Delete Query
Creating and using a query to save the selected information as a table
Creating a Make-Table Query
Appending records to a table using query
Creating an Append Query

GROUPING INFORMATION IN A QUERY
Using Aggregate Functions
Counting column values using the COUNT function
Summing column values using the SUM function
Averaging column values using the AVG function
Finding minimum column values using the MIN function
Finding maximum column values using the MAX function
Using a crosstab query

Creating a crosstab query
Creating a crosstab query using Crosstab Wizard

Using wildcards as parameters

USING ARITHMETIC OR LOGICAL EXPRESSIONS IN A QUERY
Creating an arithmetic calculation within a query
Creating a logical (condition based) expression within a query

REFINING A QUERY
Finding duplicates using the Find Duplicates Query Wizard
Finding unmatched values using the Find Unmatched Query Wizard
Finding the lowest range of values within a query
Finding the highest range of values within a query
Creating a parameter query
Finding Null values
Finding NOT values

FORMS
CREATING BOUND AND UNBOUND CONTROLS

Creating an unbound control
Creating a bound control

CREATING A COMBO BOX, LIST BOX, CHECK BOX & OPTION GROUPS
Creating a combo box
Creating a list box
Creating a check box
Creating an option button
Creating an option groupError! Bookmark not defined

CREATING ARITHMETIC / LOGICAL EXPRESSION CONTROLS
Creating an expression control
Creating an arithmetic expression control
Creating a logical expression control

CREATING A FORM USING THE FORM WIZARD
Creating a form with Form Wizard

SETTING SEQUENTIAL ORDER OF CONTROLS ON A FORM
Setting tab index for controls on a form

CREATING FORM HEADERS OR FOOTERS
Creating a form header and footer area
Numbering a form page

CREATING A SUBFORM AND LINKING TO THE MAIN FORM
Using a subform
Adding a subform to a form

MODIFYING THE SUBFORM TO CHANGE RECORDS DISPLAYED
Bringing a subtotal from a subform to a main form

REPORTS
CREATING ARITHMETIC / LOGICAL CALCULATION CONTROLS

Placing a control on a report
Creating an arithmetic expression control
Creating a logical expression control

USING FORMULAS AND EXPRESSIONS
Using common functions in a report
Using count and sum calculations within a report
Using sum min, max and average calculations within a report
Concatenating (combining) values within an expression

CREATING RUNNING SUMMARIES
Creating a report with running summaries

PRESENTATION
Creating page headers and footers
Creating report headers and footers
Grouping records on a report

FORCING PAGE BREAKS FOR GROUPS ON REPORTS
Forcing page breaks after each group of records

MACROS
Creating a new macro
Running a macro
Using the single step method to run a macro
Attaching a macro to a form control
Attaching a macro to a report control

IMPORTING, EXPORTING AND LINKING DATA
IMPORTING DATA

Importing from a text file

Importing from an Excel spreadsheet

Importing from a dBase file
Importing from a Paradox file

EXPORTING DATAERROR! BOOKMARK NOT DEFINED
Exporting data to a text file
Exporting data as an Excel spreadsheet file
Exporting data to a dBase file
Exporting data to a Paradox file
Linking external data to a database
Linking to an external text file Error! Bookmark not defined.
Linking to an Excel worksheet

Level 3 Course Outline
FORMS
FORM CUSTOMISATION

Linking a form to a table
Placing controls on the form
Aligning controls on a form
Sizing to fit controls on a form
Special effects
Setting tab order
Placing a bound control on the form
Placing a check box on the form
Placing a command button on the form
Placing a group box on the form
Placing a combo box on the form
Placing a list box on the form

TYPES OF FORMS
Popup forms
Modal forms
Split forms

LIMITING USER ACCESS
Limiting users from adding new records
Limiting users from deleting existing records
Limiting users from editing a records
EXPORTING FORM TO XML
Exporting to XML

REPORTS
Creating a report
Creating an AutoFormat template
Applying an AutoFormat to a report using the Report Wizard
Applying an AutoFormat to an existing report
Conditional formatting
Subreports
Formatting reports

ACCESS SWITCHBOARDS
What is a switchboard?
Creating a Switchboard
Adding a switchboard
Deleting a switchboard
Adding items to a Switchboard
Editing a Switchboard
Deleting items within a Switchboard
Editing items within a Switchboard
Making a Switchboard the default Switchboard
Displaying Switchboards automatically when opening a database

CUSTOMISING ACCESS
Access customization options
Current Database options
Datasheet options
Object Designers options
Proofing options
Customize options
Add-ins options

Previous Software Versions: MS Office XP, 2002, 2000, 2003

 
 

Contact Our Training Team


Name:
E-Mail:
Phone:
Country:
Message:
 
 
HOME   |   ABOUT US   |   GUARANTEES   |   SERVICES   |   ARTICLES   |   TESTIMONIALS   |   CONTACT US