Basic Access 2003

Course details

Create and modify tables in Access 2003

• Creating tables in Access 2003
• © s After completing this topic, you should be able to add a table to an Access database.
• Using Views design ± o sheet in Access 2003
• © s After completing this topic, you should be able to add a table using the view design ± o Data Sheet.
• Changing tables in Access 2003
• © s After completing this topic, you should be able to modify the fields to define the functions of a table.
• Mask input fields and indexes in Access 2003
• © s After completing this topic, you should be able to use input fields with mask and apply indexes fields.
• Create and modify a table in Access 2003
• © s After completing this topic, you should be able to create and modify a specific table in Access 2003.
• Handling data records in Access 2003
• © s After completing this topic, you should be able to manage data records.
• Creating relationships between tables in Access 2003
• © s After completing this topic, you should be able to identify the steps needed to create the different types of relationships between tables.
• Creating and modifying relations in Access 2003
• © s After completing this topic, you should be able to modify the table data and relationships between tables.
• Creating a relational database in Access 2003
• © s After completing this topic, you should be able to create a database that contains relational tables that meet the business requirements.