Access I Tables, Fields, & Records
Welcome to Microsoft Access I: Tables, Fields, & Records!
In this comprehensive class, we will dive into the world of database management and equip you with essential skills and knowledge. Throughout the course, you will gain a solid understanding of database vocabulary, allowing you to communicate effectively in the realm of data management. We will guide you through the process of creating a new database from scratch, ensuring that you are well-versed in designing tables, defining fields, and establishing relationships between different data elements. Moreover, we will explore the powerful capabilities of Microsoft Access, including finding and replacing data, sorting records, and unleashing additional features that will enhance your ability to organize, analyze, and manipulate your data effectively. By the end of this class, you will have the confidence and expertise to navigate the complexities of tables, fields, and records, unlocking the full potential of Microsoft Access for your data management needs. Get ready to unlock the power of Microsoft Access and take control of your data!
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