The Best Step By Step Microsoft Access XP Training CD Course!

Price: $99.00

Microsoft Access XP Training presents the learner with the fundamentals of Microsoft Access XP, and guides the learner through the basics of Access databases and covers topics such as creating and modifying databases, and establishing relationships between tables. It also covers more advanced features of Access XP, and how to make different types of data queries, work with forms and link data to other databases. Finally, more complex aspects of working with data using Access XP are covered.

Learn To

• Introduction to Database Concepts and Terminology
• An introduction to Access XP
• Database Planning and Design
• Examining a table
• Creating a table by using the Table Wizard
• Creating a table in Design View
• Modifying the Table Design
• Finding and Editing Records
• Filtering and Sorting Records
• Selecting Fields and Sorting Records in a Query
• Refining the results of a query
• Creating an Form
• Modifying the Form Design
• Normalizing Data
• Normalizing Data for Fourth and Fifth Normal Forms
• Analyzing Table Relationships
• Establishing and Testing Referential Integrity
• Data Validation Techniques
• Subdatasheets and Lookup List Fields
• Indexing Techniques
• Using Calculated Fields in Queries
• Creating Multiple Table Queries
• Creating Parameter Queries
• Creating Action Queries
• Customizing the Form Design
• Joining Tables and Working with Join Properties
• Creating Crosstab Queries
• Creating Parameter Queries
• Creating Action Queries
• Organizing Field Placement
• Using a Form as the User Interface
• Using the Switchboard Manager
• Creating a Form that Contains a Subform
• Creating a Form in Design View
• Macro Basics
• Attaching a Macro to a Command Button
• Using a Macro to Provide User Interaction
• Using a Macro to Automate Data Entry