Main Pages

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