tag:blogger.com,1999:blog-1160358050898484933Sun, 05 Oct 2014 00:53:50 +0000BasicsCommandsMenuDatabaseDiagramEditFileFilterFormatHelpInsertPivotChartPivotTableQueryRecordsRelationshipsRunToolsViewWindowBlog has Microsoft Office Access 2007 2003 2002 2000 97 database macros VBA code functions basics shortcuts examples tutorials tips trickshttp://funwithaccess.blogspot.com/noreply@blogger.com (Sri Sri)Blogger1713tag:blogger.com,1999:blog-1160358050898484933.post-7077770707122652649Wed, 03 Jun 2009 13:00:00 +00002009-06-03T06:00:00.572-07:00BasicsCommandsHelpMenu<table><tbody><tr bgcolor="SkyBlue"><th> Access 2003 Location </th><th> Access 2007 Location </th></tr><tr bgcolor="WhiteSmoke"><td> Help </td><td> Click a question mark or Help button whenever Access provides one. </td></tr><tr bgcolor="Gainsboro"><td> Microsoft Office Access Help </td><td> Help </td></tr><tr bgcolor="WhiteSmoke"><td> Microsoft Office Access Help </td><td> Microsoft Office ButtonAccess Options | Customization | All Commands | Help </td></tr><tr bgcolor="Gainsboro"><td> Show the Office Assistant </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Microsoft Office Online </td><td> Microsoft Office ButtonAccess Options | Resources | Microsoft Office Online </td></tr><tr bgcolor="Gainsboro"><td> Access Developer Resources </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Contact Us </td><td> Microsoft Office ButtonAccess Options | Resources | Contact Us </td></tr><tr bgcolor="Gainsboro"><td> Sample Databases </td><td> Getting Started | Samples </td></tr><tr bgcolor="WhiteSmoke"><td> Check for Updates </td><td> Microsoft Office ButtonAccess Options | Resources | Check for Updates </td></tr><tr bgcolor="Gainsboro"><td> Detect and Repair </td><td> Microsoft Office ButtonAccess Options | Resources | Diagnose </td></tr><tr bgcolor="WhiteSmoke"><td> Activate Product </td><td> Microsoft Office ButtonAccess Options | Resources | Activate Product </td></tr><tr bgcolor="Gainsboro"><td> Customer Feedback Options </td><td> Microsoft Office ButtonAccess Options | Resources | Contact Us </td></tr><tr bgcolor="WhiteSmoke"><td> About Microsoft Office Access </td><td> Microsoft Office ButtonAccess Options | Resources | About </td></tr></tbody></table><br />Source: Microsoft (http://www.microsoft.com/)http://funwithaccess.blogspot.com/2009/06/locations-of-access-2003-commands-in_03.htmlnoreply@blogger.com (Sri Sri)43tag:blogger.com,1999:blog-1160358050898484933.post-5113093414903726873Tue, 02 Jun 2009 13:00:00 +00002009-06-02T06:00:00.205-07:00BasicsCommandsMenuWindow<table><tbody><tr bgcolor="SkyBlue"><th> Access 2003 Location </th><th> Access 2007 Location </th></tr><tr bgcolor="WhiteSmoke"><td> Window </td><td> Home | Window (Only when the database is set to display multiple documents) </td></tr><tr bgcolor="Gainsboro"><td> Split </td><td> Office Button | Access Options | Customization | All Commands | Split </td></tr><tr bgcolor="WhiteSmoke"><td> Split </td><td> Home | Window | Switch Windows | Split </td></tr><tr bgcolor="Gainsboro"><td> Tile Horizontally </td><td> Office Button | Access Options | Customization | All Commands | Tile Horizontally </td></tr><tr bgcolor="WhiteSmoke"><td> Tile Horizontally </td><td> Home | Window | Switch Windows | Tile Horizontally </td></tr><tr bgcolor="Gainsboro"><td> Tile Vertically </td><td> Office Button | Access Options | Customization | All Commands | Tile Vertically </td></tr><tr bgcolor="WhiteSmoke"><td> Tile Vertically </td><td> Home | Window | Switch Windows | Tile Vertically </td></tr><tr bgcolor="Gainsboro"><td> Cascade </td><td> Office Button | Access Options | Customization | All Commands | Cascade </td></tr><tr bgcolor="WhiteSmoke"><td> Cascade </td><td> Home | Window | Switch Windows | Cascade </td></tr><tr bgcolor="Gainsboro"><td> Arrange Icons </td><td> Office Button | Access Options | Customization | All Commands | Arrange Icons </td></tr><tr bgcolor="WhiteSmoke"><td> Arrange Icons </td><td> Home | Window | Switch Windows | Arrange Icons </td></tr><tr bgcolor="Gainsboro"><td> Hide </td><td> Office Button | Access Options | Customization | All Commands | Hide </td></tr><tr bgcolor="WhiteSmoke"><td> Unhide </td><td> Office Button | Access Options | Customization | All Commands | Unhide </td></tr><tr bgcolor="Gainsboro"><td> Size to Fit Form </td><td> Office Button | Access Options | Customization | All Commands | Size to Fit Form </td></tr><tr bgcolor="WhiteSmoke"><td> Size to Fit Form </td><td> Home | Window | Size to Fit Form </td></tr><tr bgcolor="Gainsboro"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="WhiteSmoke"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="Gainsboro"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="WhiteSmoke"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="Gainsboro"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="WhiteSmoke"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="Gainsboro"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="WhiteSmoke"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="Gainsboro"><td> Window Name Goes Here </td><td> Home | Window | Switch Windows | Window Name Goes Here </td></tr><tr bgcolor="WhiteSmoke"><td> More Windows </td><td> Office Button | Access Options | Customization | All Commands | More Windows </td></tr><tr bgcolor="Gainsboro"><td> More Windows </td><td> Home | Window | Switch Windows | More Windows </td></tr></tbody></table><br />Source: Microsoft (http://www.microsoft.com/)http://funwithaccess.blogspot.com/2009/06/locations-of-access-2003-commands-in_02.htmlnoreply@blogger.com (Sri Sri)0tag:blogger.com,1999:blog-1160358050898484933.post-5295889962244668396Mon, 01 Jun 2009 13:00:00 +00002009-06-01T06:00:00.427-07:00BasicsCommandsMenuTools<table><tbody><tr bgcolor="SkyBlue"><th> Access 2003 Location </th><th> Access 2007 Location </th></tr><tr bgcolor="WhiteSmoke"><td> Tools </td><td> Commands moved mostly to the Database Tools tab. </td></tr><tr bgcolor="Gainsboro"><td> Spelling </td><td> Home | Records | Spelling </td></tr><tr bgcolor="WhiteSmoke"><td> Office Links </td><td> External Data </td></tr><tr bgcolor="Gainsboro"><td> Office Links | Merge It with Microsoft Office Word </td><td> External Data | Export | More | Merge it with Microsoft Office Word </td></tr><tr bgcolor="WhiteSmoke"><td> Office Links | Publish It with Microsoft Office Word </td><td> You can find customization options at Microsoft Office Button |Access Options | Customize dialog. </td></tr><tr bgcolor="Gainsboro"><td> Office Links | Analyze It with Microsoft Office Excel </td><td> You can find customization options at Microsoft Office Button |Access Options | Customize dialog. </td></tr><tr bgcolor="WhiteSmoke"><td> Speech </td><td> Removed from product </td></tr><tr bgcolor="Gainsboro"><td> Online Collaboration </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Online Collaboration | Meet Now </td><td> Microsoft Office Button |Access Options | Customization | All Commands | Meet Now </td></tr><tr bgcolor="Gainsboro"><td> Relationships </td><td> Database Tools | Show/Hide | Relationships </td></tr><tr bgcolor="WhiteSmoke"><td> Relationships </td><td> Table Tools | Datasheet | Relationships | Relationships </td></tr><tr bgcolor="Gainsboro"><td> Analyze </td><td> Database Tools </td></tr><tr bgcolor="WhiteSmoke"><td> Analyze | Table </td><td> Database Tools | Analyze | Analyze Table </td></tr><tr bgcolor="Gainsboro"><td> Analyze | Performance </td><td> Database Tools | Analyze | Analyze Performance </td></tr><tr bgcolor="WhiteSmoke"><td> Analyze | Documenter </td><td> Database Tools | Analyze | Database Documenter </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities </td><td> Microsoft Office Button |Manage Database </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Convert Database </td><td> Microsoft Office Button |Save As </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Convert Database | To Access 97 File Format </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Convert Database | To Access 2000 File Format </td><td> Microsoft Office Button |Save As | Access 2002 - 2003 Database </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Convert Database | To Access 2002 - 2003 File Format </td><td> Microsoft Office Button |Save As | Access 2000 Database </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Compact and Repair Database </td><td> Microsoft Office Button |Manage | Compact and Repair Database </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Back Up Database </td><td> Microsoft Office Button |Manage | Back Up Database </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Back Up SQL Database </td><td> Microsoft Office Button |Server | Back Up SQL Database </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Restore SQL Database </td><td> Microsoft Office Button |Server | Restore SQL Database </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Transfer Database </td><td> Microsoft Office Button |Server | Transfer Database </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Copy Database File </td><td> Microsoft Office Button |Server | Copy Database File </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Drop SQL Database </td><td> Microsoft Office Button |Server | Drop SQL Database </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Linked Table Manager </td><td> Database Tools | Database Tools | Linked Table Manager </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Database Splitter </td><td> Database Tools | Move Data | Access Back-End </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Switchboard Manager </td><td> Database Tools | Database Tools | Switchboard Manager </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Upsizing Wizard </td><td> Database Tools | Move Data | SQL Server </td></tr><tr bgcolor="Gainsboro"><td> Database Utilities | Make MDE File </td><td> Database Tools | Database Tools | Make MDE </td></tr><tr bgcolor="WhiteSmoke"><td> Database Utilities | Make ADE File </td><td> Database Tools | Database Tools | Make ADE. </td></tr><tr bgcolor="Gainsboro"><td> Security </td><td> Database Tools | Database Tools </td></tr><tr bgcolor="WhiteSmoke"><td> Security | Set Login Password </td><td> Microsoft Office Button |Server | Set Logon Password </td></tr><tr bgcolor="Gainsboro"><td> Security | Set Login Password </td><td> Database Tools | Administer | Users and Permissions | Set Logon Password </td></tr><tr bgcolor="WhiteSmoke"><td> Security | Set Database Password </td><td> Database Tools | Database Tools | Set Database Password </td></tr><tr bgcolor="Gainsboro"><td> Security | Workgroup Administrator </td><td> Database Tools | Administer | Users and Permissions </td></tr><tr bgcolor="WhiteSmoke"><td> Security | User and Group Permissions </td><td> Database Tools | Administer | Users and Permissions | User and Group Permissions </td></tr><tr bgcolor="Gainsboro"><td> Security | User and Group Accounts </td><td> Database Tools | Administer | Users and Permissions | User and Group Accounts </td></tr><tr bgcolor="WhiteSmoke"><td> Security | User-Level Security Wizard </td><td> Database Tools | Administer | Users and Permissions | User-Level Security Wizard </td></tr><tr bgcolor="Gainsboro"><td> Security | Encode/Decode Database </td><td> Database Tools | Database Tools | Encode/Decode Database </td></tr><tr bgcolor="WhiteSmoke"><td> Replication </td><td> Database Tools | Administer | Replication Options </td></tr><tr bgcolor="Gainsboro"><td> Replication | Synchronize Now </td><td> Database Tools | Administer | Replication Options | Synchronize Now </td></tr><tr bgcolor="WhiteSmoke"><td> Replication | Create Replica </td><td> Database Tools | Administer | Replication Options | Create Replica </td></tr><tr bgcolor="Gainsboro"><td> Replication | Partial Replica Wizard </td><td> Database Tools | Administer | Replication Options | Partial Replica </td></tr><tr bgcolor="WhiteSmoke"><td> Replication | Recover Design Master </td><td> Database Tools | Administer | Replication Options | Recover Design Master </td></tr><tr bgcolor="Gainsboro"><td> Replication | Create Publication </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Replication | Pull Subscription </td><td> Removed from product </td></tr><tr bgcolor="Gainsboro"><td> Replication | Push Subscription </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Replication | Subscription Properties </td><td> Removed from product </td></tr><tr bgcolor="Gainsboro"><td> Replication | Publisher Properties </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Replication | Resolve Conflicts </td><td> Database Tools | Administer | Replication Options | Resolve Conflicts </td></tr><tr bgcolor="Gainsboro"><td> Startup </td><td> Microsoft Office Button |Access Options | Current Database </td></tr><tr bgcolor="WhiteSmoke"><td> Macro </td><td> Database Tools | Macro </td></tr><tr bgcolor="Gainsboro"><td> Macro | Visual Basic Editor </td><td> Database Tools | Macro | Visual Basic </td></tr><tr bgcolor="WhiteSmoke"><td> Macro | Microsoft Script Editor </td><td> Removed from product </td></tr><tr bgcolor="Gainsboro"><td> Macro | Security </td><td> Replaced with trusted locations. Commands available in the Microsoft Office Button |Access Options | Trust Center | Trust Center Settings button. </td></tr><tr bgcolor="WhiteSmoke"><td> Macro | Run Macro </td><td> Database Tools | Macro | Run Macro </td></tr><tr bgcolor="Gainsboro"><td> Macro | Convert Macros to Visual Basic </td><td> Database Tools | Macro | Convert Macros to Visual Basic </td></tr><tr bgcolor="WhiteSmoke"><td> Macro | Create Menu from Macro </td><td> Removed from product </td></tr><tr bgcolor="Gainsboro"><td> Macro | Create Toolbar from Macro </td><td> Removed from product </td></tr><tr bgcolor="WhiteSmoke"><td> Macro | Create Shortcut Menu from Macro </td><td> Database Tools | Macro | Create Shortcut Menu From Macro </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control </td><td> Source Control </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Get Latest Version </td><td> Source Control | Object Source Control | Latest Version </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Check Out </td><td> Source Control | Object Source Control | Check Out </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Check In </td><td> Source Control | Object Source Control | Check In </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Undo Check Out </td><td> Source Control | Object Source Control | Undo Check Out </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Show History </td><td> Source Control | Object Source Control | History </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Show Differences </td><td> Source Control | Object Source Control | Differences </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | SourceSafe Properties </td><td> Source Control | Object Source Control | Properties </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Add Objects to SourceSafe </td><td> Source Control | Object Source Control | Add Objects to SourceSafe </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Share Objects </td><td> Source Control | Object Source Control | Share Objects </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Create Database from SourceSafe Project </td><td> Microsoft Office Button |Create from SourceSafe </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Create Database from SourceSafe Project </td><td> Source Control | Database Source Control | Create from SourceSafe </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Add Database to SourceSafe </td><td> Source Control | Database Source Control | Add Database to SourceSafe </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Run SourceSafe </td><td> Source Control | Manage | Run SourceSafe </td></tr><tr bgcolor="Gainsboro"><td> Source Code Control | Options </td><td> Source Control | Manage | Options </td></tr><tr bgcolor="WhiteSmoke"><td> Source Code Control | Refresh Object Status </td><td> Source Control | Manage | Refresh Status </td></tr><tr bgcolor="Gainsboro"><td> ActiveX Controls </td><td> Form Tools | Design | Controls | Active X Controls </td></tr><tr bgcolor="WhiteSmoke"><td> Add-Ins </td><td> Database Tools | Database Tools | Addins </td></tr><tr bgcolor="Gainsboro"><td> Add-Ins | Add-In Manager </td><td> Database Tools | Database Tools | Addins | Addin Manager </td></tr><tr bgcolor="WhiteSmoke"><td> AutoCorrect Options </td><td> Microsoft Office Button |Access Options </td></tr><tr bgcolor="Gainsboro"><td> Customize </td><td> Microsoft Office Button |Access Options </td></tr><tr bgcolor="WhiteSmoke"><td> Options </td><td> Microsoft Office Button |Access Options </td></tr></tbody></table><br />Source: Microsoft (http://www.microsoft.com/)http://funwithaccess.blogspot.com/2009/06/locations-of-access-2003-commands-in.htmlnoreply@blogger.com (Sri Sri)0