Call us at:- +91-9958934646

Create a free profile as

Sample Certificate


Access 2007: Essentials

Indian : Rs.3068
International : $47
Explore the endless capabilities of Microsoft Access 2007. These lessons, hosted by Jeff Conrad begin with a solid introduction of Access and cover topics such as defining a database, knowing when to use Access, working with database objects, and converting older databases.
Once you’re up to speed on the intricacies of Access 2007, Jeff walks you through step-by-step procedures on how to construct your table structures, create and adapt meaningful data entry forms, as well as share tracked information with others through reports.
Chapter I: INTRODUCING ACCESS 2007 (17 min)
  • Defning a Database
  • Knowing When to Use Access™
  • Working with Database Objects
  • Converting Older Databases

  • Exploring the Getting Started Screen
  • Opening a Microsoft Template
  • Using the Navigation Pane
  • Using the Home Tab, Part 1
  • Using the Home Tab, Part 2
  • Using the Create Tab
  • Using the External Data Tab
  • Using the Database Tools Tab
  • Using the Office Menu
  • Explaining the Access Options
  • Using the Quick Access Toolbar
  • Adding Custom Commands to the Quick Access Toolbar
  • Using the Help Menu
  • Understanding the Message Bar
  • Creating Trusted Locations
  • Working in the Object Window

  • Displaying Categories
  • Showing Views
  • Sorting the Objects
  • Searching for Objects
  • Collapsing Groups
  • Creating Custom Groups
  • Adding Object Shortcuts
  • Hiding Custom Groups
  • Changing the Interface Mode
  • Final Comments & Credits

Part/Disc II

Chapter I: CREATING TABLES (67 min)
  • Explaining the Datasheet Tab
  • Entering Data in a New Table
  • Using a Table Template
  • Identifying the Entities
  • Working with Design View
  • Creating DataTypes
  • Using Field Validation Rules
  • Defining Primary Keys
  • Adding Indexes
  • Working with Table Relationships
  • Creating Table Relationships
  • Defining Multi-Value Field Lookups

Chapter II: CREATING QUERIES (50 min)
  • Creating a Select Query
  • Using Expressions in a Query
  • Sorting Data
  • Searching for Data
  • Selecting Data from Many Tables
  • Working in Layout View
  • Working in SQL View
  • Creating a Crosstab Query
  • Running Action Queries
  • Running Update Queries
  • Using the Query Wizard

Chapter III: CREATING FORMS (48 min)
  • Using Quick Create Commands
  • Exploring Form Types
  • Navigating within Forms
  • Using the Form Wizard
  • Creating a Form from Scratch
  • Working in Layout View
  • Working in Design View
  • Setting Form Properties
  • Using Form Controls
  • Using Control Layouts
  • Applying AutoFormats
  • Understanding Subforms

Chapter IV: CREATING REPORTS (57 min)
  • Using the Report Command
  • Running the Report Wizard
  • Exploring Report Views
  • Creating a Report from Scratch
  • Using Conditional Formatting
  • Grouping & Sorting
  • Setting Report Properties
  • Detailing Your Report
  • Applying AutoFormats
  • Adding Subreports
  • Alternating Record Colors
  • Filtering in Report View
  • Creating Labels

Chapter V: CREATING MACROS (26 min)
  • Working in Macro Design Mode
  • Assigning Macro Actions
  • Setting Macro Arguments
  • Running an AutoExec Macro
  • Creating Embedded Macros
  • Final Comments & Credits
Presenter Info
Jeff Conrad is a technology enthusiast with many years of database application development expertise. Jeff began working with Microsoft Access when he saw a need at his full time position for a database solution. He bought a book on Access and began teaching himself how to use the program to solve his business’s needs. He immediately became hooked on the power and ease of working with Access.

Jeff has been an active participant in the Access newsgroups for many years where he is best known as the Access Junkie. He enjoys giving back to a community that helped him when first learning how to use Access. Jeff maintains a Web site with a wealth of information and resource links for those needing guidance with Access. Jeff also owns his own company, Conrad Systems Development, creating custom database and spreadsheet applications for the food service industry.

Jeff was awarded Microsoft’s Most Valuable Professional award from 2005 to 2007 for his continual involvement with the online Access community. He is co-author of Microsoft Office Access 2007 Inside Out and is a contributing author of Microsoft Office 2007 Inside Out. Because Jeff knows Access “Inside Out”, he recently joined Microsoft as a Software Design Engineer in Test working with Access and Excel technologies.
Frequently Asked Questions


Total Training

Total Training is a pioneer in innovative online and DVD-based training for leading creative design, digital video, and office productivity software programs.

Ranging from casual hobbyists to the most seasoned professionals, our users quickly learn new software applications and broaden their knowledge of programs currently used. Narrated in an entertaining format by industry experts and leading authors, our video-based software training titles are critical tools for anyone wanting to learn tips, techniques, and best practices from the most respected names in the business.

We currently offer affordable subscriptions to our All-Access Library, which contains hundreds of courses, thousands of clips, and project files so users can follow along.

Hot Courses

Our Partners