MS Access Training Program

MS Access Training Program

MS Access and Database Training Program

Computer Applications Training Sitemap
     

MS Access Training Program Advanced search

Technology Driven IT Training

Web-based Training Services

Why SYS-ED for Web-based Training

Definition of Service

Delivery Medium

Contact You
Licensing and Experience Courseware for Teaching Quality Control

SYS-ED’s MS Access and Relational Database Training program has been designed for organizations: 1- which are incorporating MS Access databases into its e-commerce operations. 2- require expertise in optimizing and scaling MS Access to a relational database. 3- which with an investment in MS FoxPro database applications; Microsoft no longer is providing updates to this database and its stated policy is to migrate client's to MS Access or MS SQL Server. 4- to evaluate MS Access in relation to an open source database and scalable enterprise databases. The program duration ranges from 3 to 17 days.

MS Access 2010 has been integrated with MS SPF: SharePoint Foundation and SPS: Windows SharePoint Services. WPF is a no charge add on to 64-bit Windows Server 2003 or 2008 Release 2 that provides the capability to share Access 2010 applications from document libraries and use Access to create or edit SharePoint lists. Access 2010 supports browser-based web databases published to Access Services running in SPS and has been designed to utilize XML, XSD: XML Schema, and XSLT. Access 2010 provides the capability to dynamically generate XML data and provides a standard transform to render data in HTML format.

MS Access 2010 can be used to:

  • Automate databases with the Access 2010’s data macro features.
  • Publish web databases with on-premises or hosted SharePoint Server 2010.

  • Create Access front ends to SQL Server databases.

  • Upsize applications to Access Data Projects and SQL Azure.

The program will be tailored to specific training needs and operational objectives. Educational consultancy topics, inclusive of project specifications can be incorporated into the program.

MS Access Training Program
Base Program Duration
Distance-learning Service
 
Learning Path
PC Applications
Web Design
 
Technology Updates
MS Office Web, Office 365, and Office 2010
MS Office 2007
MS SQL Server
MS Internet Explorer
 
Trends in the Market
Commercial and Open Source
Database Software

MS Access and Database Training Program

Teaching Models

MS Access and Database Training Program

Why SYS-ED
MS Access - Introduction 2 days
MS Access - Advanced 1 day

Base Program Duration

 3 days
Optional Courses  
MS Access: VBA Programming 3 days
Relational Database: Concepts 4 days
Relational Database: Design, Tools, and Techniques 4 days
Web Databases 3 days
Module: MS Access: Introduction
Duration: 2 days
Major Topics:
1. Featureset 2. Table creation 3. Table data
4. Table modification 5. Field properties: setting 6. Finding and filtering data
7. Simple queries 8. Operators in queries 9. Query design
10. Action queries: creating 11. Form creation 12. Design view
13. Reports    
Module: MS Access: Advanced
Duration: 1 day
Major Topics:
1. Queries 2. Form design 3. Subforms
4. Indexes 5. Macros 6. Macros: adding functionality
7. Group macro: creation 8. Switchboards 9. Report design
10. Grouping data in a report 11. Running summary: creation 12. Date/time control: inserting
Module: MS Access: VBA Programming
Duration: 3 days
Major Topics:
1. Featureset 2. Event-driven programming 3. Programming environment
4. Form controls 5. Syntax basics 6. Variables, arrays, and constants
7. Control structure 8. Input/output features 9. Modular programming
10. Custom menu 11. Text file I/O 12. Debug
13. Deployment    
Module: Relational Database: Concepts
Duration: 2 days
Major Topics:
1. Relational concepts 2. Relational software technology 3. Conceptual data modeling
4. Attributes topics 5. Modeling topics  
Module: Relational Database: Design, Tools, and Techniques
Duration: 4 days
Major Topics:
1. DBMS technology 2. Three level information architecture 3. DB server/user toolkit architecture
4. How a relational DBMS works 5. Relational concepts 6. DBMS relational components
7. Relational database design 8. Step-by-step approach and techniques 9. Entity-relationship modeling
10. CASE tool 11. Database normalization 12. Physical database design
13. SQL: Structured Query Language 14. Relational database creation 15. Database - manipulation and control
16. Database directions 17. Client/server architecture 18. Intelligent server - creation
19. Trends    
Module: Web Databases
Duration: 3 days
Major Topics:
1. Database fundamentals 2. HTML in database driven websites 3. Database integration: Internet and intranet
4. Database and the web 5. Data access - advanced 6. Performance and troubleshooting
7. E-commerce 8. Audio and video multimedia  

Review Additional Content

Open source and alternative software can be researched using the course search engine.


CICS Training Program


CICS Training Program


CICS Training Program


CICS Training Program

Additional information can be reviewed from SYS-ED software specific websites. They have been designed to compile, organize, and present operational categorizations of interrelated information technology.

http://www.pcapplicationstrainingbysysed.us/commquests.htm
www.crystalreportstrainingbysysed.us  www.databasetrainingbysysed.us

Footnote 1:
SYS-ED’s core computer applications curriculum has been submitted to the New York State Department of Education for review and licensure.