fbpx
Logo
Mail us
ben@accessdatabasetutorial.com

Category Archives: Reports

Microsoft Access Reports: How To Number Entries In A Report


Microsoft Access

If you need to know how to number records for your Microsoft Access reports and haven’t added a sequential data field namely the AutoNumber (which should be a primary key), then here’s a quick way to add such a feature directly into your reports. Design your report using one of the various methods you know usually backed by an Access query – right? Then switch to the design view. Microsoft Access Reports: How To Number Entries In A Report – The […]

Tags: , , , , ,

Access Conditional Formatting: How To Apply Logical Formatting To Access 2013 Reports And Forms


Access

Take a look at the video tutorial below of the latest version ( Access 2013 ) which demonstrates three different methods between using the value, expression and an aggregate rule. Access Conditional Formatting: How To Apply Logical Formatting To Access 2013 Reports And Forms The pre-defined data bars when  using the built-in ‘compare to other records‘ rule really makes this easy to apply and bring a dynamic impact typically to your reports. You can set from a value range or […]

Tags: , , , , ,

Access Printing & Page Setup Options


Unlike other Microsoft Office applications (Excel, Word etc.), Access printing can be a challenge or perhaps just a little disorientating! There are several ways and places that you can choose to set the page setup and print something (an object) from your database application and in this short concise post I want to cover the basics and know your options. Access Printing & Page Setup Options – The Basics Here’s a quick tip for you! If you select (not necessarily […]

Tags: , , , ,

Modifying MS Access Page Setup


MS Access

Modifying MS Access Page Setup – Quick Video Demonstration Take a look at this quick (87 seconds) video on how to modify the layout of a table using the Access page setup before you print. This can be applied to other objects in the database too including queries, forms and reports. Modifying MS Access Page Setup – Applies To The Main Objects In some cases you may want to print just the table and since this object wasn’t designed to […]

Tags: , , , ,

Microsoft Access Color: How To Pick And Set The Exact Color In An Access Database


Access Database

First of all, I want to apologise (or apologize!). I’ve used the term Microsoft Access color in my title and not Microsoft Access colour (the correct spelling). This is because our American cousins built or at least assembled Microsoft Access together setting the captions to the local language – so please excuse the misspelt words. Setting colour in your forms and reports is easy enough to find and apply even with looking at the ‘Custom’ tab when picking a colour […]

Tags: , , , , ,

Microsoft Access Properties: What’s The ‘HasModule’ Property In An Access Database?


Microsoft Access

There are many Microsoft Access properties to set and control your Access database with and when combined in certain permutations, it changes the whole dynamics of your database and how they will perform and behave. One property I want to mention here affects performance and the overall file size of your database and applies to the main form or report properties. The property is called ‘Has Module’. Microsoft Access Properties: What’s The ‘Has Module’ Property In An Access Database? The […]

Tags: , , , , ,