Here are two Microsoft Access Tutorials and two Access Slide Presentations from The University of Utah. The two Access tutorials provide step-by-step instructions, along with screenshot graphics to demonstrate both beginning and advanced features of Access.
Access Basics Presentation (11 Powerpoint slides 67kb)
– Definitions
- Data Integrity
– Access vs. MS Excel
- Examples
– Access vs. MS Excel
2003 Access Basics Tutorial (7 pages, pdf format, 594kb)
Contents of Microsoft Access Tutorial: The Basics:
Part 1: Starting MS Access and the Database Wizard
Part 2: Database Structure: Table Relationships, Fields, Primary Key,
Part 3: Viewing Your Data: Obljects, Tables, Queries, Forms, Reports, Assignment
Advanced Access Presentation (21 Powerpoint slides, 121 kb)
– Definitions
- Basic Database Design Principles
– Main Parts of Database Design
– Sample Database Scenario
- Database Mission Statement
– Mission Statement >>Tables
– Tables and Fields
- Fields in the Table
– Primary Key
- Foreign Keys
– What You Don’t Know Can Cause You Problems
– Access and its Templates Can Help You
Advanced Access Tutorial (9 pages, pdf format, 379kb)
Contents of Microsoft Access Tutorial: Advanced:
Part 1: Create Database
A. Primary and Foreign Keys, Table Design
B. Importing Data
Part 2: Implement Table Relationships
Part 3: Creating Forms and Modifying Queries and Reports
A. Creating and Modifying Forms
1. Creating Forms
2. Modifying Forms
3. Adding Records Using Forms
B. Modifying Queries and Reports
1. Modifying Queries
2. Modifying Reports
C. Setting Up Functions with Queries and Reports to Create a Count Query and Report
1. Create the Function Column in a Query
2. Run the Function in a Report
Part 4: Test Your Database
Part 5: Conclusion: Assignment – Design, create and modify MS Access forms, queries and reports and check to be sure that
The exercise files for this advanced Access tutorial are available:
– Calls.xls
- Contact.xls
- Employees.xls
Free Microsoft Office Training and Tutorial Resources:
|
||||||||
|
*Disclaimer: Due to the dynamic nature of the Internet, sites change content and location constantly. Links provided may no longer be available or may link to content that has changed. We do our best to edit or remove these links. www.eTutorial4All.Com cannot be held liable for content that is being linked to.