|
|
| Home | Workshops | Calendar | Registration Form | General Information | About FAST3 | Contact Us |
 |
Microsoft Access
Access 2003: Getting StartedThis 2-hour short course will introduce you to Access 2003. Attendees will gain a general overview of and work with the objects in an Access database, including tables, queries, forms, and reports.
Access 2003: Level 1Most organizations maintain and manage large amounts of information. One of the most efficient and powerful information management computer applications is the relational database. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will be introduced to the concept of the relational database by using the Microsoft Access 2003 relational database application and its information management tools. This course is designed for students who wish to learn the basic operations of the Access 2003 database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. The Level 1 course is for the individual whose job responsibilities include working with tables to create and maintain records, locate records, and produce reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and using programming techniques that enhance Access applications. Upon successful completion of this course, attendees will be able to:
Access 2003: Level 2In this course you will consider how to design and create a new Access database, how to customize database components, and how to share Access data with other applications. Access 2003 Level 2 is designed for the student who wishes to learn intermediate-level operations of Access. It is for the individual whose job responsibilities include creating new databases, tables, and relationships, as well as working with and revising intermediate-level queries, forms, and reports. It also introduces the student to integrating Access data with other applications such as Microsoft Word or Excel. Upon successful completion of this course, attendees will be able to:
Access 2003: Level 3You're now ready to extend your Access knowledge into some of the more specialized and advanced capabilities. This course is designed for the student who wishes to learn intermediate and advanced operations of the Access 2003 database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. Upon successful completion of this course, attendees will be able to:
Access 2003: Level 4In this course, you will learn remote database management, how to exchange data with XML and other type applications, and how to automate your business processes by using VBA code. Level 4 is for students who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skill sets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. Upon successful completion of this course, attendees will be able to:
Access 2007: Getting StartedThis new 2-hour short course will introduce you to the Access 2007 interface. Attendees will also get a brief tour of tables, queries, forms, and reports.
Access 2007: Level 1In this 7-hour course we will explore the new interface, including the Ribbon and the Quick Access toolbar. We will learn how to design and build a simple database; work with data in tables; and create basic queries, forms and reports.
Access 2007: Level 2This intermediate 7-hour course will cover topics such as controlling data entry, joining tables, creating action and parameter queries, improving forms, customizing reports, and sharing data with other applications such as Excel and Word.
Relational Database DesignBeing able to use the tools in a database such as tables, reports, and queries is important, but do you know how to structure your database to meet your particular needs? The topics in this course will benefit all users of relational databases (including FileMaker Pro), especially those responsible for the design and creation of new databases. Using Microsoft Access, we will explore some principles which can be used to create and implement a well-designed relational database, no matter which program you are using. We will investigate ideal table design, including data normalization and data integrity. We will also explore ways in which queries can be used to tie a database together.
|
||||||||||||