Share this Page URL

Part: II Working with Existing Databases... > Tables Introduced - Pg. 21

Hour 2. Tables Introduced Tables are the foundation of any Access application. In working with tables, the first thing you'll want to be able to do is open them in Datasheet view and navigate around them. This hour covers all the basics of working with tables in Datasheet view. In this hour you'll learn the following: · How to view and navigate table data · How to edit table data · How to add records to a table · How to select and delete records · How to find and replace table data · How to apply and remove filters · How to modify the appearance of a datasheet · How to use the spell check and AutoCorrect features Viewing and Navigating Table Data Tables are the basis of everything that you do in Access. Most of the data for a database resides in tables, so if you're creating an employee payroll database, the employee data will be stored in a table, your payroll codes might be stored in a table, and your past payroll records could be stored in a table. A table contains data