Access Tutorial Help Files

The following 4 files will end up in the lab manual that students in future semesters will purchase as part of the course (and prior semesters had to purchase this same material as well). Please download and read each of the following files. Activities that you are doing in your Access assignment can also be found in these files.

Designing Database Applications

Provides specific details on how to design relational database applications. Topics covered include:

· Entities and data relationships

· Documenting logical data relationships

· The relational database model

· Normalization

Basic Skills and Tools Using Access 2007

Focuses on creating a Microsoft Access database file. Topics covered include:

• Creating a new database file
• Create and modify tables

Problem Solving Using Access 2007

Provides a comprehensive tutorial on how to query a database in Microsoft Access 2007. Queries are essential for problem solving; allowing a user to sort information, summarize data (display totals, averages, counts, and so on), display the results of calculations on data, and choose exactly which fields are sown. Topics covered include:

• Creating simple queries
• Advanced queries using calculated fields
• Formatting results displayed in calculated fields

Creating Forms and Reports Using Access 2007

Topics covered include:

• Creating, modifying and running forms
• Creating, modifying and running reports