This course provides details about creating tables in Access 2007, as well as how to add and delete records and tables from a database. It also covers basic database terminology, data types, primary keys, flat files, and relational databases.
Objectives:
Recognize data types and basic database terminology
Add and delete fields from a table
Set the primary key for a table
Identify flat files and relational databases
Create simple tables
Add, modify, and delete records from a table
Topics:
Database terminology
Data types
Adding and deleting fields
Primary keys
Flat files and relational databases
Creating tables
Adding, modifying, and deleting records
Technical Requirements:
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 6.0 or higher; Windows Media Player 9.0 or higher; Adobe Flash Player 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Cookies enabled; Sound card with speakers or headphones strongly recommended.
