Martin Green Martin Green's Access Video Tips
|   Home   |   Excel   |   Access   |   Word   |   Outlook   |   VBA   |   eBooks   |   Handouts   |   Site Index   |   RSS   |
Access Video Tips

Access Tips Home

Excel Video Tips Home

Visit My Youtube Channel

 
Get Access and Excel Group Training for Just 425.
  
Get 1-to-1 Access and Excel Training for Just 275.

Martin Green's Access Video Tips

Here you will find a wide range of video tips for Microsoft Access. I plan to add videos suitable for range of skill levels from absolute beginner to advanced user so check back occasionally for updates. The videos were recorded using Access 2007, 2010 or 2013 at 1024x768 resolution and are best viewed at 720p (HD) quality. You can also view the videos full-screen. See the screenshots below for how to do this.

All the videos are hosted on YouTube so you can view them there if you prefer. Just click the YouTube link on the video player or visit my YouTube Video Tips Channel at www.youtube.com/martingreenvba.

How to change the video settings.

Currently Available Videos for Access

  • Access Forms Masterclass #1: Custom Navigation Buttons
    In this video I show you how to add a set of custom navigation buttons to an Access form. The video is recorded in real time from start to finish showing you just how easy it is to complete this task including writing the VBA code necessary to power the buttons. The video accompanies my tutorial Access Forms Masterclass #1: Custom Navigation Buttons where you can follow the fully illustrated written instructions, download a sample file containing the completed project, and download a printable PDF of the tutorial. [38:14]

  • Access Forms Masterclass #2: Custom Record Counter
    If you built the Custom Navigation Buttons in Masterclass #1 you might have also chosen to remove the built-in navigation bar. But that also contained a record counter so you will probably want to replace it with one of your own. In this video I show you how to add a label to an access form, format it to your liking, and write the VBA code necessary to turn it into a fully functioned record counter. The video accompanies my tutorial Access Forms Masterclass #2: Custom Record Counter where you can follow the fully illustrated written instructions, download a sample file containing the completed project, and download a printable PDF of the tutorial. [14:36]

  • Access Forms Masterclass  #3: Go To Record - A Custom Record Locator
    A common requirement for database users is to quickly locate a specific record. Whilst Access provides a number of tools for sorting and filtering a form's recordset there isn't a built-in tool to help the user quickly find and display a specific record. If you want one, and you almost certainly will, you will have to build it yourself. I have built several different kinds of Go to Record tools to suit my users' requirements and the complexity of the data. This is one of my favourites and is really easy to build . The video accompanies my tutorial Access Forms Masterclass #3: Go To Record - A Custom Record Locator where you can follow the fully illustrated written instructions, download a sample file containing the completed project, and download a printable PDF of the tutorial. [25:52]

  ©2000-2013 Martin Green martin@fontstuff.com All rights reserved