Access 2007 Essentials Online Training Course

Course Curriculum

Section 1

1: Introducing Access 2007

2: Exploring The New User Interface

3: Working In The Navigation Pane

Section 2

1: Creating Tables

2: Creating Queries

3: Creating Forms

4: Creating Reports

5: Creating Macros


What skills will I learn?

• Learn how to build new data entry forms and reports at the click of a button with the help of new Quick Create commands in Access 2007. You can then use these forms and reports as is, or modify them to your liking
• Try out the new built-in Date Picker control which can be used for any date fields. Explore how to enter a date into a field on datasheets, forms, or reports – no coding required
• Discover how to save valuable development time with the new Layout view in Access 2007. This cool new feature allows you to design your forms and reports while viewing live data. You can quickly resize, move, and align your controls without having to constantly switch between views
• Let Jeff show you how to use the new Report view, to dynamically filter the data and drill down to print only the information you need. The traditional Print Preview view is a static snapshot of your data that you view or print
• Find out how to make your data pop on screen with a Greenbar Effect by using the new Alternating Background Colour button. Your data has never been easier to read on screen or in printed form