Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - MS Access - Introduction

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



PCDBS01

MS Access - Introduction
DURATION: 2 days

FEE: $490

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • User
  • Business Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Table Creation
      • Create a new database and an inventory table.
      • The columns in the table will contain text, numeric and date attributes.
    2. Table Data
      • Populate the table with data using basic data entry screens.
    3. Table Modification
      • Change a single row.
      • Change all the rows.
    4. Field Properties: Setting
      • Add a new column to the table and populate the column.
    5. Finding and Filtering Data
      • Extract all rows from a specific warehouse.
      • Extract all rows from multiple warehouses.
    6. Simple Queries
      • Search columns for a string.
      • Extract based on a range of values.
      • Use the LIKE clause to extract data.
      • Create a derived column.
      • Calculate values using an aggregate function.
      • Calculate a value using a scalar function.
    7. Operators in Queries
      • Perform concatenation of string.
      • Reformat a string.
      • Execute basic mathematical expressions.
      • Perform data arithmetic.
    8. Query design
      • Use the GUI to generate and execute SQL.
      • Code a simple join and subquery.
    9. Action Queries: creating
      • Using SQL DMSL statement insert, change, and delete rows in the table.
    10. Form Creation
      • Create a form to perform data entry on the inventory table.
    11. Design View
      • Design a basic detail report.
      • Design multiple summary reports.
      • Design a detail report with sub totals and grand totals.
    12. Reports
      • Display and print a report.
      • Modify the reports design and display the results.
      • Change the sort order of the report.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.