Introduction to Microsoft Access 2010. Unit 4: Database Applications. What is a database?. A database is a collection of related information. Access is the Microsoft Office database program that enables you to organize, retrieve, and analyze data.
Unit 4: Database Applications
These computers are called GPS Devices, (global
positioning system) and they collect radio signals emitted
from government satellites in order to calculate the user’s
position and altitude. Then, they interface with
commercial databases and display information such as
where the closest automated teller machine is located
or how long it will take to get to a specific location.
Fingerprint identification technology is part of
the growing field of biometrics which identifies
people based on physical characteristics such
as DNA, fingerprints or retinal patterns.
During the summer of 2007 North Mississippi Wellness Center used a small biometric computer in order to read each member’s fingerprint. Members would put their finger on the biometric device in order for their fingerprint to be read. Once the device read the fingerprint, a picture of the member would appear on a computer monitor and the person was allowed to enter the Wellness Center.
looking through State and FBI files can take
as long as three weeks, but computer
database comparisons can make positive
identifications in only two hours if a
suspect is in custody.
The FBI receives
How Does The Structure Of A Database Compare To Documents Stored In A File Cabinet
**Resource: Penn State Information Technology Services
**Resource = Penn State Information Technology Services
Open Recent Database list
Additional database template categories from Microsoft Office Online
Select this button to create a blank Database.
Tables contain data (information) about a specific topic or subject; holds records
In order to create a table, select the View button from the Home tab. Most of the time, tables are created in Datasheet View or Design View.
The example below is Datasheet View.
Below Is An Example Of A Table Set Up In Design View. You Will Learn More About Design View As You Work In Access During The Next Few Weeks.
A Record is the information for a particular topic. In the above example, the information or “record” is for Johnny Mitchell. What are the first and last names of the other records in the table above?
A Field is a category of information that is stored about each record. In the above example the arrow is pointing to the field, First. What are the other field names in the example above?
Shutter Bar Open/Close Button
This Database Has the following Two Tables:
States and Tours
Each row is a record.
This Table is open in Datasheet View
Notice the two Close buttons
Click the TOP button to Close out of Access
Click the Bottom button to Close only the table. Access will remain open.
Access automatically saves new records and the changes you make to existing data (information) as soon as you move to another record or close the datasheet.
A form is an Access tool that allows you to arrange the fields of a record in any layout so you can enter, edit, and delete records with ease.
Below is an example of Form View.
In a datasheet, sometimes you have to scroll left or right to see all of the fields in the table. Often this is inconvenient, time consuming and confusing. A form solves these problems by allowing you to organize the fields on the screen in any arrangement.
Advantage of Using Forms
A Query in Access is a tool that lets you ask questions about the data (information) the database contains.
You build queries in an Access database to ask “questions” about data, such as which adventure tours are scheduled for June or what types of tours take place in California. Queries present the answer in a datasheet, which you can sort, filter and format.
A query allows you to select records from one or more table and then present the selected data as a single datasheet. A major benefit of working with data (information) through a query is that you can focus on the information you need to answer your questions.
Find out the names of students who have not turned in overdue library books.
The number of male students who have birthdays during certain months of the year.
List of students who are in accelerated classes.
Number of students who have been referred to the office during the previous month.
Number of students who checked out to go to the doctor during the previous month.