Apr
21st
Author: admin |
Files under MS OFFICE
Microsoft Access 2007 Tutorials – CBT Training Video
Importing Data
- Leveraging Data Import
- Importing from Text – Lesson 1
- Importing from Text – Lesson 2
- Importing from Excel
- Importing from XML
- Importing from Outlook
- Importing from Access
Exporting Data
- Exporting to Text
- Exporting to Excel
- Exporting to XML
- Exporting to Word
- Exporting to Access
Modifying Table Design
- Renaming Tables
- Dropping Tables
- Managing Fields – Lesson 1
- Managing Fields – Lesson 2
- Managing Fields – Lesson 3
- Using Undo and Redo
- Changing the Primary Key – Lesson 1
- Changing the Primary Key – Lesson 2
- Setting Table Relationships – Lesson 1
- Setting Table Relationships – Lesson 2
- Setting Table Relationships – Lesson 3
- Using the Table Analyzer Wizard
Maintaining Data Integrity
- Introduction to Data Types
- Managing Data Types – Lesson 1
- Managing Field Data Types – Lesson 2
- Setting Field Length
- Using Input Masks – Lesson 1
- Using Input Masks – Lesson 2
- Using Default Values – Lesson 1
- Using Default Values – Lesson 2
- Setting a Validation Rule
- Creating a Lookup List – Lesson 1
- Creating a Lookup List – Lesson 2
- Creating a Lookup List – Lesson 3
- Compacting the Database
- Backing Up the Database
Using Forms
- Understanding Forms
- Navigating in Forms
- Creating a Form Quickly
- Using the Form Wizard
- Understanding Form Views
- Creating a Blank Form – Lesson 1
- Creating a Blank form – Lesson 2
- Aligning Controls
- Sizing Controls
- Controlling Data Input
- Creating an Option Group – Lesson 1
- Creating an Option Group – Lesson 2
- Formatting a Form
- Using AutoFormat
- Setting Tab Order
- Creating Subforms – Lesson 1
- Creating Subforms – Lesson 2
Querying Data
- Sorting Table Records
- Using Basic Filters
- Using Filter By Form
- Using Advanced Filters
- Understanding Queries
- Using the Query Wizard
- Designing Select Queries
- Adding Query Criteria
- Designing Parameter Queries
- Using Calculated Fields
- Designing Action Queries – Lesson 1
- Designing Action Queries – Lesson 2
- Designing Action Queries – Lesson 3
- Generating Totals and Averages
- Using Expression Builder
Working with Reports
- Understanding Reports
- Creating a Report Quickly
- Using the Report Wizard
- Formatting a Report
- Creating a Blank Report – Lesson 1
- Creating a Blank Report – Lesson 2
- Creating a Blank Report – Lesson 3
- Using Queries in Reports
- Using Calculated Values
- Previewing and Printing a Report
- Saving a Report as PDF
Securing and Sharing Data
- Password-Protecting Your Database – Lesson 1
- Password-Protecting Your Database – Lesson 2
- Securing Database Code
- Distributing Your Database – Lesson 1
- Distributing Your Database – Lesson 2
Customizing Your Database
- Creating a Switchboard – Lesson 1
- Creating a Switchboard – Lesson 2
- Creating a Switchboard – Lesson 3
- Understanding the Navigation Pane
- Defining Custom Categories – Lesson 1
- Defining Custom Categories – Lesson 2
- Setting Global Options
- Customizing Quick Access – Lesson 1
- Customizing Quick Access – Lesson 2
- Creating a Custom Ribbon
- Using Performance Analyzer
- Using Database Documenter
Five Cool Access Tips and Tricks
- Getting Certified in Access 2007
- Great Access 2007 Resources
- Microsoft Virtual Labs
- Access Ribbon Mapping Workbook
- Keyboard Shortcuts
Download
http://rapidshare.com/files/144510400/VTC.Microsoft.Access.2007-CFE.part1.rar
http://rapidshare.com/files/144519731/VTC.Microsoft.Access.2007-CFE.part2.rar
http://rapidshare.com/files/144525111/VTC.Microsoft.Access.2007-CFE.part3.rar
http://rapidshare.com/files/144530195/VTC.Microsoft.Access.2007-CFE.part4.rar
http://rapidshare.com/files/144533650/VTC.Microsoft.Access.2007-CFE.part5.rar
http://rapidshare.com/files/144533943/VTC.Microsoft.Access.2007-CFE.part6.rar
Related Websites - Calculating Multiple Solutions to a Formula Modifying formula variables suffers from a serious drawback: You see only a single result at one time. If you want to study the effect that a variety of values has on the formula, you need to construct a data table. In the loan payment worksheet, for example, suppose that you......
- Prosper.com and Your Emergency Fund I was reading an article on bankrate.com about Using a CD Ladder as Parking Locations for Your Emergency Fund. One of the big problems with a CD Ladder is the finite number of times you can withdraw money without a fee. Another big problem is length of time it......
- Understanding the Property Sheet With the Property Sheet displayed, click on any control in Design View to display the properties for that control. Select multiple controls to display similar properties for the selected controls. In Figure 35-20, the Property Sheet has been sized to fit the screen. By widening the Property Sheet, you can......
- Microsoft Access Database Knowledge. If you are the one who has too much data in your enterprise that you need to track, you may be using a regular paper filling system, text documents or Excel to follow the necessary information. But if you are the one who looks for better database management system, there......
- Technology Decisions in Voice and Data Integration Businesses face many technological challenges in todays dynamic market place. One challenge is integrating voice and data communications into a cost- effective and workable format for their unique infrastructure. Taking existing equipment resources, remote locations, bandwidth requirements, and maintenance requirements all into account can be intimidating. But there are......
