background preloader


Facebook Twitter

Access 2000 Tutorial · FGCU Technology Skills Orientation. Free Online Web Tutorials - Microsoft Access Tutorial. If you develop your database into an application for others to use, there are many features you can use to help users navigate through your database and to keep them where you want them to be.

Free Online Web Tutorials - Microsoft Access Tutorial

You can manage the toolbars and menus that come with Access as well as create your own. On forms and reports, each time a user performs an action, an event occurs. You can program responses to these events. The programming of Access is divided into two pieces: macros and Visual Basic for Applications (VBA). The response to an event can be either a macro or VBA procedure (also called code). When you have large databases and multiple users, you might also be concerned with optimizing your database as well as startup, multiuser, keyboard, and other options. Events: Creating Event Response Events are user actions such as clicking the mouse, pressing a key, or opening a form.

Steps 1. 2. 3. 4. 5. For more help on building a macro, see also "Macros: Create in Design Window. " Hyperlink Appearance 1. 2. 3. Welcome. This FAQ site is designed to help Microsoft Access developers find answers for some common questions.


All code, utilities, and addins provided here are free and you are allowed to use them as part of your own applications. If you are going to redistribute any code, please be courteous to the original authors by mentioning their contributions and by following any copyright guidelines the author may have provided along with the utility or code. First and foremost, my thanks to Felix Kasza for providing the space for this website. A personal thanks to Arvin Meyer, who, since mid-2002, has been helping me, as the co-author of the site. More and more people from around the world now contribute to the Access FAQ. And another round of Thanks to Ken Getz, Michael Kaplan, Andy Baron, Michel Walsh, Terry Kreft, Jim Ferguson and many others for sharing their expertise and insight into Access with us, through the newsgroups or on a personal basis. Microsoft Access Tutorial - Prof. Richard Holowczak.

Visual Basic Tutorial. Visual Basic Tutorial - visual basic learning center. VBA Tutor - Help, Tutorials and Free Lessons. What is the 'ESSENCE' of VBA?

VBA Tutor - Help, Tutorials and Free Lessons.

To understand the 'Essence' of VBA, you must understand that every part of a MS Office program is made up of , and these Objects have that can be 'set' or 'altered' in response to a user initiated such as a 'mouse click' or a 'keypress'. In WORD for example, the 'Menu Bar' is an Object. The 'Header' and 'Footer' are objects. The whole document, individual pages, a paragraph, a sentence, a word, an individual character are also objects. Some of these properties are either 'true' of 'false'. Some of these properties could have a 'numerical' value. Some of these properties could have a 'text' value.

Using a mouse or a keyboard, the user initiates an . VBA 'controls' this interection between and their in response to a user initiated 'ESSENCE' of VBA!