Main Pages

Trainingwarehouse > Courseware > IT Series > Access > Access 2003 > Access 2003 Level 2

Access 2003 Level 2 Student Manual Ref: CMAS23E2 This Office 2003 courseware is presented through 2 series, Express and Standard. They both cover the same course content, differing only in the number of exercises at the end of each module and section. Full pricing details are at the bottom of this page. Course Objectives The main objective of this courseware is to enhance your ability to create and use Access databases. You will advance your skills in designing queries, forms and reports, get an introduction to the creation of macros and Visual Basic program modules, and explore ways in which to make your databases work more efficiently. This courseware is designed for the student who is already able to create and use simple Access databases and wishes to learn to develop a fully functional database management system. On successful completion of this courseware, you will be able to: use advanced field properties work with multiple tables create and use Action Queries and other specialized queries add bound and unbound controls to forms and reports create and use subforms and subreports create command buttons and define control events create a switchboard add hyperlinks to database objects save database objects as web pages create and use simple macros create and use simple Visual Basic modules add security features to your database use analysis tools improve database performance Basic Skills Checklist The following list summarizes skills that students should be comfortable with for this courseware. start and run Access 2003 use a mouse to select from menus, toolbars, prompts and screens create a database from scratch or with the Database Wizard create a table form scratch or with the Database Wizard* enter and edit data in a table sort and find information in a table filter records in a table establish relationships between tables create and use forms exit and save your work session Courseware Outline Advanced Table Design Advanced Field Properties Using Input Masks Using Validation Rules Default Values and Required Fields Indexed Fields Using Lookup Fields Entering Lookup Data Manually Using the Lookup Wizard Linking Tables Advanced Queries Select Queries from Multiple Tables Inner and Outer Joins Unmatched Queries Specialized Select Queries Parameter Queries Unique Queries Duplicate Queries Summary Queries Total Queries Crosstab Queries Action Queries Make Table Queries Delete Queries Append Queries Update Queries Queries from Filters Advanced Forms, Reports and Pages Features of Forms & Reports Working with Sections Creating Forms & Reports from Scratch Creating a Form in Design View Creating a Report in Design View Working with Properties Using the Property Sheet Format Tab Data Tab Other Tab Using Unbound & Bound Controls Applying Images Using List Boxes and Combo Boxes Using Check Boxes Using Option Groups Creating Subforms & Subreports Creating a Subform with the Form Wizard Using the Subform/Subreport Tool Dragging & Dropping Subforms Publishing to the Web Exporting to HTML Data Access Pages Advanced Controls Charting Data Creating a Freestanding Chart Embedding a Chart Using Command Buttons Record Navigation and Operation Opening Another Form Creating a Switchboard Switchboard Display Options Internet & Programming Looking at Internet Tools Using Hyperlinks Adding a Web Browser Control Publishing Data on the Internet Exporting to Static HTML Exporting to an XML File Importing an XML File Dynamic Data Access Pages Grouping and Sorting with Pages Creating a Page with a Pivot Table Introducing Macros Introducing Visual Basic Event Procedures Security & Database Tools Database Security Database Passwords Workgroup Security Encrypting and Decrypting Databases Converting the Database to MDE Setting Database Options Access Options Startup Options Database Administration Improving Database Performance Database Splitter Linked Table Manager Database Replication Converting to Previous Version of Access Appendices Productivity Tools Glossary of Terms The Express Series targets classes of 6-8 hours duration. There are hands-on, step-by step exercises that guide students through procedures and commands. These are presented immediately following a topic explanation and provide basic instructions on the most productive method of using a feature. At the end of each module there is an exercise which covers more than feature within a module. At the end of each section there is a hands-on, extended exercise requiring the student to work independently and apply their knowledge of the features learned in the section to accomplish a particular task. Each of these exercises is rated with a difficulty level, based on skill competence. Access 2003 Express Level 2 Price: (4 or fewer items) £9.95 (Excluding VAT at 20%) Price: (5 or more items) £8.96 (Excluding VAT at 20%)		Quantity:

Access 2003 Express Level 2 - A5 format student manual Ref: C5AS23E2 These books are full student manuals scaled down to A5 format. They could be used as desktop companions or for students to take home after a training course as a reference guide. Price: (7 or fewer items) £7.95 (Excluding VAT at 20%) Price: (8 or more items) £7.16 (Excluding VAT at 20%)		Quantity:

Trainingwarehouse > Courseware > IT Series > Access > Access 2003 > Access 2003 Level 2