Home   Technology Courses   Management Courses   Certification   MyHistory  Course Schedule   Free Catalog   About Us   What's New   Contest   Contact Us Photo Galary

Microsoft Access 2003 Courseware Advanced Level 1. WORKING WITH THE NORTHWIND SAMPLE DATABASE About Northwind Checking for Northwind Installing Northwind 2. INTRODUCING STRUCTURED QUERY LANGUAGE Structured Query Language (SQL) Bases Understanding SQL Statements Understanding SQL Conventions Understanding SQL Syntax Using SELECT Statement Selecting All Data Selecting Specific Data Selecting Conditional Data Using ORDER BY Statement Sorting Data Using Aggregate Functions Calculating Data Using GROUP BY Statement Grouping Data Creating a Subquery with Equality Creating a Subquery with an Aggregate Function Using ANY and ALL Statements Understanding SQL Joins Creating a Simple Join Sorting a Join Creating Outer Joins Creating Left Outer Joins Creating Right Outer Joins Creating Full Outer Joins Using INSERT Statement Understanding INSERT Statement Rules Inserting Data using VALUES Inserting Data using Defaults Inserting Data using SELECT Using UPDATE Statement Updating All Rows Updating Specific Rows Updating Multiple Columns Using DELETE FROM Statement Deleting Specific Rows Deleting All Rows Viewing SQL in Access 2003 Understanding SQL in Access 2003 Writing SQL Specific Queries Finding Help on SQL Queries 3. WORKING WITH MACROS Understanding Macros Using the Macro Window Toolbar CREATING MACROS Creating New Macros Running a Macro Stepping Through a Macro Modifying a Macro Adding Conditions to Macros Using the Expression Builder to create Conditions Running Macros with Conditions Attaching Macros to a Form Attaching Macros to a Report Filtering Records Commenting Macros Printing Macro Definitions Viewing Macro Definitions 4. PROGRAMMING ACCESS USING VISUAL BASIC Using Visual Basic Modules Converting Macros to Visual Basic Code Understanding Modules Creating Modules Understanding Module Declarations Understanding Procedures Using Naming Rules Declaring Variables Setting Variable Scope Declaring Constants Using Methods Using Arguments Customizing the Visual Basic Editor Window Setting the Visual Basic Editor Options Using Microsoft Visual Basic Help Getting Visual Basic Syntax Help 5. USING DATA ACCESS PAGES Using Data Access Pages Creating pages using the AutoPage Creating pages using the Page Wizard Creating pages using an Existing HTML Document Creating pages using the Design View Choosing a Theme Adding Text Adding Controls Formatting Text and Labels Aligning Content Sizing Content Adding Images Adding Backgrounds Sorting Data Summarizing Data Adding a New Record Deleting a Record Customizing Navigation Bar Protecting Fields 6. CONVERTING ACCESS DATABASES Converting Databases Converting Database Objects Enabling Databases Sharing Databases across various Access versions Converting Access 2003 database to Access 97 database Converting Access 2003 database to Access 2000 database 7. CUSTOMIZING ACCESS 2003 Setting Access 2003 Options Setting View Options Setting General Options Setting Edit/Find Options Setting Keyboard Options Setting Datasheet Options Setting Forms/Reports Options Setting Pages Options Setting Advanced Options Setting International Options Setting Spelling Options Setting Tables/Queries Options Setting AutoCorrect Options Excluding AutoCorrect Rules Removing AutoCorrect Rules Adding Replace AutoCorrect Rules Removing Replace AutoCorrect Rules Opening Customize Dialog Box Customizing Toolbars Creating Custom Toolbars Removing Toolbars Customizing Commands Adding Buttons to Toolbars Removing Buttons from Toolbars Customizing Options 8. ANALYZING ACCESS DATABASES Using the Table Analyzer Renaming Tables Adding Key Fields Using the Performance Analyzer Using the Documenter Analyzer Printing Documentation Exporting Documentation

Copyright ©2008, www.galaxy.ps

Designed By: Mohammed Fuqaha