{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

lab1 - CS281 Fall 2010 Lab Handout 1 Microsoft ACCESS 2000...

Info icon This 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.
Image of page 1

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

View Full Document Right 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.
Image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern