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


Access Level 2

or equivalent knowledge.

Course Duration

7.5 hours

Study Methods Available

Individual Tuition

Group Training

Distance Learning


Distance Learning price
  Paypal logo  

For other prices, please contact us.

Follow-on Courses


All Courses

Click here to see all our courses.

Further Information

Enquiry Form



CompTIA logo

   BCS logo
ECDL logo
 MCP logo

     Adobe logo