Access II Queries, Relationships, & Interface
Welcome to Microsoft Access II: Queries, Relationships, & Interface!
In this dynamic class, we will delve deeper into the realm of database management, equipping you with advanced skills and techniques to take your data manipulation to the next level. Throughout this course, you will not only expand your knowledge of database vocabulary but also gain proficiency in utilizing queries to extract specific information from your databases. We will guide you through the intricacies of designing and refining queries, allowing you to leverage the power of datasheet view to navigate and manipulate your data with precision. Additionally, we will explore the art of selecting and deleting records, enabling you to streamline your database and keep it updated. You will also learn about various printing options that will help you present your data in a professional and organized manner. With Microsoft Access II, you will master the intricacies of queries, relationships, and the user interface, equipping yourself with the tools to optimize your data management processes. Get ready to unlock the full potential of Microsoft Access and become a proficient database manager!
Scheduled Dates
We don't currently have this class on the schedule, but we can add it for you! Please choose an available day and time or call us at (909) 981-6331 for more information.
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
This is where to start for Access. Like anything else, you have to have a strong foundation to build on. In Access, Tables are the foundation. Learn to design for accuracy and ease of use. Start manipulating your data with Queries. Learn how to make data entry easier using Input Masks and Field Properties. TABLES * PROPERTIES * QUERIES
Topics Include:
- Understanding database vocabulary
- Opening an existing database
- Creating a new database
- Creating a table
- Datasheet View
- Entering and editing data
- Modify Table
- Understanding and adding field properties
- Creating a field input mask
- Finding data
- Replacing data
- Filtering data by form
- Clearing a filter
- Filtering data by selection
- Sorting records
- Creating a query
- Adding and removing tables
- Inserting, moving, and removing fields
- Selecting the sorting order
- Understanding and entering criteria options
- Printing options
- Deleting objects
- Sample tables
- Sample data