preview

hgjk

Decent Essays
Open Document

Access teaching materials

1. Introduction

Access is a computerized Database Management System (DBMS) that enables you to store, retrieve, analyze, and print information. It is a system for managing large amounts of data. Companies use databases for many purposes: to manage customer files, to track orders and inventories, and for marketing purposes. An individual might set up a data base to track household expenses or manage a list of family, friends, and business addresses. Teachers often set up a database to track students’ grades ad other class information. A database enables the user to access and manage thousands of pieces of data in an organized, efficient, and accurate manner.

To begin using Access, there are a number of …show more content…

Solution: Click the View button again to return to the Design View. Click the Criteria box in the first column under Teacher name, and type Derek. Click Run! button to show the results with criteria of Teacher name = “Derek”

Question: What if I want to see the course ID start with BA (probably provided by the School of Arts)?

Solution: Blur searching: Like “BA*” – Match any collection of characters, e.g., BA1, BA52, BA4hy, etc. Click the View button to change to the Design view. Click the Criteria box in the first column under Course ID, and type Like “BA*”. Click Run! button to show the blur searching results .

3.2 Using Numeric Data in criteria

Table used: Students Use the comparison operators to set up the criteria conditions. The Comparison operators for numeric data comparison include:

=
Equal to

Not equal to
<
Less than
>
Greater than
=
Greater than or equal to

Question: What if I want to see the students who registered in 2003 and his/her entrance exam score is no less than 55?

Solution: Create a new query, and save it as “Query in Students table”. Select all fields by double clicking them. In the criteria box of Year, type 2003; and in the criteria box of Entrance Examinations, type >=55.

4. Report (Table: Students)

Creating a report using the report

Get Access
Related
Get Access