Transcript Document

There are seven main components of a database in Access 2000:
• Tables.
• Use tables to store database information.
• Forms
• Use forms to enter or edit the information in your tables.
(Forms let you view one record at a time).
• Reports.
• Use reports to deliver a professional presentation or written
report to your class.
• Queries.
• Filter data so that you retrieve selected records or fields.
• Pages.
• Create HTML pages from a database quickly and efficiently.
• Macros.
• Automate tasks that you perform on a regular basis in a database.
• Modules.
• Automate a group of related procedures.
Deletes selected
objects.
Standard toolbar
Provides options for
opening objects in your
database.
click one of these four
buttons to create or open
a database object.
Click Pages to create a
Data Access Page.
Changes how Access 2000
displays icons.
Click Find to search for a
record.
Use Sort Ascending and Sort
Descending to sort records by a
selected field.
Click View to switch
to Design view.
Click a box to select
a record.
Use these buttons to move
to different records in a
table.
Click New Record and
Delete Record to add or
delete records.
Click one of these
buttons to insert or
delete rows.
Use this button to
set or change your
primary key.
Click the Database
Window button to open
the main database
window.
Click View to switch to
Datasheet view.
Identifies the properties
of the currently selected
field.
Use this area to add notes to
yourself about each field.
Read this note for
information about the
currently selected
field.
This arrow appears when you click in any cell. Click
to view the drop-down list.
Change the color of the
font, background, or border
for any text box in the form.
Create a multi-page form when
you want to organize fields into
sub-categories.
Click Run to run your
query.
The tables that you base
your query upon appear
here.
Indicates when field listings
in a query results are
sorted.
Enter conditions for a
search in these last two
rows.
Check this box when you want a
field to show in the query results.
Enter the prompt in the criteria box.
Click these buttons to change the
order of the groups.
Use the Insert menu to
insert pictures or hyperlinks
into a report.
Add a title, pictures, and
hyperlinks in the report
header.
Click the Tools button
for the toolbar to
appear.
BookMarks
http://www.fed.qut.edu.au/tesol/bookmarks.html
Microsoft in Education
http://www.microsoft.com/education/default.htm
Microsoft Office Training Index
http://www.microsoft.com/education/tutorial/workshop/default.asp
Microsoft Access Training Site
http://www.microsoft.com/education/tutorial/classroom/o2k/access.asp
Titanic Database
http://www2.nexus.edu.au/Teachstud/titanic2/home/titic1.htm