Ms -Access 2003

Session	Subject	Syllabus
1	About this course	Welcome Introduction and objectives Getting help with the course How the course is structured About the model database About the exercises About Course Project Summary
2	Introducing Microsoft Access	Objectives Overview Understanding databases Starting Access Opening a database Understanding the Access window The parts of a database Saving and closing a database Getting help on Access Exiting Microsoft Access Exercise Review questions Summary
3	Using Tables	Objectives Overview Introducing Access tables Opening a table Viewing tables Navigating around tables Navigating with the keyboard Adding new records Editing records Deleting records Copying and pasting data Using the Zoom box Checking your spelling Printing tables Finding and replacing information Sorting records Filtering records Filtering by Form Exercise Review questions Summary
4	Formatting Tables	Objectives Overview Resizing columns and rows Moving columns Hiding and showing columns Freezing and unfreezing columns Changing the font Changing cell effects Exercise Review questions Summary
5	Using Queries	Objectives Overview Introducing Access queries Running a query Viewing queries Formatting queries Printing query results Exercise Review questions Summary
6	Using Forms	Objectives Overview Introducing Access forms Opening a form Viewing forms Navigating records Adding new records Modifying records Deleting records Printing records Exercise Review questions Summary
7	Using reports	Objectives Overview Introducing Access Reports Opening a report Viewing reports Printing reports Exercise Review questions Summary
8	Using switchboards	Objectives Overview Introducing Access Switchboards Using switchboards Exercise Review questions Summary
9	Module Summary	Final Examination Project Evaluation Your quiz score Good luck

Session	Subject	Syllabus
1	Creating Databases	Objectives Overview Planning a database Designing a database Using the Database Wizard Creating a blank database Using the Table Wizard Working in Design View Understanding Data Types Changing a field's Data Type Exercise Review questions About Course Project Summary
2	Creating Tables	Objectives Overview Adding new tables from scratch Indexing fields in a table Adding a primary key to a table Saving the table design Changing the table design Exercise Review questions Summary
3	Working with Fields	Objectives Overview Understanding field properties Setting field descriptions Adding field captions Changing field sizes Formatting text and memo fields Formatting number/currency fields Formatting date/time fields Formatting Yes/No fields Setting a default value Making a field required Automating data validation Setting an input mask Allowing zero length data entry Handling data integrity violations Exercise Review questions Summary
4	Creating Lookup Fields	Objectives Overview Introducing Lookup Fields Creating a value list Creating a lookup list Modifying lookup fields Using key-less tables Exercise Review questions Summary
5	Creating Queries	Objectives Overview Using the Simple Query Wizard Creating a simple query Running a query Saving and closing a query Modifying a query Adding criteria to a query Using numbers, dates and wildcards Adding multiple criteria Sorting queries Hiding and showing fields Exercise Review questions Summary
6	Creating Forms	Objectives Overview Creating forms with AutoForm Using the Form Wizard Modifying form design Selecting controls and labels Adding and deleting fields Moving labels and controls Resizing labels and controls Aligning labels and controls Spacing labels and controls Using the grid Changing the field tab order Exercise Review questions Summary
7	Creating Reports	Objectives Overview Creating reports with AutoReport Using the Report Wizard Modifying report design Selecting controls and labels Adding and deleting fields Moving labels and controls Resizing labels and controls Aligning labels and controls Spacing labels and controls Using the grid Adjusting page layout Adjusting page numbers Adding the date and time Creating mailing labels Exercise Review questions Summary
8	Formatting Forms and Reports	Objectives Overview Applying an AutoFormat Formatting with fonts Formatting with colour Changing text alignment Applying special effects Adding pictures Drawing lines Exercise Review questions Summary
9	Creating Switchboards	Objectives Overview Creating a switchboard Invoking a switchboard Customising a switchboard Exercise Review questions Summary
10	Module Summary	Final Examination Project Evaluation Your quiz score Good luck

Session	Subject	Syllabus
1	Creating Relational Databases	Objectives Overview Designing a relational database Understanding relationships Creating a One-to-Many relationship Enforcing referential integrity Creating a Many-to-Many relationship Creating a One-to-One relationship Editing a relationship Deleting a relationship Printing the relationship layout Troubleshooting common mistakes Exercise Review questions About Course Project Summary
2	Creating Advanced Queries	Objectives Overview Understanding query types Adding filters to queries Filtering by Form Creating multiple-table queries Manually joining tables Creating totals in queries Creating calculated fields Displaying top and bottom values Using the Expression Builder Using the IIF function Creating Parameter queries Creating Crosstab queries Finding duplicate records Finding unmatched records Creating tables with queries Deleting records with queries Appending records to tables Updating records with queries Exercise Review questions Summary
3	Creating Advanced Forms	Objectives Overview Understanding controls Changing form properties Creating combo boxes Limiting combo box choices Amending column widths Creating command buttons Using command buttons to link forms Changing a control's data source Creating calculations in forms Creating One-to-Many sub-forms Modifying sub-forms Using sub-forms Creating Many-to-Many sub-forms Creating One-to-One sub-forms Exercise Review questions Summary
4	Creating Advanced Reports	Objectives Overview Sorting and grouping records Creating and using calculations Creating multiple-table reports Creating charts on reports Exercise Review questions Summary
5	Advanced Formatting	Objectives Overview Adjusting lines in forms and reports Adjusting section properties Formatting control properties Inserting pictures on forms and reports Adding pictures to the background Adding picture fields to tables Exercise Review questions Summary
6	Working with Macros	Objectives Overview Creating a macro Running a macro Editing a macro Attaching a macro to a button Attaching a macro to keystrokes Making macro actions conditional Exercise Review questions Summary
7	Using Access with Other Programs	Objectives Overview Importing information from text files Importing information from Access Importing information from Excel Linking information to Excel Exporting information to text files Exporting information to Access Exporting information to Excel Analysing information in Excel Exporting information to Word Mail merging with Word Exercise Review questions Summary
8	Working with the Internet	Objectives Overview Introducing Internet options Creating and using hyperlinks Publishing to the Web Creating data access pages Previewing data access pages Using data access pages Changing data access page design Creating PivotTables on pages Exercise Review questions Summary
9	Managing Your Databases	Objectives Overview Converting Access databases Backing up and restoring databases Compacting and repairing databases Setting and deleting a password Exercise Review questions Summary
10	Module Summary	Final Examination Project Evaluation Your quiz score Good luck