Hello, Optima Training has detected that you are using an outdated version of Internet Explorer. If possible we strongly urge you to update your browser or switch over to Chrome or Firefox so you can enjoy the full user experience of our website and avail of all the features!
Close This Message'

Microsoft Access Intermediate

This Microsoft Access Intermediate training course is a 1 Day public programme, designed for anyone who wants to get the most out of Microsoft Access and is an entirely ‘hands on’ course which will give participants experience in producing database applications and the ability to create a variety of data views, queries and reports to more of an Intermediate Level.

Product Code:
MS6.2
Duration:
1 Day
Times:
09:30-16:30
Cost Includes:
Training course materials and after-training support
Contact Name:
Sinead Landers
Venue:
Limerick
Date:
X €190.00
Make an Enquiry
Attendee(s), if more than one seperate with a comma
Course Content
Intended Audience
Method Of Delivery
Reviews

Microsoft Access Intermediate 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 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

 

 

This Microsoft Access Intermediate training programme may be of interest to personnel who wish to gain a comprehensive overview of the Intermediate features of Microsoft Access.

Knowledge of Microsoft Access Basic is required.

Classroom based, instructor lead, practical hands on course with Computer / Laptop per person during the session

There are no reviews yet.

Be the first to review “Microsoft Access Intermediate”