Microsoft Access Database: Advanced Parameter Query In Microsoft Access
The following two minute video demonstrates the advanced parameter query in Microsoft Access using a text (string) data type as the example by extending the criteria parameters.
Microsoft Access Database: Advanced Parameter Query In Microsoft Access
The narrator doesn’t really expand too much how advanced this can really get when using the advanced parameter query in Microsoft Access but it puts the foundation down for using the more flexible criteria for a string value by using the & operator (which means concatenate).
Microsoft Access Database Tutorial: Two more things to say here!
I apologise for the dryness of the narrators delivery (it’s only 2 minutes!) and to explain the definition of the word ‘concatenate‘ meaning ‘the joining of...’. Now you can continue to experiment with an advanced parameter query in Microsoft Access.
To learn more about parameter queries and other types of Microsoft Access queries including formula query, summary and crosstabs, take a look at my eBook offer; More Access Database Queries; which is one of a six series set of eBooks available to you.
About Ben
Ben Beitler is a highly proficient software developer & consultant with over 19 years experience of database design and implementation of CRM management systems, bespoke applications using VBA (mainly Excel spreadsheets & Access databases). Currently he is also working as coach for individuals and small businesses who are looking to use the Internet to market their businesses focusing on SEO and traffic building to websites.
He is a fellow member of the The Institute of IT Training which is the world's first professional body for IT training professionals which sets standards and code practices within the industry.
Having successfully run several businesses, Ben currently provides training, consultancy and development in Access and Excel ranging from small to large companies including Ford, Toyota, HSBC, Barclays, PWC, Deloitte, Sage and many others.
Even though he is based in the UK (in and around the London area), his services have been used as far as Australia consulting and developing systems with software specialists.
Ben has created website resources for Microsoft Access database and Microsoft Excel spreadsheet which are free to use which collate news articles, tips 'n' tricks, video tutorials and support questions from the more popular websites around including Google, Yahoo and YouTube.
To learn more about parameter queries and other types of Microsoft Access queries including formula query, summary and crosstabs, take a look at my eBook offer; More Access Database Queries; which is one of a six series set of eBooks available to you.
