|
Access 2003 Advanced (E457) |
an eWord company |
|
Microsoft Office courses are conducted using 2003, however these courses are suitable for users of versions 2000 and XP/2002. |
_files/image001.jpg)
|
General Course Information In this 2 day program, participants will gain the knowledge and skills to allow them to understand and to utilise the more advanced features in Access.
You will learn to Ø Create Action Queries and Use Query Wizards Ø Import and export data Ø Compact a database Ø Manipulate form controls and set the tab order Ø Use reports in Design View, create a calculated control and group data in a report Ø Create and edit subforms and subreports Ø Create a Pivot Table or Pivot Chart Ø Work with single and multiple field indexes Ø Replicate databases Ø Create and use Macros Ø Create and use Switchboards Ø Create custom toolbars
What skills you need A sound working knowledge of the topics covered in the Access Introduction course is assumed. Attendees should be able to work with tables and simple forms.
Electus training Electus is a South Australian company with 25 years of experience in training. Trainers and facilitators at Electus are chosen for their expertise, practical and broad experience in their field and a relaxed and friendly manner.
Training includes Each participant receives a training reference manual/workbook and supplementary training materials. Refreshments and lunch are provided.
|
|
Duration 2 days 9:00am-4:15pm
Who needs to come Anyone who is familiar with the fundamentals of Microsoft Access, and who wants to extend their knowledge of forms and controls.
Nationally Recognised Qualification You can choose to have this course assessed towards a unit of competency for a nationally recognised qualification.
Regular venue 37 Angas Street Adelaide SA (near Victoria Square)
How to book Contact Electus by
Course dates Visit www.electus.com.au for the latest course schedule or ring us on (08) 8221 5517.
|
Course Content
|
Creating Action Queries · Creating a Make-table Query · Creating an Update Query · Creating an Append Query · Creating a Delete Query Using Advanced Query Wizards · Crosstab Query Wizard · Find Duplicates and Find Unmatched Query Wizard Using Advanced Database Features · Importing & Exporting Data · Linking Data to an Access Table · Using the Linked Table Manager · Converting Files · Printing a Relationship Document · Creating a Data Access Page - Page Wizard · Compacting a Database · Using Name AutoCorrect · Using Object Dependencies · Backing Up a Database Manipulating Controls · Using Controls · Selecting Non-adjacent Controls and Adjacent Controls · Deleting, Sizing and Moving Controls · Sizing Controls Automatically · Viewing the Properties of an Object · Changing a Control Property Using Advanced Form Design · Using Forms in Design View · Creating a Combo Box, a List Box and an Option Group · Adding a Logic Control · Setting the Tab Order Automatically and Manually · Adding a Form Header and Footer · Creating a Blank Form |
Using Advanced Report Design · Adding Report Sections in Design View · Creating a Calculated Control · Grouping Data in a Report · Creating Group Headers and Footers · Creating a Running Summary · Inserting a Date/Time Control · Inserting a Page Break · Changing the Report Margins · Using the Label Wizard · Creating a Report without using a Wizard Using Editing Tools · Selecting Objects with the Toolbar · Changing the Font, Character Format, Font Colour, Fill and Background Colours · Formatting Lines and Borders · Applying Special Effects · Using AutoFormat · Using Error Checking · Using Smart Tags · Setting AutoCorrect Options Using Subforms/Subreports · Creating a Subform/Subreport · Editing the Layout of a Subform · Displaying a Subform in Datasheet View · Displaying a Subform/Subreport Total Using Other Form Techniques · Adding a Command Button · Saving a Form as a Report · Creating a PivotTable or PivotChart View Working with Indexes · Viewing Indexes · Creating a Single Field Index · Creating a Multiple Field Index · Deleting an Index · Creating a Multiple Field Primary Key |
Creating Macros · Opening the Macro Design Window · Creating a Macro · Assigning an Argument to an Action · Saving a Macro · Using Single Step Mode for Testing · Running a Macro · Editing an Existing Macro · Running a Macro using the Tools Menu · Creating a Macro using the Macro Builder Using Macros · Using Properties · Assigning a Macro to a Control · Creating a Command Button · Adding a Condition to a Macro · Creating a Group Macro · Creating an Autoexec Macro Using Switchboards · Opening and using a Switchboard · Creating a Switchboard Form · Adding a Command Button to a Switchboard · Setting Startup Options · Switchboard Manager Creating Custom Toolbars · Creating a Custom Toolbar · Adding a Built-in Menu Item · Creating a Custom Menu Item · Adding a Command to a Menu Item · Adding Custom Commands · Docking a Floating Toolbar · Linking a Toolbar to a Report · Adding a Separator Bar · Creating a Shortcut Menu · Linking a Custom Shortcut Menu · Adding Buttons to a Custom Toolbar · Changing a Button Image · Deleting a Custom Toolbar |