STANDARD COURSES Access Introduction Intermediate VBA ACT! Dreamweaver Excel Flash FrontPage Illustrator InDesign Office 2007 Outlook Photoshop Powerpoint Project Soft Skills Technical Skills Visio Windows Vista Word Course Fees	ACCESS INTRODUCTION Duration: 2 days Versions Available: 97, 2000, XP, 2003, 2007, 2010 COURSE OUTLINE     Introduction Designing a Database Starting Access The office assistant Creating a new file Saving a file What is a database? Terminology Navigating the screen Opening a file Importing from Microsoft Word or Excel Quitting from Access Tables Creating a table Entering data Highlighting areas of the table Adjusting field widths and heights Design view Inserting and deleting fields Inserting and deleting records Using the new object button Freezing columns Moving and copying Undo Deleting a table Sorting & Filtering Using find Sorting Filtering data Forms Creating a form Using AutoForm Using design view Deleting a form Command buttons Relationships Showing relationships Datasheets Creating subforms Queries What is a query Select queries Multi-table queries Calculations in queries Parameter queries Action queries Reports Using AutoReport Creating a report using the wizard Changing a report in design view Previewing a report Additional Features Exporting information to Word and Excel Database properties Compact and repair database Database security Changing the database view ACCESS INTERMEDIATE Duration: 2 days Versions Available: 97, 2000, XP, 2003, 2007, 2010 COURSE OUTLINE     Refreshing the basics Database relationships Referential integrity Designing userforms and reports Advanced form design Main and SubForms Multiple instances of subform Calculations in forms Form properties Modal forms Popup forms Selecting data with combo boxes Filtering from combo boxes Running queries from forms Queries Calculations in queries Action queries Union queries Reports Advanced report design Using visual basic to customise reports Macros Macro actions Group macros Conditional macros Assigning macros to toolbars and menus Introduction to Visual Basic Event properties Functions Methods Properties Macro actions in VBA ACCESS VBA Duration: 2 days Versions Available: 97, 2000, XP, 2003, 2007, 2010 COURSE OUTLINE     Introduction What is Access Basic? Event driven procedures Modules and code behind forms Choosing macros or Access Basic Creating modules What is a module? Declarations section Sub and function procedures The module window The module toolbar Edit and navigation keys Managing modules and procedures Global modules and code behind forms Creating procedures Naming rules and conventions Incorporating macro actions Using the express builder Built-in functions User defined functions Function arguments Returning values from functions Using user defined functions in queries and forms Event procedures The code builder Referring to form and report controls Event sequences Constants and Variables Declaring constants Declaring variables, arrays and data types Scope of variables Scope of procedures Programming Structures Branching and looping Debugging Access Basic Types of error Compiling Access Basic Setting break points Stepping into and over Using the immediate window Error handling On error statement Trapping error codes Reporting errors Using database objects Objects and collections Setting object variables Handling record sets Adding and editing data Handling and running queries Developing applications Event driven code Using unbound forms Setting properties and values on forms and reports Setting configuration options from code Linking Access Basic and Macros Creating Add in Libraries Configuring an add in Restrictions and requirements		"We appreciate all your efforts in helping with the relocation to Northampton and making the training of new recruits a success. We formally recognise your unique contribution which has spanned training, information technology and human resources". Andrew Scarborough, Commercial Director.