Intro to Access

Here are some videos to walk you through Access.

Pets: This is a good introduction to Access. It covers queries and reports.

Employers: This shows the value of the "Memo" field in Access. Excel limits the characters of a cell to 240, but Access can have multiple paragraphs within one field.

Specialty Foods: This demonstrates how to create queries with criteria, calculated fields, groups. It also covers reports and labels.

 

 

Grader Project

Files

Title

Description

Videos

Getting Started with Access Databases Grader Project [Homework]

A_CH01_GOV1_EOC

Campus Projects and Events

In this project, you will create a new Projects table in the Events database template, and then append data from Excel into it. You will then create a simple query, a form, and a report.

Sort and Query a Database Grader Project [Homework]

A_CH02_GOV1_EOC

Students and Scholarships

In this project, you will assist in using a database to answer questions about scholarships awarded to students. In doing so, you will set a relationship between two tables, create single-table and multi-table queries, and set criteria to present subsets of data. You will use text, numeric, and wildcard character criteria in your queries. Finally, you will create a crosstab query.

Access Grader Project 2

Forms, Filters, and Reports Grader Project [Homework]

A_CH03_GOV1_EOC

Career Books

In this project, you will create and modify forms and reports using various techniques. You will add data to a form, delete data from a form, and filter records using criteria.

In this project, you will create and modify forms and reports using various techniques. You will add data to a form, delete data from a form, and filter records using criteria.

Videos

 

 

BPA Competition

Business Professionals of America Database Competition

Business Professionals of America Database Competition

 

 

GMetrix

Complete the GMetrix practice certification exam.

Complete the GMetrix practice certification exam.