A quick and easy to follow video tutorial example of how to create a parameter query which reduces the number of stored (repetitive) queries in your database.
A parameter prompts you for a value and passes it into your query during the run-time (execution) of the query which makes it a more flexible query as it is now a variable value which is passed and not a fixed value within the design of the query (SQL statement).
This can then serve your forms and reports which in turn triggers the prompt. You can have more than one parameter too to make extra flexible and it applies to all versions of Microsoft Access (not just 2007)!
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.
