RKG Logo training-ITBiz
RKG Logo
Home Courses Fees Schedule REGISTER NOW Corporate Training Locations
Microsoft Office Tools
Adobe Acrobat Courses
SharePoint Training
Microsoft Dynamics
Social Media Courses
Project Management
Application Devp Tools
Oracle Developer Tools
Data Warehouse & BI
Data Base & System Admin
Programming Languages
Reporting Tools
Networking & Security
Web Technologies
Medical Records
Business Skills
ERP Training
Corporate Training On-Site
MS Access -BootCamp
Application Devlopment With MS Access
Application Development with MS Access - BootCamp
Software Version MS Access 2003 and 2007
Course Duration 4 Days
Course Type Class Room and Instructor-Led On-Line (E-Learning) Hands-On Training
Course Overview Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational databases. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their various objects using the Microsoft Office Access relational database application.
Intended Audience for this course This course is designed for students who wish to learn the basic operations of the Microsoft Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. Individuals who want to pursue Microsoft Certified Application Specialist certification in Microsoft Office Access can also take this course. This course is also designed for Office Staff, End Users, Office Secretaries, Analysts, IT management and Staff, Business Analysts, Functional Implementers, Project Managers and also those who want to use this Software for managing and organizing their day to day business.
Course Topics
Level 1
Lesson 1: An Overview of Access 2003
    Topic 1A: Relational Databases
    Topic 1B: The Access Environment
    Topic 1C: The Database Environment
    Topic 1D: Examine an Access Table
Lesson 2: Managing Data
    Topic 2A: Examine an Access Form
    Topic 2B: Add and Delete Records
    Topic 2C: Sort Records
    Topic 2D: Display Record Sets
    Topic 2E: Update Records
    Topic 2F: Run a Report
Lesson 3: Establishing Table Relationships
    Topic 3A: Identify Table Relationships
    Topic 3B: Identify Primary and Foreign Keys in the Relationships Window
    Topic 3C: Working with Subdatasheets
Lesson 4: Querying the Database
    Topic 4A: The Select Query
    Topic 4B: Add Criteria to a Query
    Topic 4C: Add a Calculated Field to a Query
    Topic 4D: Perform a Calculation on a Record Grouping
Lesson 5: Designing Forms
    Topic 5A: Form Design Guidelines
    Topic 5B: Create AutoForms
    Topic 5C: Create a Form Using the Form Wizard
    Topic 5D: Modify the Design of a Form
Lesson 6: Producing Reports
    Topic 6A: Create an AutoReport
    Topic 6B: Create a Report by Using the Wizard
    Topic 6C: Examine a Report in Design View
    Topic 6D: Add a Calculated Field to a Report
    Topic 6E: Modify the Format Properties of a Control
Level 2
Lesson 1: Planning a Database
    Topic 1A: Design a Relational Database
    Topic 1B: Identify Database Purpose
    Topic 1C: Review Existing Data
    Topic 1D: Determine Fields
    Topic 1E: Group Fields into Tables
    Topic 1F: Normalize the Data
    Topic 1G: Designate Primary and Foreign Keys
Lesson 2: Building the Structure of a Database
    Topic 2A: Create a New Database
    Topic 2B: Create a Table Using a Wizard
    Topic 2C: Create Tables in Design View
    Topic 2D: Create Relationships between Tables
Lesson 3: Controlling Data Entry
    Topic 3A: Restrict Data Entry with Field Properties
    Topic 3B: Create an Input Mask
    Topic 3C: Create a Lookup Field
Lesson 4: Finding and Joining Data
    Topic 4A: Find Data with Filters
    Topic 4B: Create Query Joins
    Topic 4C: Join Unrelated Tables
    Topic 4D: Relate Data Within a Table
Lesson 5: Creating Flexible Queries
    Topic 5A: Set Select Query Properties
    Topic 5B: Create Parameter Queries
    Topic 5C: Create Action Queries
Lesson 6: Improving Your Forms
    Topic 6A: Enhance the Appearance of a Form
    Topic 6B: Restrict Data Entry in Forms
    Topic 6C: Add Command Buttons
    Topic 6D: Create a Subform
Lesson 7: Customizing Your Reports
    Topic 7A: Organize Report Information
    Topic 7B: Set Report Control Properties
    Topic 7C: Control Report Pagination
    Topic 7D: Summarize Information
    Topic 7E: Add a Subreport to an Existing Report
    Topic 7F: Create Mailing Labels
Lesson 8: Expanding the Reach of Your Data
    Topic 8A: Publish Access Data as a Word Document
    Topic 8B: Analyze Access Data in Excel
    Topic 8C: Export Data to a Text File
    Topic 8D: Merge Access Data with a Word Document
Level 3
Lesson 1: Structuring Existing Data
    Topic 1A: Import Data
    Topic 1B: Analyze Tables
    Topic 1C: Create a Junction Table
    Topic 1D: Improve Table Structure
Lesson 2: Writing Advanced Queries
    Topic 2A: Create Unmatched and Duplicates Queries
    Topic 2B: Group and Summarize Records Using the Criteria Field
    Topic 2C: Summarize Data with a Crosstab Query
    Topic 2D: Create a PivotTable and a PivotChart
    Topic 2E: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
    Topic 3A: Create a Macro
    Topic 3B: Attach a Macro to a Command Button
    Topic 3C: Restrict Records Using a Where Condition
Lesson 4: Adding Interaction and Automation with Macros
    Topic 4A: Require Data Entry with a Macro
    Topic 4B: Display a Message Box with a Macro
    Topic 4C: Automate Data Entry
Lesson 5: Making Forms More Effective
    Topic 5A: Change the Display of Data Conditionally
    Topic 5B: Display a Calendar on a Form
    Topic 5C: Organize Information with Tab Pages
Lesson 6: Making Reports More Effective
    Topic 6A: Cancel Printing of a Blank Report
    Topic 6B: Include a Chart in a Report
    Topic 6C: Arrange Data in Columns
    Topic 6D: Create a Report Snapshot
Lesson 7: Maintaining an Access Database
    Topic 7A: Link Tables to External Data Sources
    Topic 7B: Back Up a Database
    Topic 7C: Compact and Repair a Database
    Topic 7D: Protect a Database with a Password
    Topic 7E: Determine Object Dependency
    Topic 7F: Document a Database
    Topic 7G: Analyze the Performance of a Database
Level 4
Lesson 1: Making Your Data Available on the Web
    Topic 1A: Create a Data Access Page by Using the Wizard
    Topic 1B: Improve the Presentation of the Data Access Page
    Topic 1C: Viewing Data Access Pages with the Browser
    Topic 1D: Edit Data Using the Data Access Page
    Topic 1E: Group Records in the Data Access Page
Lesson 2: Developing a Data Access Page in Design View
    Topic 2A: Create a Data Access Page in Design View
    Topic 2B: Incorporate a ComboBox in the Data Access Page
    Topic 2C: Test the New Record Function of the Data Access Page
    Topic 2D: Develop a PivotTable with the Office PivotTable Tool
Lesson 3: Integrating Access into Your Business
    Topic 3A: Import XML Data into an Access Database
    Topic 3B: Export Access Data to XML Format
    Topic 3C: Share Data with Other Office Applications
Lesson 4: Automating a Business Process with VBA
    Topic 4A: Create a Standard Module
    Topic 4B: Develop Code
    Topic 4C: Call a Procedure from a Form
    Topic 4D: Run the Procedure
Lesson 5: Creating a Switchboard and Setting the Startup Options
    Topic 5A: Create a Database Switchboard
    Topic 5B: Modify a Database Switchboard
    Topic 5C: Set the Startup Options
    Topic 5D: Modify the Startup Options
Lesson 6: Distributing and Securing the Database
    Topic 6A: Split a Database
    Topic 6B: Implement Security
    Topic 6C: Set Passwords
    Topic 6D: Encode and Decode a Database
    Topic 6E: Convert an Access Database to an MDE File

Enroll Online   

Live Chat
Enroll Online
Enroll By Fax
Fee & Schedule
Send Message
Follow us on .....
For further information call 949-387-3772 or FAX 949-681-8247 or email to info@SONUtraining.com
SONU Training is the training wing of RKG Technologies Inc
Disclaimer: RKG Technologies is not linked with Microsoft, Oracle, Adobe, IBM or any other software company we provide training
Copyright © 2004 RKG Technologies Inc. All rights reserved.