How to Create a Simple Query in Microsoft Access

Watch this video to learn how to create a simple query in Microsoft Access. We will start by defining what a Microsoft Access query is. Then we will cover the basics of how to create a SELECT query in Microsoft Access including limiting the columns and rows that are returned in the query results, using criteria wildcards to search for part of a field in a query, and using the AND as well as the OR operators in the query criteria. We will also cover saving a query and reviewing how data changes in a simple query is also data changed in the underlying Microsoft Access table. By the end of this video, you should be able to create a simple query in Microsoft Access.

⌚ Time Stamps:
00:00 - Introduction to How to Create a Simple Query in Microsoft Access
00:25 - What is a Microsoft Access Query?
01:44 - Creating a Microsoft Access Query
03:51- Limiting Columns Returned in a simple Query
05:12 - Limiting Query Rows By Using Criteria
07:51 - Using Criteria Wildcards in Query Criteria
09:01 - Using the AND and the OR Operators in Query Criteria
11:58 - Saving a Query in Microsoft Access
12:46 - Data Changes in a Query = Data Changes in a Microsoft Access Table
13:50 - Conclusion for How to Create a Simple Query in Microsoft Access
------------

👨‍🏫 MyExcelOnline Academy Online Excel Courses 👇
1,000 video training tutorials & support covering Formulas, Macros, VBA, Pivot Tables, Power Query, Power Pivot, Power BI, Charts, Financial Modeling, Dashboards, Word, PowerPoint, Outlook, Access, OneNote, Teams & MORE...

🔥 OUR BEST EXCEL RESOURCES 🔥

------------

Feel free to comment and ask questions about this Microsoft Excel tutorial below and we will get back to you with the answer ASAP!

If you enjoyed the video, please give a thumbs up, comment, share.

Do not forget to SUBSCRIBE to this channel to get our new Microsoft Excel tutorials delivered straight to you each week! Thank You :)

Cheers,

JOHN MICHALOUDIS
Chief Inspirational Officer & Microsoft MVP

❤️ Let’s connect on social ❤️

#MicrosoftAccess #Access #query #office365 #msaccess #AccessForBeginners #Queries #Query #AccessQueries #MyExcelOnline #querybuilder