SitesPower Training Center - PO Box 13801 Dubai, UAE
SitesPower Training Institute | Dubai : +9714-335-5549 | Sharjah Institute : +9716-575-1315 | معهد تدريب سايتس باور

Enquire About Course

Training Programs | Course Schedule

Printing Instructions

Microsoft Office Access 2007 Step by Step
3 day Instructor-Led Course (24 hours)
 

Course Overview

• Build databases from scratch or from templates
• Exchange data with other databases and Office documents
• Create forms to simplify data entry
• Use filters and queries to find and analyze information
• Design rich reports that help make your data meaningful
• Help prevent data corruption and unauthorized access

Your all-in-one learning experience includes:
• Files for building skills and practicing the book’s lessons
• Fully searchable eBook
• Bonus quick reference to the Ribbon, the new Microsoft Office interface
• Windows Vista Product Guide eReference—plus other resources on CD

Target Audience

Beg/Int

Book Details

384 pages, 1 companion CD

Course Outline:

1 Exploring Access 2007
Working in Access 2007
Understanding Database Concepts
Opening an Existing Database
• Sidebar: Enabling Macros and Other Database Content
Exploring Tables
Exploring Queries
Exploring Forms
Exploring Reports
Exploring Other Access Objects
Previewing and Printing Access Objects
Key Points
 

2 Creating a Database
Creating a Database from a Template
Creating a Table Manually
Creating a Table from a Template
Manipulating Table Columns and Rows
Key Points
 

3 Populating a Database
Importing Information from Another Access Database
• Sidebar: Migrating a Database from a Previous Version of Access
Importing Information from an Excel Worksheet
• Sidebar: Linking to Information
Importing or Linking to a SharePoint List
Collecting Data Through E-Mail
Importing Information from a Text File
• Sidebar: Importing Information from Other Sources
Importing Information from an XML File
Importing Information from an HTML File
Importing Information from an Outlook Folder
Importing Information from a dBASE File
Key Points

4 Sharing and Reusing Information
Exporting Information to Another Access Database
Exporting Information to Excel
Exporting Information to a SharePoint List
Exporting Information to Word
• Sidebar: Exporting Information to PDF and XPS Files
Exporting Information to a Text File
Exporting Information to an XML File
Exporting Information to an HTML File
Copying Information to Other Office Programs
Key Points

5 Simplifying Data Entry by Using Forms
Creating a Form by Using the Form Tool
• Sidebar: Relationships
Refining Form Properties
Changing the Arrangement of a Form
Adding Controls to a Form
Entering Data in a Form by Using VBA
Creating a Form by Using an AutoForm
• Sidebar: Simultaneously Creating Forms and Subforms
Adding a Subform to a Form
Key Points 

6 Locating Specific Information
Sorting Information in a Table
• Sidebar: How Access Sorts
Filtering Information in a Table
• Sidebar: Wildcards
• Sidebar: Expressions
Filtering Information by Using a Form
Locating Information That Matches Multiple Criteria
Creating a Query Manually
• Sidebar: Filters and Sorts vs. Queries
• Sidebar: Expression Builder
Creating a Query by Using a Wizard
Performing Calculations by Using a Query
Key Points
 

7 Keeping Your Information Accurate
Restricting the Type of Data in a Field
Restricting the Amount of Data in a Field
Specifying the Format of Data in a Field
Restricting Data by Using Validation Rules
Creating a Simple Lookup List
Creating a Multi-Column Lookup List
Updating Information in a Table
Deleting Information from a Table
Preventing Database Problems
Key Points

8 Working with Reports
• Sidebar: Forms vs. Reports
Creating a Report by Using a Wizard
Modifying Report Design
Creating a Report Manually
Modifying Report Content
Adding a Subreport to a Report
Previewing and Printing a Report
Key Points
 

9 Making Your Database Easy to Use
Creating a Switchboard
Creating Custom Categories
Controlling the Features Available to Database Users
Making Favorite Access Commands Quickly Available
Key Points
 

10 Securing and Sharing Information
Assigning a Password to a Database
• Sidebar: Creating a Secure Password
• Sidebar: Database Encrypting
Preventing Changes to Database Code
Securing a Database for Distribution
• Sidebar: Collaborating Through SharePoint