| Microsoft Access 2007 | ||
| Level: Introductory | Level: Advanced | |
| Duration: 2 Days | Duration: 2 Days | |
|
Delegates should be familiar with working in a Windows environment. Introduction To Databases• What is a Database• Database Terminology • Microsoft Access Environment • Getting Help • Wizards • Access Objects and Terminology Creating Access Tables• Creating a Database• Creating a Table • Setting a Primary Key • Modifying and Customising Tables • Using Lookups • Field Properties • Importing Tables • Linking Tables Adding & Entering Data• Viewing Data• Adding Records • Finding Records • Editing Data • Changing Datasheet Layout Relationships Between Tables• Types of Relationship• Creating Relationships • Relationship Options • Saving and Editing Relationships Forms• What is a Form• Creating a Form • Types of Forms • Creating Autoforms • Creating Subforms and Linked Forms • Using Forms Designing and Modifying Forms• Tools for Modifying Forms• Adding Controls • Selecting Controls • Formatting Controls • Moving & Resizing Controls • Aligning Controls • Using Properties Sorting & Filtering Data• Sorting Records• Filtering Records • Specifying Criteria • Limitations of Filters Querying a Database• What is a Query• What is a Dynaset • Creating Queries • Specifying Criteria • Multiple Criteria Multiple Table Queries• Using the simple Query WizardCalculations And Summaries• Calculated Fields• Summarising in Queries • AutoReports • The Report Wizard • Creating a Mailing Label Report • Printing a Report • Modifying Reports • Sections of a Report • Adding and Manipulating Controls • Adding Dates & Page Numbers • Adding Calculated Fields • Adding Summary Fields • Aligning Controls • Using Properties • Using Layout Preview Additional Items - Time Permitting• Database Wizard• Custom Formats • Input Masks • Expression Builder • Toolbars • Shortcut Menus |
Delegates should have completed an Introductory course prior to attending or have a good working knowledge of Access. Creating a Rational Model• Different Types of Links• Primary Keys and Foreign Keys • Primary Keys • Foreign (or Secondary) Keys • Setting up Indexes to Link Tables • Referential Integrity Advanced Forms Design• Creating Multi-Table Forms• Advantages of using Subforms • To add a Subform to a Main Form • To modify the Subform from within the Main Form Design • To check the link between the Main and Subforms • Calculated Fields • Expression Builder • Field Display Types • List Boxes And Combo Boxes • Option Fields • Option Group Advanced Queries• Table joins• Parameter Queries • Find Duplicates Queries • Find Unmatched Query Advanced Reporting• Reports based on Multiple Tables• Selecting records to print • Grouping and Sorting the Data • Adding Calculated Fields • Embedding Sub-Reports • Mail Merge with Word for Windows Performance and Database Design• Objectives when designing a Database• Database Design • Indexes and Keys • Creating an Index • Which Fields should be Indexed? • Multiple Field Indexes Events on Forms• Form Window Events• Keyboard Events • Data Events • Error and Timing Events • Focus Events • Mouse Events • Attaching Macros to Events Macros• What is a Macro?• Command Buttons • Grouping Macros • Passing Values between Forms • Using Conditions in Macros • Explanations of Conditions Custom Menus Using Menu Builder• To start the menu builder in a form or report• Create a Custom Menu Bar • Create the Edit Menu • Saving the Menu Bar • Duplicating a Menu Bar • Modify a Menu Item |
|
