Microsoft Access 2000 Basic
Call Us at 317-881-3826
Or
Click here:
Lesson 1: Access 2000 Basic, Introduction – Databasics, Microsoft Access 2000 Overview, Conclusion
Lesson 2: Getting Started With Access 2000, Introduction - Installing The Northwind Database, Opening Access 2000, Opening An Existing Database, The Access Database Window, Viewing System Objects, New Menu Actions, Access 2000 Display Options, Hiding Objects, Database Window Open Options, View Options, Switching Views, The Objects Bar, The Details View, Object Selection, Opening An Object, Navigating Amongst Records, Adding Records In Datasheet View, Working With Fields, Sorting Records By Field, Switching Between Tables The OLE Object Field, Embedded Images, Inserting An Object Into A Table, Linking Or Embedding, Design View, A Queries Overview, Query Design View, Viewing Forms, Viewing Reports, Viewing Multiple Pages, The Multiple Pages Button, Form Design View, The Page Object, The Macro, The Module, Closing Access 2000, Conclusion
Lesson 3: Creating A New Database, Introduction - Creating a Desktop Shortcut, Creating A Blank Database, Filing Options, Access 2000 Options, Name AutoCorrect, Creating A New Table, Using The Table Wizard, Adding Fields, Renaming A Field, Removing Fields, Importing Data, The Link Text Wizard, Field Delimiters, Text Qualifiers, Import Or Link Data, Importing Text Files, Advanced Import Options, Saving Import Specifications, Saved Import\Link Specifications, Choosing A Primary Key, Naming The Table, Viewing Existing Tables, Print Preview, Printing Tables, Conclusion
Lesson 4: Working With Forms And Data, Introduction - The Microsoft Office Shortcut Bar, Customizing The Office Shortcut Bar, Customizing Toolbars And Menus, Modifying Button Appearance, Modifying Button Functions, Modifying Button Location, Modifying Menus, Toolbar Default Restoration, Importing Existing Tables, Database Relationships, Importing Existing Database Objects, Adding Table Relationships, Adding A Sub-datasheet, Using Autoform, Using The Form Wizard, Using The Access 2000 Find Feature, Find Options, Closing The Microsoft Office Shortcut Bar, Conclusion
Lesson 5: Simple Filters And Queries, Introduction, Creating A Selection Filter, Applying A Selection Filter, Using The Shortcut Menu Selection Filter, Removing Filters, Filtering By Exclusion, Using The Filter For Feature, Using Queries, The Simple Query Wizard, Viewing Multiple Objects Simultaneously, The Query Design Window, Hiding Fields In A Query, Adding A Field To A Query, Using A Numeric Expression In A Query, Conclusion
Lesson 6: Introduction To Reports And The Help System, Introduction - Creating A Tabular Report, Viewing Your Report, The Report Design View, Adding A Label To A Report, Creating A Text Box, Binding A Field To A Text Box, Grouping Fields In A Report, Formatting A Group Header, Creating Multiple Groups, Printing Your ReportGrouping Database Objects, Creating A New Group, Naming Your New Group, Adding Objects To A Group, Viewing A New Group, Help And The Show Me Feature, The Access 2000 Help System, Help's Contents And Index, The Help Answer Wizard, Helps Index Feature, The What's This Utility, The Office Assistant, Changing the Office Assistant, Conclusion