![microsoft access 2013 tutorial youtube microsoft access 2013 tutorial youtube](http://i.ytimg.com/vi/v8eaCFVY0Kk/maxresdefault.jpg)
Note: Before you create a query, be sure you’ve established the relationships between tables in your database, because they are used when querying your data. Use the Query Wizard to create a select query that displays information in Datasheet View. For example, if Tailspin Toys goes out of business and the company’s products are no longer available for sale, find all of their products and automatically delete them from the relevant tables. Find information or records and then delete them.
#MICROSOFT ACCESS 2013 TUTORIAL YOUTUBE UPDATE#
For example, if Tailspin Toys has added “TT” to the beginning of the names of all its products, search for all of the company’s products and then update the product names so that each entry begins with “TT”-all through an update query.ĭelete data based on a query.
![microsoft access 2013 tutorial youtube microsoft access 2013 tutorial youtube](https://i.ytimg.com/vi/9iMNppt-XDc/maxresdefault.jpg)
Query for data and then use the results to automatically enter or update information.
![microsoft access 2013 tutorial youtube microsoft access 2013 tutorial youtube](https://i.ytimg.com/vi/SzAPxniXj2A/maxresdefault.jpg)
For example, you might create a query that asks the user for the name of the supplier to search for and then displays all the products acquired from that supplier. Create reusable queries that always ask you for search criteria.
![microsoft access 2013 tutorial youtube microsoft access 2013 tutorial youtube](https://i.ytimg.com/vi/Jr4rmcBllSc/maxresdefault.jpg)
For example, you might ask to see all products created by Tailspin Toys.Įnter criteria and search on the fly. Find and view information from one or more tables by specifying criteria that the data must meet and itemizing which values to display. A query might show data from one or more tables, from other queries, or from a combination of the two. Instead, it displays data that is stored in tables and it makes that data available for you to work with. Or you might combine data from more than one table, such as customer information and order information, to see what a customer has ordered. For example, you might want to just find a contact’s phone number, which requires a simple query of a phone number field for a specific person in a contacts table. In queries, you sometimes use data from just one table and other times from more than one. In Access, queries are like questions that you ask to find related, even very specific, information in your database. Select any of the video lessons marked to view them in a new window.Use queries to answer business or other questions based on data and to quickly and easily make bulk updates or to delete information from the database. Simply launch the Microsoft Office tutorial interface, click to start a video lesson or open one of the manuals, and you’re on your way to mastering Office. You can also customize it to meet your personal learning needs. This lets us develop a Microsoft Office tutorial that is easy to use. Our Microsoft Office tutorial is based on years of classroom training experience and teaching techniques. Whether you are completely new to Microsoft Office or upgrading from an older version, this Microsoft Office tutorial will empower you with the knowledge and skills necessary to be a proficient user. This complete Microsoft Office tutorial covers the same curriculum as our classroom training and was designed to provide a solid foundation in Office. Reinforce your learning with the text of our six printable classroom instruction manuals, which contain additional images and practice exercises. During this media-rich learning experience, you will see each function performed just as if your instructor were there with you. Watch, listen and learn as your expert instructors guide you through each lesson step-by-step. You get our complete courses in Access, Excel, Outlook, PowerPoint, Publisher and Word. Mastering Microsoft Office Made Easy features 797 video lessons with over 39 hours of introductory through advanced instruction. Learn Microsoft Office with this comprehensive Microsoft Office tutorial from TeachUcomp, Inc.
#MICROSOFT ACCESS 2013 TUTORIAL YOUTUBE MAC OS#