You can use a query to view a subset of your data or to answer questions about your data. Lesson 5: Creating Microsoft Access Queries
#LEARN MICROSOFT ACCESS HOW TO#
This lesson also teaches you how to create relationships. Relationships join tables together so you can work with the data from multiple tables.
![learn microsoft access learn microsoft access](https://www.computersoftwaretraining.com/wp-content/uploads/2017/12/COMPUTER-SOFTWARE-TRAINING-LIVE-VIRTUAL-CLASS-WEBINARS-STREAMING-ON-DEMAND-VIDEOS-ONSITE-CLASS-TRAINING-BUILD-NEW-SOFT-SKILLS-MICROSOFT-ACCESS_1606163704.png)
This lesson teaches you how to sort and filter an Access table.Īccess data is stored in multiple tables. You can sort Access data so you can view records in the order you want to view them, and you can filter data so you only see the records you want to see. Lesson 4: Sorting, Filtering, and Creating Relationships This lesson teaches you how to modify a table and enter data. Lesson 3: Working with Microsoft Access TablesĪfter you create an Access table, you can modify it, enter data into it manually or import data from somewhere else, such as Excel.
![learn microsoft access learn microsoft access](https://i.ebayimg.com/images/g/vCQAAOSwCqJe9gqI/s-l300.jpg)
With Access, you can create a computerized database. Telephone and address books are examples of paper databases. A database is an organized collection of records. Microsoft Access is a database software package. Lesson 1: Getting Familiar with Microsoft Access 2007 for Windows You can use this free online tutorial to learn Microsoft Access 2007. Microsoft Access 2007 Tutorial-Free & Online