See also chapter 4, Appendix A and Appendix B in the BSBI MapMate Book.
Standard queries that come with MapMate
One of MapMate's strengths is the range of analysis queries that it is possible to run on your data. The first four videos cover aspects of analysis using the standard MapMate queries.
The browse list control buttons
Every time you run a query in MapMate the results are presented in a 'browse list' (looking rather like a spreadsheet). Each browse list has a standard set of controls at the top.
Using the browse list controls video
Using the data entry window to filter your data and run queries
It's possible to do lots of data analysis from the data entry window, quite apart from MapMate's specific Analysis section.
Querying from the data entry window video
Using the "F9 Custom Query" from the data entry window to design your own query
Using the F9 Custom Query video
Using wildcards
Using "wildcards" to group together data for recorders or sites that have similar names, in the Analysis section of MapMate.
Using wildcards for querying data
Adding a custom query to MapMate
If you need an analysis query that does something different to the standard ones that MapMate supplies, you'll need to add a Custom user query, covered in the fifth video on this page:
Adding custom user queries to MapMate video
Some examples of BSBI queries that you can copy and past into your MapMate database are provided on the custom queries page of this website.
Appendix B of the BSBI MapMate Book contains a further range of custom queries.
Writing your own custom queries
See the BSBI MapMate Book for details of the MapMate data model (Appendix A) and examples of useful queries (Appendix B).