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
Guide price
£150 |
