MS AccessIn this webcast, we will continue to look at our data that we worked with in the last webcast using Microsoft Access 2013.  In the last webcast we created tables and worked with field settings and learned how to find data in a table.  Now, we will learn how to filter in a table.  Filters are a great way to find information quickly in a database, but are not as powerful as queries.

Queries ask questions and are the guts of a database.  It’s where you get all the answers to your questions to extract useful information.  We will learn how to create queries using one or more tables in a database.  We will see how to create queries using the query wizard and work with criteria to get the information we are looking for.  We will learn how to create a calculation in a query and total a group of items, such as total sales by department, total units in stock for products.  Do you want to enter the information you are looking for in a box so you get a different outcome each time you run the query or print a report, let’s create a parameter query to do just that.  Now that you have the information you need, why not print the query.  You want the report to look nice, let’s combine the fields such as first and last name even though they were create as separate fields in a table.  You can also export the report to Word and then email it to someone even if they don’t use Access.

Yes – there is so much more to Access and really we’ve just covered a fraction of what it can do.  If you are interested in learning more, we can provide another webcast or come out and train your employees to learn how to use this powerful program.

Attend this Free webinar from Simplex-IT and possible win a copy of Microsoft Office Professional 2013!

When:  Thursday, April 9th from 11-noon (eastern)

Where:  Online

click here to:  RSVP

At Simplex-IT, we specialize in sharing our knowledge with several free webinar and Lunchinar events each month on topics such as Microsoft Office, Project Management and Data Practices.  Contact us at Info@Simplex-IT.com, Twitter (Simplex_IT), LinkedIn (http://www.linkedin.com/company/simplex-it) or FaceBook: (http://www.facebook.com/simplex.it)