© Copyright Ezee Computer Training 2010 Made by Wen Studio Integrating Main and Subform • How to create a form with two tables • How to create and modify a SubForm • How to create a switchboard • How to use error checking in forms • Applying themes in forms • How to create main form • How to integrate SubForm into main form • How to hide record navigator buttons in SubForm • How to hide selected information in SubForm • How to change SubForm size CREATING ADVANCED QUERIES Refining Queries • Refining a query using filter by selection • Refining a query using filter by form • Creating advanced filters • How to group and summaries records • How to create a custom calculation • How to create a crosstab query • How to create a parameter query Running Action Queries • How to run delete queries to remove records • How to run append queries to add records • How to run make table queries to create new tables • How to run update queries to change records content • Specifying multiple criteria • Modifying fields properties USING ADVANCED REPORT FEATURES Working With Report Sections • Parts of an access report • How to reorganize labels and controls in sections • How to insert report header and footer section • How to insert group header and footer sections Create a Report in Design View • How to create report from scratch • How to insert controls and labels into sections • How to customize the format of a control • How to insert page numbers • How to insert the current data and time • Printing a report • How to sort records in a report • How to group records in a report • How to add graphics to a report • How to modify properties for the entire report • How to modify properties for a section • How to modify properties for a control • How to insert analytical values to sections WORKING WITH DIFFERENT RELATIONSHIPS Using Relationships Effectively • Understanding relationships • One-to-one relationships • Many-to-many relationships • Defining relationships • Printing the relationships window • How to enforce referential integrity relationships in access • How to edit a relationship • How to use the cascade updates related fields • How to use the cascade delete related records Using Indexes • How to create a single-field index • How to create a multiple-field index Automating Database with Macros • How to create macros • How to run macro • How to insert button to run macro Macro Security • How to set macro security • How to enable macros Presenting Data in a Chart Creating Chart Report • How to create chart report using wizard • How to select chart type and layout CREATING AND MODIFYING ADVANCED TABLES Creating a Table • Selecting the appropriate data type for fields • Creating a table by using tables templates (2007) table wizard (2003) • Creating a table in design view • Defining a primary key • Saving a table • Changing views • Adding and deleting fields • Moving a field Setting Table Fields Properties • How to specify input length • How to set field size for numeric fields • How to set a validation rule • How to customize error messages • How to create and modify an input mask • How to create and modify a lookup field • How to display different text format • How to display different number or currency format • How to customize date/time display • How to propagate field properties • How to specify a default value • How to control field name display with caption • How to index field BACKING UP AND MAINTAINING A DATABASE Backing up a Database File • How to back up database Compacting and Repairing Database  • How to compact and repair database • How compact database automatically CREATING AND MODIFYING ADVANCED FORMS Creating User Friendly and Powerful Controls on a Form • What are controls? • Most commonly used controls • Types of controls Creating and Customizing Effective Forms • How to use form wizard • How to create a form in design view • How to show / hide toolbox • How to add controls using the toolbox • How to show / hide field list • How to add controls using fields • How to add titles • How to insert a picture to a form • How to customize sections • How to reposition controls and labels • How to resize a control • How to change control properties • How to create a calculated control • How to change form properties • How to separate control and label • How to delete a field control • How to select multiple controls • How to make form header/footer visible 519-473-1391 eMail