Trainingwarehouse
  • View Cart
  • Checkout
  • Items Ordered:, Cart Value:

Trainingwarehouse | Courseware | IT Series | Access | Access 2003 |  Access 2003 Advanced

Trainingwarehouse > Courseware >  IT Series >  Access >  Access 2003 > Access 2003 Advanced

Access 2003 Advanced in colour Ref: AS23AV

Days of training: 1
Prerequisites: Access 2003: Intermediate or equivalent experience

Querying with SQL
SQL and Access
Writing SQL statements
Attaching SQL queries to controls

Advanced queries
Creating crosstab queries
Creating parameter queries
Using action queries

Macros
Creating, running, and modifying macros
Attaching macros to the events of database objects

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

Importing, exporting, and linking objects
Importing objects
Exporting objects
Interacting with the XML documents
Linking Access objects
Working with Windows SharePoint Services

Database management
Optimizing resources
Replicating and synchronizing databases

Security fundamentals
Protecting databases
Encrypting and decrypting databases
User-level security

Appendix A : Microsoft Office Specialist exam objectives map
Comprehensive exam objectives
 





Access 2003 Advanced Instructor Manual in colour Ref: TIAS23AV
 


Price: £19.95 (Excluding VAT at 20%)


Quantity:  


Access 2003 Advanced Student Manual in colour Ref: TMAS23AV
 


Price: (4 or fewer items) £16.95 (Excluding VAT at 20%)
Price: (5 to 19 items) £15.26 (Excluding VAT at 20%)
Price: (20 or more items) £13.56 (Excluding VAT at 20%)


Quantity:  


Access 2003 Advanced A5 Student Manual in colour Ref: T5AS23AV
 


Price: (7 or fewer items) £11.95 (Excluding VAT at 20%)
Price: (8 to 19 items) £10.76 (Excluding VAT at 20%)
Price: (20 or more items) £9.56 (Excluding VAT at 20%)


Quantity:  

Trainingwarehouse > Courseware >  IT Series >  Access >  Access 2003 > Access 2003 Advanced