Access Level 2

Course Description

Students will learn how to enhance database designs.

Course Content

Lesson 1: Relational databases
Database normalization
Table relationships
Referential integrity
Lesson 2: Related tables
Creating lookup fields
Modifying lookup fields
Subdatasheets
Lesson 3: Complex queries
Joining tables in queries
Using calculated fields
Summarizing and grouping values
Lesson 4: Advanced form design
Adding unbound controls
Graphics
Adding calculated values
Adding combo boxes
Advanced form types
Lesson 5: Reports and printing
Report formatting
Calculated values and subreports
Printing
Label printing
Lesson 6: Charts
Charts in forms
Charts in reports
Lesson 7: PivotTables and PivotCharts
PivotTables
Modifying PivotTables
PivotCharts
PivotTable forms

pdfPrintable course details

Prerequisites

Access Level 1 or equivalent knowledge.

Course Duration

7.5 hours

Study Methods Available

Individual Tuition
Group Training
Distance Learning


Prices

Distance Learning price
         £85
       Paypal logo
For other prices, please contact us.

Follow-on Courses

Access Level 3

All Courses

Click here to see all our courses.

Further Information

Enquiry Form
OCR
  Cisco

Sage

CompTIA logo

   BCS logo
ECDL logo
 MCP logo

     Adobe logo