IT Training Services

SJAC - IT Tuition, specialise in the Microsoft Office Suite of applications, Access, Excel, Outlook, PowerPoint and Word, providing, Individual Online Tuition with qualified tutors, for home users and corporate clients alike.

Click here for details on how to book a 1 Hour Online Individual Tuition Session

Sessions can be tailored to help our clients prepare for their Microsoft Office Specialist Certification. For more information on becoming a Microsoft Office Specialist click on the logo below.

Microsoft Office Specialist

Microsoft Access Microsoft Excel Microsoft Outlook Microsoft Powerpoint Microsoft Word

Microsoft Access

Microsoft Access Introduction Topics

Database Concepts
  • Database concepts and terminology
  • Exploring the Access environment
  • Planning and designing databases
  • Getting help
  • Closing a database and Access
Access Basics
  • Exploring tables
  • Examining queries
  • Exploring reports
Creating Databases
  • Creating a database
  • Using the table wizard
  • Working in design view
Working with Fields and Records
  • Changing the design of a table
  • Adding and deleting records
  • Finding and editing records
  • Sorting and filtering records Querying Tables
Creating and using queries
  • Modifying query results and queries
  • Using calculations in queries
Creating and Using Forms
  • Creating forms by using AutoForm
  • Using the form wizard
  • Using design view
  • Finding, sorting and filtering records
Creating and Using Reports
  • Using the report wizard and queries
  • Creating, modifying and printing reports
Importing, Exporting and Linking Objects
  • Importing Access objects
  • Exporting Access objects
  • Linking Access objects

Microsoft Access Intermediate Topics

Creating relational databases
  • Database normalising
  • Introducing relating tables
  • Adding referential integrity
Working with related tables
  • The lookup wizard
  • Changing lookup fields
  • Inputting data to related tables
Defining data entry rules
  • Using input masks
  • Setting a property
  • Setting a validation rule
Using advanced query features
  • How to join a table in queries
  • Creating a calculated field
  • Using an action query
Creating advanced queries
  • Summarise and group values
  • Create a crosstab query
  • Using a parameter query
Creating advanced form design
  • Working with graphics
  • Working with calculations
  • Working with combo boxes
  • Working with unbound controls
Using advanced report features
  • Create customized headers and footers
  • Add a calculated value
  • Work with sub-reports

Microsoft Access Advanced Topics

PivotTables and PivotCharts
  • Create a PivotTable
  • Modify a PivotTable
  • Working with a PivotChart
Creating Advanced Forms
  • Designing a form based on joined tables
  • Automating data entry
  • Grouped control
  • How to improve the user interface
  • Designing subforms
Macros
  • Create and run macros
  • Attach macros to events of database objects
Creating Advanced Macros
  • Create macros to provide user interaction
  • Create macros requiring user decision
  • Use AutoKeys and AutoExec macros
Exploring Access SQL
  • How to identify different clauses in an SQL statement
  • Writing SQL statements
  • Attach an SQL statement to database objects
Integrating the Internet
  • Work with hyperlink fields
  • Work with data access pages
Managing Databases
  • Work with database utilities to optimise resources
  • Secure data by database replication
Security Fundamentals
Protect databases

Contact us

If you would like to find out more about SJAC - IT Tuition, please contact us.

*

*



*

1 Hour Individual Online Tuition - £50.00