© Copyright Ezee Computer Training 2010 Made by Wen Studio CREATING RELATIONSHIPS BETTEWEN TABLES Managing Relationships • How to set primary key • How to create a foreign key • How to create table relationships • One-to-many relationship • How to specify referential integrity • Printing database relationships • Creating additional relationships • How to edit a relationship • How to delete a relationship • How to display related records in a sub- datasheet CHEQUING SPELLING AND GETTING HELP Spelling Check • How to use the spelling check Searching Records • How to search help • How to use content help CREATING AND CUSTOMISING QUERIES Designing a Query • Creating a query in design view • Adding tables to the design query window • Saving a query • Establishing query criteria • How to create a multiple related tables query • Sorting fields in a query Create a Query by Using the Wizard • Using the simple query wizard • Selecting the table source • Selecting fields Controlling Queries Output • How to open / switch query to design view • How to rearrange fields • How to delete a field • How to add a field • How to sort the query output • How to filter the query output with criteria • How to set multiple criteria • How to hide a field • Changing query column headings • How to create a calculated field • How to design queries with aggregate functions Creating Special Queries • How to create a crosstab queries • How to create a find duplicates query • How to create an unmatched query Filtering Data • How to filter records by selection • How to filter records by form CREATING AND CUSTOMISING FORMS Creating Forms by Using AutoForm and Wizard  • How to create a form using the form wizard • How to save and rename form • How to sort records using a form • How to print a form • Adding and deleting records using a form • How to create a form from related tables Creating a Form in Design View  • How to open the form design view • How to show / hide field list • How to show / hide toolbox • Displaying form properties • How to use fields to add controls • How to move both control and label • How to move control and label separately • How to resize controls • How to format controls • How to align controls • How to delete a field control • Adding a form header and footer • Adding a calculated control CREATING USEFUL REPORTS Creating Reports  • How to create a report by using wizard • How to prepare a report based on two tables • How to create a report in design view • How to display report properties • Using fields to add controls • Moving control objects • Resizing control objects • Formatting control objects • Adding controls using the toolbox • How to add a header and footer • How to create mailing labels • How to set page margin • How to create a chart by using the wizard • Using PivotTable and PivotChart views • How to change page orientation • How to number pages IMPORTING AND EXPORTING DATA Exporting • Exporting data to excel • Exporting data to word • Merging data with a word document Importing • Importing data to a new table • Linking data to a new table • The Office Clipboard • Using the office clipboard GETTING STARTED Designing a Database Table • Determining current and future needs • Organizing data • Determining fields names • Assigning a data type to fields • How to start access Getting Familiar with the Access Screen  • Identifying parts of the access screen • How to use the menus • Working with the Ribbon (2007) or toolbars (2003) • How to create a new blank database • The database window • The database objects • How to use shortcut menu using right mouse click • How to use shortcut key WORKING WITH TABLES Creating a Table in Design View • How to create a new table • The table window • How to change field size • How to assign field names • How to assign data types • How to save a table Printing • Printing a table • Changing margins • Changing page orientation Opening and Closing a Database File • How to open a database • How to close a database • How to exit access Managing Data • Opening a table • Entering data in a table • How to change field width • How to add and delete records • How to edit records • How to delete a few records • How to navigate through records • How to move to a specific record Changing Views • How to switch to design view • How to switch to datasheet view Customising Tables • How to add field • How to delete field • How to rearrange fields • How to use the input mask wizard • How to use the lookup wizard Sorting Records • How To Sort Records In Ascending Order • How To Sort Records In Descending Order Searching Records • How to find records • How to replace records 519-473-1391 eMail