CS281 Fall 2010
Lab Handout # 1
Microsoft ACCESS 2000: GETTING STARTED
Frequently Used Terms in Microsoft Access 2000
is a collection of related information.
is a building block of the database such as a table, query, form, or macro.
organizes and stores related data in the forms of fields (columns) and records (rows)
on a datasheet. Many tables can be stored in a single database.
is a column on a table and defines a data type for a set of values in the table. For a
table that stores personal information about students; first name, last name, address,
telephone number, major, etc. are fields of the table.
is a row on a table and is a set of values defined by fields. In a student personal
information table, each record would contain the data for one student as specified by the
Microsoft Access 2000 Objects
A Microsoft Access 2000 database may contain the following objects:
store data items in a row-column format similar to that used by spreadsheet applications
(i.e. MS Excel). An Access database can include as many as 32,768 objects (the combinations of
tables, forms, reports, queries and so on), as many as 1,024 tables can be open at a time if you have
sufficient resources available.
display selected data contained in as many as 16 tables. With queries, you can specify
how to present data by choosing the tables that comprise the query and as many as 255 specific
fields (columns) of the chosen tables. You determine the records (rows) to display by specifying the
criteria that the data items in the query data must meet to be included in the display.
display data contained in tables or queries and enable you to add new data and update or
delete existing data. You can incorporate pictures, graphs, and sound in your forms.
print data from tables or queries in virtually any format that you want.
allow collaboration with Microsoft Access data on the Internet or an intranet.
automate Access operations by writing programming codes to perform specific actions
in response to user-initiated events, such as clicking a command button.
contain Access VBA (Visual Basic for Applications) code that you write to handle
events such as clicking a command button in a form, to create customized functions for use in forms,
reports, and queries, and to otherwise automate database operations. By adding Access VBA code to
your database, you can create complete database applications with customized menus, toolbars, and
other features. Access VBA code enables you to programmatically control many database options
and operations you can't control with a macro.