Category Archives: Microsoft Access

Beware – copying a shortcut is not the same as copying a file!

I was doing Microsoft Access training last week and the client wanted us to look at making changes to their database. I said we needed to make a copy then if we did something that they decided they didn’t want, … Continue reading

Posted in Microsoft Access, Microsoft Office 2016, Microsoft Office 365, Microsoft Ofiice 2016 | Tagged | Leave a comment

Microsoft Access to Microsoft Word mailmerge – dates in wrong format

I was using data from a Microsoft Access query in a Microsoft Word mailmerge document the other day. However on returning dates they were in the American format rather than the UK one, although both Microsoft packages were showing my … Continue reading

Posted in Microsoft Access, Microsoft Access 2013, Microsoft Access 2016, Microsoft Word, Microsoft Word 2013, Microsoft Word 2016 | Tagged , | Leave a comment

Microsoft Access – automatic numbering using set pattern e.g. P-001, P-002, etc

If you use Microsoft Access you can use Data Type AutoNumber to produce a sequence 1, 2, 3 etc for your records. If you want to instead use a sequence such as P-001, P-002, etc, then in Design view. go … Continue reading

Posted in Microsoft Access, Microsoft Access 2013, Microsoft Access 2016 | Leave a comment

Microsoft Access – creating percentages of totals in a report

I have a report showing whether various jobs have been completed in various departments. I want to show percentage of totals in the report. The original report looks like: To created % of Totals go into Design view In the … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged | Leave a comment

Microsoft Access – adding a chart into a report

When presenting numerical data, it is often useful to show a chart of the data as it is easier to interpret than looking at the numbers themselves. First produce your report as required in the usual way. Here I have … Continue reading

Posted in Microsoft Access, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | Leave a comment

Microsoft Access – having Switchboard form open automatically

You may have created a Switchboard form to allow users to navigate an Access database more easily. To have the switchboard open on startup: From within the database, click File – Options. Click Current Database. Select Switchboard from the Display … Continue reading

Posted in Microsoft Access, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | Leave a comment

Microsoft Access – removing Subdatasheet

If you have inserted a subdatasheet into an Access table, you may want to remove it. To do so, open your table in Datasheet view. On the Home tab, in the Records group, click the More dropdown, then select Subdatasheet … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010 | Tagged , | 2 Comments

Microsoft Access – Parameter Query on months of year

How can I create a parameter query that lets me just specify a month period, i.e. July? If you have a date in a query and you just want to return items within a certain month set up as a … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010 | Tagged , , | Leave a comment

Microsoft Access – using captions for field names

When you create a field name within an Access table, you may use a name that is useful to the developer, e.g. strSurname, indicating that the field is text, but it may not be that user-friendly for the person using … Continue reading

Posted in Microsoft Access, Microsoft Access 2003, Microsoft Access 2007, Microsoft Access 2010 | Tagged , , | 1 Comment

Creating a custom sort in Microsoft Access

It is easy enough to do a custom sort in Microsoft Excel, but what about in Access. In Access, you can create a calculated field using IIf in order to be able to do so. As an example, if you … Continue reading

Posted in Microsoft Access, Microsoft Access 2007, Microsoft Access 2010, Microsoft Access 2013, Microsoft Access 2016 | Tagged , | 5 Comments