The Microsoft Office suite of professional desktop applications comes with a database tool called Access, which allows you to design relational databases and execute queries for finding information and creating reports. When building a query in Microsoft Access, you can use expressions to perform calculations with your data. The "Len" expression will count the number of characters in a specific field of your Access database file.
Launch the Microsoft Access program on your computer and open the database file where you want to create a new query.
Go to the "Create" tab in the toolbar and click on the "Query Design" button.
Double-click on the name of the table that stores the field you want to use and then press the "Close" button in the pop-up window.
Place your cursor in the leftmost column of the grid in the lower half of the window.
Open the "Field" drop-down menu and select the name of the field of which you want to count characters.
Go to the "Criteria" section, type "Len([Name])" and replace "Name" with the exact name of the field you want to count.
Press the "Run" button at the top of the screen. Access will now run a report that counts the number of characters in the field you chose.
Things you need
- PC running Windows XP or later
- Microsoft Access 2007 or later