Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Python
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Access 2000: Introduction To Application Development(Windows)
This course is provided by Wintrac. Wintrac provides one stop shopping for all your IT training needs. Wintrac’s course catalog of over two thousand courses includes courses on Desktop Application Software training, E-Mail/Groupware training, Office Suite training, Operating Systems training, Presentations training, Spreadsheets training, Web Browsers training and Word Processing training

Overview:

Access 2000: Introduction to Application Development is a hands-on instruction book that will guide you through the process of developing an application by using one or more Access 2000 databases.

Course Benefits:

You will learn about the process of developing an application by using one or more Access 2000 databases.

Prerequisites:

We designed Access 2000: Introduction to Application Development for the student who is proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who needs to draw on all these skills and add code to create an application. The prerequisite courses for this course are:
  • Access 2000: Level 1
  • Access 2000: Level 2
  • Access 2000: Advanced
Target Student:

Students that are proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who need to draw on all of these skills and add code to create an application.

Performance-Based Objectives:

  • Design an application by planning the scope and components of an application and by using external data sources.
  • Navigate from one form to another form in data-entry mode by using a command button, and make a command button invisible on the second form.
  • Automate a form designed as a dialog box by using a macro group.
  • Create and modify a Switchboard form by using the Switchboard Manager. Display the Switchboard form when the database opens by changing database Startup properties.
  • Create and use custom toolbars and menus by using the Customize dialog box and setting properties.
  • Create an unbound form to use as a splash screen on application startup by setting properties and writing Visual Basic for Applications code.
  • Identify elements of Visual Basic for Application syntax and decide where to place code by working with a standard function, a Private module-level procedure, and Sub procedures attached to event properties.
  • Secure an application by defining application-level and file-level security, by creating a workgroup information file, and by setting a database password
Certification:

Access 2000: Introduction to Application Development is one of a series of courseware titles that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsoft's business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more product proficiency exams in order to earn Office Specialist certification.

Delivery Method:

Instructor-led, group-paced, classroom-delivery learning model with structured hands-on activities.

What's Next:

This is the last book in the Access 2000 series. You may consider the other series (Word 2000, Excel 2000, and so on) to increase your experience with the Office 2000 suite.

Course duration:

1 Day(s)

Course outline:

Lesson 1: Application Design Concepts
  • Topic 1A: Planning an Application
  • Topic 1B: Moving through a Completed Application
  • Topic 1C: Developing a Distributed Application Design
Lesson 2: Adding Command Buttons to Guide User Navigation
  • Topic 2A: Using One Form for Two Purposes: To Add or Edit Records
Lesson 3: Automating a Dialog Box Form with a Macro Group
  • Topic 3A: Creating a Macro Group
  • Topic 3B: Customizing an Unbound Form to Behave like a Dialog Box
  • Topic 3C: Documenting a Macro Group
Lesson 4: Creating a Switchboard Form
  • Topic 4A: Using the Switchboard Manager
  • Topic 4B: Setting Database Startup Properties
Lesson 5: Working with Command Bars: Toolbars and Menus
  • Topic 5A: Using a Macro Group to Show and Hide a Toolbar
  • Topic 5B: Creating a Custom Menu Bar and Shortcut Menu for a Form
  • Topic 5C: Startup Properties for Toolbars and Menu Bars
Lesson 6: Creating a Splash Screen Form
  • Topic 6A: Creating a Form as a Splash Screen
  • Topic 6B: Automating the Splash Screen Form by Using Visual Basic Code
  • Topic 6C: Modifying Startup Properties to Display a Splash Screen Form
  • Topic 6D: Documenting the Application
Lesson 7: Using Visual Basic Procedures
  • Topic 7A: Creating a Public Function
  • Topic 7B: Adding General Procedures in a Form Module
  • Topic 7C: Creating Event Procedures
  • Topic 7D: Viewing a Live Web Site on a Form
Lesson 8: Adding Security to an Application
  • Topic 8A: Security Overview
  • Topic 8B: Steps to Securing a Database by Using User-level Security
  • Topic 8C: Documenting Database Security
  • Topic 8D: Securing a Database with a Database Password
  • Topic 8E: Distributing the Secured Application
Appendix A: APP.MDB Diagrams
  • Book Invoice Application
  • Access Application
Appendix B: Planning an Application
  • Planning an Application
Appendix C: Importing Spreadsheets, Databases, and Delimited Text Files
  • Importing and Linking Data from Spreadsheets
  • Importing and Linking Database Files
  • Importing Text Files
Appendix D: Securing Your Database Using the Access 2000 Security Wizard
  • A Summary of Using the Access 2000 Security Wizard
Hardware/Software Requirements:

This course was developed using the Windows 98 platform; however, the manufacturer’s documentation states that Office 2000 can also run on Windows 95 or Windows NT 4.0 with Service Pack 3 or higher installed, though some of the screen displays might be slightly different.

  • A Pentium 75 PC with 16 MB of RAM. (We recommend a Pentium 133 or faster with 64 MB or more.)
    • At least 700 MB of free hard-disk space. For optimal performance, we recommend an additional 100 MB of free hard-disk space for user graphics and temporary image caches.
    • Either a local CD-ROM drive or access to a networked CD-ROM drive for installation purposes.
    • A 3.5"-disk drive.
    • A two-button mouse, an IntelliMouse, or compatible pointing device.
    • A VGA or higher resolution monitor; a Super VGA is recommended. (The EGA display adapter is not supported.)
    • An installed printer driver. (Printers are not required; however, each PC must have an installed printer driver to use Print Preview.)
    • An Internet connection with access to the World Wide Web. The connection is necessary to complete some tasks and Web Tips throughout the book. (Note: Internet access may require payment of a separate fee to a service provider.)
    • Microsoft Windows 95 (or later) operating system, Microsoft Windows NT Workstation operating system version 4.0 with Service Pack 3 (or later) installed. If you are running Windows NT, make sure that you have at least 4 MB of free Registry space.
    • A custom installation of Microsoft Office 2000 Premium Edition—see the following section, Class Requirements, for additional instructions.

    Please contact your training representative for more details on having this course delivered onsite or online

    Training Outlines - the one stop shopping center for IT training.
    © Training Outlines All rights reserved