Free Microsoft Office Training and Tutorial Resources




    



January 18, 2011

2 Access 2007 Training Sessions

Here are 2 great Access 2007 Training Sessions with Tutorials and Workshop Manuals, from the Hillsborough Community College. This freely available Access training gives you step-by-step instructions and are illustrated with screen shots to show and guide you through the many features and topics of Access. The first two links make up the Access 1 training session as an animated Access tutorial and a workbook manual in pdf format. The second two comprise the Access 2 training and are in the same formats.


Access Animated Tutorial 1

Contents:
 - Unit 1: Database structure and terminology
 - Unit 2: Create a new database and a table
 - Unit 3: Enter data
 - Unit 4: Data types
 - Unit 5: Insert and delete fields
 - Unit 6: Forms and Split Forms

Access Workshop Manual 1 (28 pages, 1.6mb, pdf)

Contents:
 - Objectives
 - Database Structure
 - Database Terminology
 - Relationships
       One-to-many
       Many-to-many
       One-to-one
 - Create a New Database
 - Access 2007 Tour and Features
 - Create a Table in Datasheet View
 - Edit a Table in Design View
 - Save a Table
 - Enter Data
 - Data Types 
 - Use Input Mask Wizard
 - Data Type: Yes/No
 - Data Type: Lookup Wizard
 - Insert and Delete Fields
 - Set a Primary Key
 - Form Wizard
 - Split Form

Access Training 1 Tutorial and Manual Objectives:
At the end of Access 1 training, you should be able to:

  1. Create a new database;
  2. Create tables for data entry in datasheet view and design view;
  3. Enter data into a table;
  4. Use, understand, and set data types: text, memo, number, currency, date/time, autonumber, yes/no, lookup wizard;
  5. Insert and delete a row and a field;
  6. Create and delete a primary key;
  7. Create a form using the Wizard tool;
  8. Create a split form.


Access Animated Tutorial 2

Contents:
 - Unit 1: Import and Export Data
 - Unit 2: Create a Query
 - Unit 3: Modify a Query
 - Unit 4: Text Data Criteria and Wildcards in a Query
 - Unit 5: Number Criteria and Comparisons
 - Unit 6: Aggregate Functions in a Query
 - Unit 7: Create a Report

Access Workshop Manual 2 (pages, 2.1mb, pdf)

Contents:
 - Objectives
 - Import a Table from Excel
 - Export an Access Table to Excel
 - Create a Query
 - Query
      Sort
      Show
      Text Data Criteria
      Wildcards
      Field Not in Result
      Number
      Comparison
      Comparison And
      Comparison Or
 - Aggregate Functions
      Count
      Avg (Average)
 - Parameters and the Between Operator
 - Report Wizard
 - Modify a Report
 - Insert Images into a Form or Report
 - Resize Images in a Form or Report

Access Training 2 Tutorial and Manual Objectives:
At the end of Access 2 training, you should be able to:
  1. Import a table from Excel;
  2. Export an Access table to Excel;
  3. Create a query;
  4. Sort fields in a query;
  5. Show fields in a query;
  6. Run a query using wildcards;
  7. Run a query for fields not in result;
  8. Run a query for a number value;
  9. Run a query using the comparison criteria “And”;
  10. Run a query using the comparison criteria “Or”;
  11. Understand the purpose of Aggregate Functions;
  12. Create and run a query using count;
  13. Create and run a query using average;
  14. Create and run a query using the parameter between;
  15. Insert and resize a graphic/image;
  16. Create and Modify a Report.




Tags for this post>> |
January 8, 2011

The 20 Minute Guide to Using MS Access 2007

Here is a 19-page quick tutorial on getting up to speed using Access, titled, The 20 Minute Guide to Using MS Access 2007, hosted by access-databases.com. This Access tutorial will show you how to start creating a database and entering records for it. You will also learn how to create Forms, Queries, and a Report using your database. (19 pages, 936kb, pdf)


Contents of this Access tutorial:
 - What is a database
 - Access 2007
 - Create a brand new database
 - The Navigation Pane
 - Create a Form
 - Create a Query
 - Create a Report
 - Summary



Tags for this post>> |

May 13, 2010

Access 2007 Flashcards, Practice Tests, and Learning Games

Here are 2 Access 2007 Quick References, along with Access 2007 Flashcards, Practice Tests with answers, and Learning Games. Each quick reference document lists Access tasks or features to be performed along with their corresponding commands or menu items using the Mouse, the Ribbon, the Shortcut Menu, and Keyboard Shortcuts. The first quick reference provides 70 Access 2007 tasks, and the second one contains 124 tasks.


 - Access 2007 Quick Reference 1  (4 pages, pdf format, 155kb)
 - Access 2007 Quick Reference 2  (8 pages, pdf format, 185kb)


Chapter 1
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 2
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 3
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 4
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 5
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge


Chapter 6
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 7
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 8
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge

Chapter 9
Flashcards
Practice Test
Who Wants to be a Computer Genius2?
Wheel of Terms
Crossword Puzzle Challenge



Tags for this post>> |
April 21, 2010

4 Excel eBooks, 6 Access eBooks, and 1 Visio eBook

This computer ebook site hosts 11 Office eBooks: 4 Excel ebooks, 6 Access ebooks, and 1 Visio ebook. To find these ebooks, simply do a Find command in your browser (Edit->Find on menu, or Ctl+F) and type in the keyword ‘Excel’, ‘Access’, or ‘Visio’.


4 Excel eBooks:
Excel – All Features
Excel – Macros and VBA

6 Microsoft Access eBooks:
Access – All Features
Access – with SQL Server
Access – Database Design
Access – Programming
Access – with VB .NET

1 Visio eBook:
Visio – All Features



Tags for this post>> | | | |

March 18, 2010

99-slide Access 2007 Tutorial

Here is a Microsoft Access 2007 Tutorial in a 99-slide presentation format (ppt, 2.2mb), at the University of the Incarnate Word. This Access tutorial gives you insight and understanding on all of the important features of Access 2007, and demonstrates topics such as defining tables, queries, reports, and forms. This Access tutorial also teaches database planning; and developing tables from table templates, from manual entry,from external data, and in the Design view. The documents essential to complete the exercises for this tutorial can be downloaded from here.


Access 2007 Tutorial
 - Definitions
 - Planning a Database
 - Creating a Table
 - Relationships
 - Queries
 - Forms
 - Reports



Tags for this post>> |

March 17, 2010

Access 2003 Tutorial

Here is a 90-page Microsoft Access 2003 Tutorial, at University of the Incarnate Word, containing all you ever wanted to know and learn about Access. This Access tutorial covers various topics that include: creating a database with the table wizard, defining tables, queries, reports and forms, database planning, developing tables, creating relationships, running queries, creating forms, generating reports and creating charts. This document is in pdf format and is 2.02 mb in size.

Access 2003 Tutorial
 - Definitions
 - Planning a Database
 - Creating a Table in Design View
 - Create a Table Using External Data (Excel)
 - The Primary Key
 - Relationships
 - Queries
 - Forms
 - Reports



Tags for this post>> |

January 21, 2010

eBooks on Office, Excel, Access, Powerpoint, and Project


Update: Here are 7 more Microsoft Office eBooks, covering Excel, Word, Access, PowerPoint, and Project. The first 3 are in Windows Help format (chm) and the last for are in pdf format.


 - Excel ebook

 - Word ebook

 - Microsoft Access ebook

 - Powerpoint 2003 ebook

 - Microsoft Project 2003 ebook

 - Microsoft Office 2003 ebook

 - Microsoft Office 2007 ebook

Here are 10 eBooks covering Microsoft Office, Excel, Access, and Project.


 - Excel 2003 ebook 1
 - Excel 2003 ebook 2
 - Excel 2003 Programming ebook 1
 - Excel Programming ebook 2

 - Microsoft Office 2003 ebook 1
 - Microsoft Office 2003 ebook 2

 - Microsoft Access 2003 ebook 1
 - Microsoft Access 2003 ebook 2
 - Microsoft Access 2003 ebook 3

 - Microsoft Project 2003 ebook



Tags for this post>> | | | | |

October 26, 2009

Microsoft Access Tutorial

Here is a Microsoft Access Tutorial, at Orbit Computer Solutions, that teaches you how to use Access, Microsoft Office’s database application. This Access database tutorial covers creating new databases, and creating and managing tables. The topics include how-to screenshots that help explain what is being described.


Getting Started With Access 2007
Here you will get a quick introductory tour through the world of Microsoft Access 2007.

 - The Microsoft Office Button
 - The Ribbon
 - Quick Access Bar


How To Create A New AccessDatabase
In this section of the tutorial, you will be able to learn how to create a new database in MS Access 2007. You will also learn about new database terms like query, recordset, forms and reports.

 - Database Terms
 - Query
 - Record Set
 - Forms
 - Report
 - How To Create A New Database
 - How To Create A New Database Using Templates


How To Create an Access Table
In this section of the tutorial, we are explaining about creating a table inside the Access database. Adding new fields to the tables. editing and formatting data types are also explained.

 - Table View
 - Design And Datasheet View
 - How To Add New Fields
 - How To Add New Fields In Design View
 - How To Edit Data Types In Fields
 - How To Format Data Types In Design View


Managing Tables
In this final section you will learn how to manage the tables which you created in MS Access.

 - How To Rename A Table
 - How To Add A Description In A Table



Tags for this post>> |

October 14, 2009

13 Access 2007 Tutorials

These 13 Microsoft Access 2007 Tutorials, hosted by the University of Florida, will help demonstrate the features and functionality of Access. Access 2007, the latest version of Access from Microsoft, is a relational database management system that combines a database engine with a graphical user interface. The Access tutorials, in the format of handouts and notes, will help increase your skills using its features such as Forms, Forms, Reports, Relationships, Select Queries, and Tables. These Access 2007 tutorials are in .doc format and can be downloaded and saved for later reference.


13 Microsoft Access 2007 Tutorials:

 - Access 2007  (1.08 Mb, 30 slides)
 - Basics Handout  (372 Kb, 11 pages)
 - Basics Notes  (4.43 Mb, 23 pages)
 - Forms & Macros Handout  (340 Kb, 11 pages)
 - Forms Handout  (639 Kb, 14 pages)
 - Intro Forms & Reports Handout  (1.25 Mb, 20 pages)
 - Intro Forms & Reports Notes  (37 Kb, 3 pages)
 - Queries II Handouts  (756 Kb, 24 pages)
 - Relationships Handout  (263 Kb, 13 pages)
 - Reports Handout  (206 Kb, 10 pages)
 - Select Queries Handout  (902 Kb, 16 pages)
 - Tables Handout  (756 Kb, 26 pages)
 - Tables Notes  (29 Kb, 3 pages)



Tags for this post>> |

October 12, 2009

15 Access 2003 Tutorials

Here are 15 Access 2003 Tutorials, at the University of Florida, that discuss various features of Access 2003 that make it a useful relational database management application. These Access tutorials, in the format of handouts and notes documents, show users how to use Access 2003 features such as Forms, Reports, Relationships, Select Queries, and Tables. The Access tutorials are easy to understand and follow, and are in .doc format so you can use them later offline.


15 Access 2003 Tutorials:

 - Basics Handout  (197 Kb, 10 pages)
 - Basics Presentation  (738 Kb, 30 slides)
 - Basics Notes  (4.83 Mb, 23 pages)
 - Forms & Macros Handout  (2.91 Mb, 10 pages)
 - Forms Handout  (316 Kb, 11 pages)
 - Intro Forms & Reports Handout  (386 Kb, 16 pages)
 - Intro Forms & Reports Notes  (27 Kb, 2 pages)
 - Queries II Handouts  (547 Kb, 22 pages)
 - Queries II Notes  (28 Kb, 3 pages)
 - Relationships Handout  (286 Kb, 14 pages)
 - Reports Handout  (165 Kb, 10 pages)
 - Select Queries Handout  (287 Kb, 14 pages)
 - Select Queries Notes  (53 Kb, 4 pages)
 - Tables Handout  (345 Kb, 18 pages)
 - Tables Notes  (25 Kb, 2 pages)



Tags for this post>> |

August 29, 2009

2 Microsoft Access 2007 Tutorials

Here are two Microsoft Access Tutorials, at the University of Minnesota, which describe and demonstrate the basics of Access, the new features of Access 2007, building effective databases, and how to manage them. These Access tutorials also teach advanced database features and development techniques, for both beginning and advanced users. They will help you understand the nuances of Access and assist you with working more efficiently with it.


Access 2007 Course Tutorial: Database Development  (4.19 Mb, 170 pages)
This course tutorial introduces users to skills necessary for creating and editing databases and demonstrates some of the features of Relational Database Design.

 - LESSON 1 - INTRODUCTION TO DATABASES
 - LESSON 2 - BUILDING A DATABASE IN ACCESS
 - LESSON 3 - SETTING FIELD PROPERTIES
 - LESSON 4 - CREATING RELATIONSHIPS
 - LESSON 5 - MODIFYING TABLES AND RELATIONSHIPS
 - LESSON 6 - CREATING INTERFACES TO INTERACT WITH DATA
 - LESSON 7 – EDITING A FORM
 - LESSON 8 – QUERIES
 - LESSON 9 – REPORTS
 - LESSON 10 -FINAL TOUCHES
 - APPENDIX A - USING THE LABEL REPORT WIZARD
 - APPENDIX B - CREATING A QUERY USING AGGREGATE FUNCTIONS
 - APPENDIX C - EXPORTING QUERY RESULTS
 - APPENDIX D - CREATING A MEMBER ADDRESS REPORT USING THE WIZARD
 - APPENDIX E - EXPORTING A REPORT


Relational Database Design Tutorial  (111.59 Kb, 18 pages)
This course tutorial introduces users how to create and maintain Relational Databases. This tutorial compares the tradition flat file databases with relational databases and also teaches how to design and normalize relational databases.

 - Relational Database Design
    - Flat File Databases vs. Relational Databases
    - Term Definitions
 - Designing a Relational Database System
    - Normalizing a Database
 - Take Home Practice


Class Files (.zip)
Here is a downloadable zip file containing the required resources to complete this Access database development course.
 - Access 2007: Basic Database Development



Tags for this post>> |

June 6, 2009

6 Access 2003 Tutorials

Here are 6 Microsoft Access 2003 Tutorials from the University at Albany. These Access tutorials teach a range of concepts and techniques that are essential for anyone working with and managing Access databases. They cover topics from the basics to the advanced level, which include table design, its capabilities, data entry forms, report design and using the select query. These Access database tutorials cover the essential workflow for any user to get started and be comfortable with Microsoft Access.


6 Access 2003 Tutorials:

Access 2003 Introduction I: Introduction & Concepts – 2 1/2 hrs
This tutorial teaches basic database concepts and how they can be used. The topics covered in this tutorial include the definition of a Relational Database and the database components.

Access 2003 Introduction II: Basic Table Design and Capabilities – 2 1/2 hrs
This tutorial explains how to build a simple database and places the focus on creation of tables, data types and primary keys for the tables.

Access 2003 Introduction III: Introduction to Data Entry Forms – 2 1/2 hrs
In this tutorial, you’ll learn about designing tables with attention to usability and organization of data such that it is easier to match the form to the table and organize the fields.

Access 2003 Introduction IV: Introduction to Select Queries – 2 1/2 hrs
This tutorial shows how to retrieve data from a database, including sorting fields, single and multiple search criteria.

Access 2003 Introduction V: Introduction to Report Design – 2 1/2 hrs
This tutorial demonstrates how to generate a report from the database using the retrieval queries.

Access 2003 Intermediate I: Importing and Exporting Data and Action Queries - 2 1/2 hrs
This tutorial teaches how to import and manipulate data that is from a database other than Access. In this example, data has been imported form an Excel sheet



Tags for this post>> |

May 9, 2009

Microsoft Access Tutorials

These Microsoft Access Tutorials at nicetutz.blogspot.com teach you database concepts and how to use Access. The Access tutorials cover the six types of Access objects and show you the advantages of using a database, how to design and modify the database, and how to feed the data in the database.


Introducing MS-Access 2007
These introductory tutorials on MS-Access 2007 covers the types of access objects and essential database concepts.

 - Six Types of Access Objects
 - Essential Database Concepts


Using an Access Database
These Access database tutorials cover the advantages of a computer database, database basics, designing an Access database, editing and modifying an Access database, and closing and saving a database.

 - Three Main Advantages of Computer Database
 - Understanding the Basics of Database
 - Designing a Database
 - Editing and Modifying Database
 - Typing Data into Database
 - Closing and Saving Database



Tags for this post>>

April 1, 2009

Microsoft Access Tutorial

This illustrated Microsoft Access Tutorial from Brown University discusses how a database works, describes the Access GUI, and the usage of queries in Access. The basics of Access are covered in this tutorial, which include creating a blank database, table creation and formatting, importing and exporting external data, SQL queries and the relationship between tables in Access. Also provided are examples with screen shots which help better demonstrate these and other features of Microsoft Access.


Features taught by this Microsoft Access Tutorial:


Key Terms used in Microsoft Access:
This section lists the generic terms used in database and Access.

Creating a New Database in Microsoft Access:
 - Blank Access database

Screen Layouts in Microsoft Access:
This section talks about different screen layouts available in Access.

Creating Tables in Microsoft Access:
Creating tables in Microsoft Access is detailed here.

Formatting Tables in Microsoft Access:
 - Adding and Deleting Columns
 - Resizing Rows and Columns
 - Freezing Columns
 - Hiding Columns

Importing/Exporting from External Data in Microsoft Access:
 - Importing from Excel
 - Exporting is done in a similar fashion

Locating Specific Information in Microsoft Access:
 - Finding Data in a Table
 - Replacing Data
 - Check Spelling and AutoCorrect

SQL Queries in Microsoft Access:
 - Create a Query in Design View

Relationships between Tables in Microsoft Access:
This section expalins database relationships in Access with screenshots.

Simplifying Data Entry with Forms in Microsoft Access:
Access provides an easier way to modify the records. This section discusses that.



Tags for this post>>

March 30, 2009

17 Access 2007 Database Tutorials

Here are 17 Microsoft Access 2007 Database Tutorials hosted by bukisa.com. Access is Microsoft’s database management application with a graphical interface. These Access Tutorials cover many Access features and concepts, including table creation, database template creation, and database access options. The tutorials also provide an general overview of the Access database, and details on database objects, and adding custom commands in the Access toolbar. 


17 Access Tutorials:

 - How to Convert Older Version of Microsoft Access Database
 - How to Create a Table in a Microsoft Access Database
 - How to Use the Database Tools Tab in Microsoft Access 2007
 - Overview of Microsoft Access 2007 Database – Access Options
 - How to Use the Create Tab in Microsoft Access 2007
 - How to Use the Home Tab in Microsoft Access 2007- Part 1
 - How to Use the Office Menu in Microsoft Access 2007
 - How to Use the External Data Tab in Microsoft Access 2007
 - How to Create a Microsoft Access 2007 Database Template
 - How to Use the Home Tab in Microsoft Access 2007 – Part 2
 - Overview of Microsoft Access 2007 Database Objects
 - How to Build a Microsoft Access 2007 Database
 - Overview of Microsoft Access 2007 Database
 - How to Enable the Security Warning in Microsoft Access 2007
 - Overview of Microsoft Access 2007 Database Templates
 - How to Add Custom Commands in the Quick Access Toolbar
 - How to Customize the Navigation Pane of Microsoft Access



Tags for this post>>

October 9, 2008

2-page Microsoft Access Quick Reference Card

Here is a Microsoft Access Quick Reference Card, hosted by Purdue University. This Access support document is 2 pages in length, is in pdf format, and its file size is 285kb. The Access database features and topics covered by this quick reference are listed below.


Access Features Described:

The Standard Toolbar

Keyboard Shortcuts:
  – General
  – Navigation – Go To
  – Editing
  – Design View
 
Working with Database Objects:
  – Tables
  – Queries
  – Forms
  – Reports
  – Pages
  – Macros
  – Modules

Working with Data:
  – The Datasheet Toolbar
  – The Navigation Bar:
     – Add a new record
     - Select a record
     - Delete a record
     - Find and Replace data in a table
     - Sort data
     - Filter by Selection
     - Filter by Form

Forms and Reports:
  – Create a Form with a Wizard
  – Create a Report with a Wizard
  – Toggle between Form/Report and Design View

Creating and Designing Tables:
  – Create a New Table with a Wizard
  – Create a New Table from Scratch
  – Data Types

Queries:
  – Create a Select Query
  – Switching Views
  – Caculate Total Values
  – Query Examples


Tags for this post>>

August 24, 2008

12 Illustrated Access Tutorials

Here are 12 excellent Access Tutorials hosted by mstipsandtricks.com. Microsoft Access is a relational database management application that is used for both business and home tasks for keeping track and reporting data such as mailing lists, phone and contact lists, product and sales data, and other sets of information for which Access can be helpful in managing. These Access tutorials will teach and show what you can do with MS Access using screen shots and numbered steps. Access features and topics covered include Databases, Customization, Table, Forms, Queries, Reports, Database Tools, External Data Retrieval and Export, Sorting and Grouping, and new features of Access 2007.


12 Illustrated, Step-by-Step Access Tutorials:

Create Databases
Learn how to create new databases using Access.

Access Table Creation
Relational databases usually contain more than one table and each one contains a fixed number of fields. This Access tutorials teaches you how to create and use tables that are used to store your data.

Entering, Manipulating Data and Table Relationships in Microsoft Access
This short tutorial explains how enter, manipulate data and also about table relationships in MS Access.

Working with Data: Inserting, Deleting, Updating, Sorting and Grouping
When you add or remove a column from a datasheet, you add or remove a field from the table that underlies the datasheet. If that field contains data, you also eliminate that information. Learn how to update, remove, sort and group data using Access.

Queries in Microsoft Access  
This short tutorial explains how queries work in MS Access. 

Create Queries
Database normalization is the process to organize the data of a data base. Learn how to create queries in Access to retrieve data that is normalized.

Database Tools
This step-by-step tutorial explains how to use database tools in Access.

Getting External Data – Import and Export
This Access tutorial shows how to exchange data to and from Access tables. The simplest method is to copy them and paste, but importing and linking permits better control and flexibility.

Access Forms Tutorial
A form is a database object that can be used to write, to modify or to show the data of a table or queries. Find out how Access forms are used to control access to the data.

Access Report Tutorial
Reports summarize and present data stored on tables. Learn how to create and configure Access reports so database users can easily see the current state of the stored information.

New Features of Microsoft Access 2007
Microsoft Access 2007 presents a new user interface and design that do not require a great understanding how database internals work. It hopefully makes the creation and management of data using Access easier and faster. 

Programming with Access 2007
Access Macros are similar to a simplified programming language wenclose hich is used to increase the functionality of the database. For example, you can embed a macro command in a form’s button, and then the macro is executed when the user clicks on the the button.


Tags for this post>>

July 16, 2008

Tips and Articles for Microsoft Access

Here are several informative, free Access Tips, Techniques, and Articles for Beginning, Intermediate, and Advanced Microsoft Access users, from 599cd.com, which is a fee-based training site. These will help you learn how to use many important features and functions of Access so you can manage and present your data more efficiently. Some of these include: Parameter Queries, Forms Control, Calculated Query Fields, Time/Date Differences, Update Queries, Working with Relational Tables, Aggregate Queries, Using Two Combo Boxes, the DLookup Function, the IIF Function, and Many-to-Many Relationships.


Beginner Access Tips:

Creating a Parameter Query
   Entering criteria at run-time
String Concatenation
   FirstName & LastName together
Different Form Controls for Gathering User Input
Calculated Query Fields
   LineTotal: Price * Quantity
Form Control Wizards Not Starting


Intermediate Access Tips:

Number of Months Alive
   DateDiff, DateAdd, IIF, Round
Form Footer Totals
   Sum up the values on a form
Time/Date Differences
   Calculate the difference between two times/dates
Building an Update Query
   Changing field values automatically
Using a Relational Combo Box
   Selecting a customer on a related form
Making Relational Tables
   Proper Normalization Techniques
Getting Query Criteria from a Form
  Forms!FormName!Field Notation
Creating an Aggregate Query
   Adding up customer sales in a query


Advanced Access Tips:

Using MsgBox and vbYes to Close a Form
   Form Properties
Breaking Up Text Strings
   InStr, Replace, Left, Right, Trim
Incrementing Your Own Counter
   DMax Function, BeforeInsert Event
AfterUpdate Event
   Running VBA code after a field value is changed
Two Combo Boxes
   Filter one combo box by value selected in the other
Using the DLOOKUP Function
   Changing fields after pick a customer
Using the IIF Function
   Add IF/Then functionality to queries
Prevent Duplicate Values on Multiple Fields
  BeforeUpdate event
Resize a Form using VBA Code


Access Learning Articles:

Access Tip: MsgBox with vbYes
Access: Removing THE From Title Sorts
Access: Next Business Day
Access: Reading Outlook Calendar Data
Access: Recordset, File I/O Example
Access: Many-To-Many Relationships
Access: Checking a Sequence of Numbers
Access: Daylight Savings Time
Access: Recordsets & Inventory
Access: Calculate 2nd Monday in January


Tags for this post>>

July 2, 2008

Free Courseware for Microsoft Office

Rai OpenCourseware offers freely available course content, or courseware, which is literally a “treasure trove of knowledge and related resources”.  Their Computing Courses provide higher education and learning for Information Technology to all students and professionals who like to study and learn on their own. Educational institutions can also use this free course content.

Here is Rai OpenCourseware’s Microsoft Office Training, that will teach you several important features of using Word, PowerPoint, Excel, and Access. These free Office training tutorials are well illustrated and provide step-by-step instructions for using these applications. The course tutorials are in pdf format and are also available here, here, and here.


Basic Concepts Of Computers

 - Computer Organisation
 - Operating System
 - Microsoft Office Overview
 - Introduction Word Processing


Getting Started With Microsot Word

 - Formatting Paragraphs
 - Styles
 - Tables
 - Macros
 - Mail Merge


Introduction To Microsoft PowerPoint

 - Adding Content
 - Color Scheme
 - Master Slides


Introduction To Microsoft Excel

 - Formulas and functions
 - Charts
 - Paper properties and printing


Microsoft Access

 - Table Relationships
 - Queries
 - Forms
 - Reports
 - Importing, Exporting, Linking


Tags for this post>> | |

June 21, 2008

Getting Started Handouts for Word, Excel, PowerPoint, & Access

Here are 4 Getting Started With Training Handouts covering Word, Excel, PowerPoint, and Access, from  the University of Texas. If you need to learn more about these applications’ basic features and tasks, then these will help you do that.


Getting Started with Microsoft Word
This handout provides an introduction to Microsoft Word’s basic functionality. It covers starting Word, the Word interface, creating a Word document, editing a Word document, selection techniques, paragraph and character formatting, spell checking, printing, graphics and tables.

Getting Started with Microsoft Excel
This handout introduces the basic features of Microsoft Excel. It shows how to enter and edit data, perform formatting, enter formulas, do page setups, and print spreadsheets.

Getting Started with Microsoft PowerPoint
This handout introduces the basic features of Microsoft PowerPoint and shows how to create simple presentations, along with and editing and formatting your PowerPoint slides.

Getting Started with Microsoft Access
Microsoft Access is a relational database application with which you can efficiently save and retrieve data in many formats. This handout explains how to navigate the Access interface, create simple tables and queries, and relate information from one table to another.



Tags for this post>> | | |

Next Page »