Access Level 3

Course Description

Students will learn how to use a variety of complex database techniques.

Course Content

Lesson 1: Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls
Lesson 2: Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries
Lesson 3: Macros
Creating, running, and modifying macros
Attaching macros to the events of database objects
Lesson 4: Advanced macros
Creating macros to provide user interaction
Creating macros that require user input
Creating the AutoKeys and AutoExec macros
Creating macros for data transfer
Lesson 5: Importing, exporting, and linking objects
Importing objects
Exporting objects
Working with XML documents
Linking Access objects
Using hyperlink fields
Lesson 6: Database management
Optimizing resources
Protecting databases
Setting options and properties

pdfPrintable course details

Prerequisites

Access Level 2 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

ECDL

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