Distance Computer Training Courses in Sydney at North Ryde, Word, Excel, Access, PowerPoint, Project, Visio, Outlook and MYOB

Home
  About Computer Train
  Public Courses
  Corporate Courses
  Distance Courses

 Microsoft Word
 Microsoft Excel
 Microsoft Access
 Microsoft Powerpoint
 Microsoft Project
 Microsoft Visio
 Microsoft Outlook
 MYOB
Enrol
  Free Resources
  Student Resources
  Self-Assessments
  Contact
 


Join our mailing list to receive regular articles and tips!
 
 

 

Microsoft Access Intermediate

About the Access 2003 Intermediate Course

The skills and knowledge covered in this course are sufficient to sort, filter and query data, to validate data prior to entry and to build a small menu system for the purpose of database management. It is primarily designed for people who wish to create a database.

  • Sort and filter data in a table
  • Format data in tables
  • Use a range of data validation techniques to protect data integrity
  • Export records from Access
  • Export records to HTML for use on the Web
  • Add parameters to queries to capture criteria data
  • Add calculated fields to queries
  • Create action queries to make tables, and update, append, and delete records
  • Understand table and query relationships and how they affect the integrity of your
  • Data
  • Protect your database files against unauthorised access
  • Use the Switchboard Manager to create a menu system.

 

 
 

Specific Learning Outcomes

Sorting & Filtering Table Data

  1. Simple Sorting
  2. Sorting on Several Fields
  3. Creating a Simple Filter
  4. Clearing a Filter
  5. Filtering by Exception
  6. Filtering by Form

Formatting Table Data

  1. Changing Column Widths
  2. Changing Column Headings
  3. Formatting the Data Sheet
  4. Changing Fonts
  5. Moving Columns
  6. Freezing Columns
  7. Hiding Columns
  8. Unhiding Columns

Data Validation

  1. Assigning Default Values
  2. Marking a Required Field
  3. Validation Rules and Text
  4. Creating a Lookup Field
  5. Working with Validations
  6. Exporting Records
  7. Copying a Table
  8. Exporting a Table to Microsoft Excel
  9. Exporting a Table to Text File
  10. Exporting a Filtered Table
  11. Exporting Selected Records
  12. Creating an Export Query
  13. Exporting From a Query

Exporting To HTML

  1. Exporting a Table to HTML
  2. Viewing an HTML Document
  3. Exporting a Report to HTML
  4. Creating Hyperlinks

Parameter Queries

  1. Creating a Parameter Query
  2. Displaying All Records
  3. Using Parameters to Display a Record Range
  4. Nominating Specific Data Types
  5. Using Parameters in Expressions

Calculated Fields

  1. Creating a Calculated Field
  2. Formatting Calculations
  3. Calculating Across Two Tables
  4. Calculating Dates
  5. Using Criteria in Calculations
  6. Concatenating String Fields

Action Queries

  1. Creating a Make Table Query
  2. Viewing a Table Created By a Make Table Query
  3. Expressions & Update Queries
  4. Preparing an Update Query
  5. Running an Update Query
  6. Creating a Saved Update Query
  7. Running a Saved Query
  8. Creating a Delete Query
  9. Creating an Append Query

Table & Query Relationships

  1. Understanding Join Types
  2. Using Default Joins
  3. Orphan Records
  4. Viewing Orphan Records
  5. Deleting Orphan Records
  6. Creating an Exception Query
  7. Viewing a Query in SQL

Database Protection

  1. Setting a Password
  2. Opening a File with a Password
  3. Removing a Password
  4. Encoding a Database File
  5. Decoding a Database File
  6. Hiding Database Objects
  7. Viewing & Unhiding an Object

Using the Switchboard

  1. Creating a Switchboard
  2. Creating Subsidiary Menus
  3. Creating a Menu Item
  4. Returning to Another Menu
  5. Creating a Number of Menu Items
  6. Linking the Menus
  7. Modifying the Menu Forms
  8. Changing the Startup

Printable Brochure
Self-Assessment Checklist
Request More Information

 

 

 

What's new?

Specials

order online

Make an enquiry

 

 


 

 

web design by Escala