|
|
| Home | Workshops | Calendar | Registration Form | General Information | About FAST3 | Contact Us |
 |
Microsoft Access
Access 2007: New FeaturesThis 3-hour course is designed for experienced Access users who have worked with earlier versions of the program, and who have recently upgraded to Access 2007. Upon successful completion of this workshop, students will feel more comfortable navigating the new Access 2007 interface; work with tables and forms, and create queries and reports. Finally we will see how easy it is to work with external data using the enhanced features of Access 2007.
Access 2007: Getting StartedThis 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: Report DesignReports are the end product of a database. Reports are also the best way to format, summarize, and print data. In this new 2-hour workshop we will cover the basics of Access 2007 reports. You will learn the steps for setting up a report from design/layout to creation. We will create a report from “scratch,” using the Report Tool, and using the Report Wizard. We will also use the new Layout view to modify a report.
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.
Access 2007: Level 3In this 7-hour course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
Data Retrieval and Manipulation in Access 2007This half-day, hands-on workshop will begin by covering topics such as data import, linking, and export features of Access 2007. You will learn how to transfer data to and get data from external data sources such as other Access databases, Excel spreadsheets, flat text files, Outlook and the Web. The second part of the workshop will cover Access Projects. An Access Project provides a dedicated connection to a Microsoft SQL Server database, allowing you to create tables, relationships, indexes and other enterprise objects on the SQL Server while still using the forms and reporting features of Access. A Project combines the power of SQL Server (e.g. multi-user, large data set support) with the familiar features of Access.
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.
|