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.

Popularity: 26% [?]