<blockquote id="ad0y4" ></blockquote>

<blockquote id="ad0y4" ><meter id="ad0y4" ></meter></blockquote>

  • <source id="ad0y4" ></source>
  • <nobr id="ad0y4" ></nobr>

        <noscript id="ad0y4" ></noscript>
        <dl id="ad0y4" ><ins id="ad0y4" ><listing id="ad0y4" ></listing></ins></dl>

        <progress id="ad0y4" ><ol id="ad0y4" ></ol></progress>
      1. <dfn id="ad0y4" ></dfn>
          <optgroup id="ad0y4" ><dfn id="ad0y4" ><span id="ad0y4" ></span></dfn></optgroup>

          RKG Logo training-ITBiz
          RKG Logo
          幸运彩票手机版官网 Courses Fees Schedule REGISTER NOW Corporate Training Locations
          ITBiz
          columtop
          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
          BootCamps
          Medical Records
          Business Skills
          ERP Training
          Corporate Training On-Site
          columnbottom
          ITBiz
          columnbottom
          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
          Testimonials
          ITBiz
          columtop
          columnbottom
          ITBiz
          Follow us on .....
          ITBiz
          For further information call 949-387-3772 or FAX 949-681-8247 or email to info@
          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
          幸运彩票手机版官网 © 2004 RKG Technologies Inc. All rights reserved.