Want to learn MS-Access. Don't have Prior Knowledge of Databases. No worries. Class Course outline has been structured keeping in mind that this is participants first exposure to MS-Access.
Topics Covered
MS -Access Outline Session 1: Exploring the Microsoft Office 1. Access 2007 Environment Examine Database Concepts Explore the User Interface Explore the Ribbon Customize the Access Environment Obtain Help Use an Existing Access Database Session 2: Designing a Database Describe the Relational Database Design Process Define Database Purpose Review Existing Data Determine Fields Group Fields into Tables Normalize Data Designate Primary and Foreign Keys Determine Table Relationships Session 3: Building a Database Create a New Database Create a Table Manage Tables Create a Table Relationship Save a Database as a Previous Version Session 4: Managing Data in a Table Modify Table Data Sort Records Work with Subdatasheets Session 5: Querying a Database Filter Records Create a Query Add Criteria to a Query Add a Calculated Field to a Query Perform Calculations on a Record Grouping Session 6: Designing Forms View Data Using an Access Form Create a Form Modify the Design of a Form Session 7: Generating Reports View an Access Report Create a Report Add a Custom Calculated Field to a Report Format the Controls in a Report Apply an AutoFormat to a Report Prepare a Report for Print Session 8: Controlling Data Entry Restrict Data Entry Using Field Properties Establish a Pattern for Entering Field Values Create a List of Values for a Field Session 9: Joining Tables Create Query Joins Join Unrelated Tables Relate Data Within a Table Session 10: Creating Flexible Queries Set Select Query Properties Create Parameter Queries Create Action Queries Session 11: Improving Forms Design a Form Layout Enhance the Appearance of a Form Restrict Data Entry in Forms Add a Command Button to a Form Create a Subform Session 12: Customizing Reports Organize Report Information Format the Report Set Report Control Properties Control Report Pagination Summarize Report Information Add a Subreport to an Existing Report Create a Mailing Label Report Session 13: Sharing Data Across Applications Import Data into Access Export Data Analyze Access Data in Excel Export Data to a Text File Merge Access Data with a Word Document
Who should attend
Anyone who want to expand their knowledge arena. Course outline is from very beginning
Pre-requisites
-
What you need to bring
-"
Key Takeaways
Knowledge to create,handle your Databases at home/office