Access 4 blogposts

Access helps you manage your database. Do you want to design your own database, combine data from several sources in one database or link your customers’ contact details to their orders? It’s all possible with Microsoft Access – and on top of that, you can create complex search queries, user-friendly forms and professional reports with this software. Read our blog for the latest Access tips and tricks. Are you a beginner, intermediate or advanced user? Don’t worry, we’ve got tricks for every level.

Access tip 3: how do you create a split form with several tabs?

This is our third and last tip in this blog series about Access layout. Today, I'll teach you how to create split forms. Let's use the wine example in the first Access layout tip: imagine you'd like to keep track of a customer's information and order history in an organised way. A tabbed form could help tremendously.

Quickly find the correct table or query in Access

Johan Vermeire
Since Access 2007, the database navigation window has been replaced by the navigation pane. I hear a lot of students complaining about this navigation pane because you see only a limited number of items. Although I can't deny that, personally, I like this navigation pane a lot more than the old database window for the following reasons...

Creating fancy buttons in Access

Johan Vermeire
In Access 2003, command buttons all had the same layout. If your form contains a lot of command buttons it became rather 'busy' on the form. All command buttons also shared the same grey layout which made the form look 'dull'. Since Access 2007, we can play with the layout of these buttons and make them look attractive or as a hyperlink.

Table templates in Access

Johan Vermeire
When I have to create a database for the customer, I often create a table 'tblParameters' where I store general things about the database like: version number, location of back-end, location where exported PDF-files should be saved, location that contains Excel workbooks that need to be imported automatically, the date of the last update when data from a SQL server was stored in a local table.

Bring your knowledge and skills to a higher level

Subscribe for our monthly newsletter and receive:

  • Exclusive tips & tricks
  • Information about our courses
  • Trends on courses
  • Invitations to seminars and events

Most popular courses