Lab1 - CS281 Fall 2010 Lab Handout 1 Microsoft ACCESS 2000 GETTING STARTED Frequently Used Terms in Microsoft Access 2000 A database is a

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
CS281 Fall 2010 Lab Handout # 1 Microsoft ACCESS 2000: GETTING STARTED Frequently Used Terms in Microsoft Access 2000 A database is a collection of related information. An object is a building block of the database such as a table, query, form, or macro. A table 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. A field 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. A record 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 intersecting fields. Microsoft Access 2000 Objects A Microsoft Access 2000 database may contain the following objects: 1. TABLES 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. 2. QUERIES 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. 3. FORMS 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. 4. REPORTS print data from tables or queries in virtually any format that you want. 5. PAGES allow collaboration with Microsoft Access data on the Internet or an intranet. 6. MACROS automate Access operations by writing programming codes to perform specific actions in response to user-initiated events, such as clicking a command button. 7. MODULES 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.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
BASICS: CREATING A NEW DATABASE AND TABLES Creating a New Database: 1) From the Start menu, go to Programs and select Microsoft Access.
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/19/2011 for the course CS 102 taught by Professor David during the Fall '08 term at Bilkent University.

Page1 / 8

Lab1 - CS281 Fall 2010 Lab Handout 1 Microsoft ACCESS 2000 GETTING STARTED Frequently Used Terms in Microsoft Access 2000 A database is a

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online