MS Access Level 3
Sponsored links
Must have attended Access Level 1-2, or be confident with what tables, queries, forms and reports are, as well as create each object manually.
You learn about some maintenance features in Access, along with getting an introduction to SQL (Structured Query Language), a look at some other Query types and options, and create forms from scratch. You also look at exporting Reports.
| Delivery: |
|
| Regions: |
|
| Category: |
Further Details
Tables
· Backing up tables
· Copying tables
· Fixing a table without a Primary Key
Introduction to SQL
· Understanding the SQL behind queries
· The SQL Structure
· Creating a Union Query
Queries
· Crosstab Queries
· Select Top 5 Records
· Using Date/Time functions
· Using Maths Functions
· Using Text Functions
Forms
· Creating from scratch
· Using Combo Boxes and List Boxes
· Changing the source of a text box
· Adding in a company logo
· Creating a SubForm
· Creating a form with two Subforms
· Creating nested Subforms
· Deleing a Subform
Reports
· Creating a subreport
· Exporting a report to Snapshot
· Exporting a report to Excel
Database Maintenance
· Compacting a database
· Converting to a different Access version
· Setting a database password
This Training Course is taught in classrooms in the following locations:
London SE
Information provided is for information purposes only and no guarantees are made with regards to accuracy. It is advised that all details are checked prior to making a booking. Contents © 1999 - 2012. All rights reserved.
