Category Archives: Microsoft Access 2007

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 , | 4 Comments

Finding unmatched records in Microsoft Access

If you want to find records with no corresponding records in related tables, you can also use the Find Unmatched Query Wizard. This yields the same result as using Is Null in the QBE grid criteria. Please note however that … Continue reading

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

Microsoft Access – finding duplicate records

If you want to find duplicate entries in a field in a table or query, the easiest way to do this is to use the Find Duplicates Query Wizard. For example, you may wish to find records with the same … Continue reading

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

Using a crosstab query to summarize data in Microsoft Access

If we need to summarise data such as products sold per region, we can do this by using a crosstab query which will allow us to use data from more than one table. You can create a crosstab query by … Continue reading

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

Using the keyboard to navigate records in Microsoft Access datasheet view

Keystroke Effect ↓ Go to the next record ↑ Go to the previous record Ctrl + End Go to the last field in the last record Ctrl + Home Go to the first field in the first record → or … Continue reading

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

Hiding objects in a Microsoft Access database

It may be that there are tables and queries in your Access database which have been created for development purposes but do not need to be seen by the general users of the database. In this case, the objects can … Continue reading

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

Keyboard shortcuts for entering records into a Microsoft Access table or form

Shortcut What will be inserted Ctrl + ; Inserts the current date Ctrl + : Inserts the current time Alt + Ctrl + Spacebar Inserts that field’s default value Ctrl + ‘ Inserts the value from the same field in … Continue reading

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