Scribd Logo
Upload

Welcome to Scribd!

  • 316 views

    RM 2 - Working With Tables

    Uploaded by

    Jeff Lacasandile
    This document provides an introduction to working with tables in Microsoft Access. It explains that tables are the most important component of an Access database, as they store all information. Tables consist of fields (columns) and records (rows). Different field types store different data types like text, numbers, dates, and more. The document discusses how to create a database file and table, set a primary key, edit records, and modify a table's appearance. Overall, it serves as a guide for getting started with the basic structure and components of an Access database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    RM 2 - Working With Tables

    Uploaded by

    Jeff Lacasandile
    316 views2 pages
    This document provides an introduction to working with tables in Microsoft Access. It explains that tables are the most important component of an Access database, as they store all information. Tables consist of fields (columns) and records (rows). Different field types store different data types like text, numbers, dates, and more. The document discusses how to create a database file and table, set a primary key, edit records, and modify a table's appearance. Overall, it serves as a guide for getting started with the basic structure and components of an Access database.

    Original Title

    RM 2 - Working with Tables

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an introduction to working with tables in Microsoft Access. It explains that tables are the most important component of an Access database, as they store all information. Tables consist of fields (columns) and records (rows). Different field types store different data types like text, numbers, dates, and more. The document discusses how to create a database file and table, set a primary key, edit records, and modify a table's appearance. Overall, it serves as a guide for getting started with the basic structure and components of an Access database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    316 views2 pages

    RM 2 - Working With Tables

    Uploaded by

    Jeff Lacasandile
    This document provides an introduction to working with tables in Microsoft Access. It explains that tables are the most important component of an Access database, as they store all information. Tables consist of fields (columns) and records (rows). Different field types store different data types like text, numbers, dates, and more. The document discusses how to create a database file and table, set a primary key, edit records, and modify a table's appearance. Overall, it serves as a guide for getting started with the basic structure and components of an Access database.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    Supplementary Learning Material Grade 10 Week 3

    Working with Tables


    I. Introduction
    With other office application such as Word, Excel, and PowerPoint, you can often start
    working with blank document as soon as you have created one. While access, you often need
    to spend a lot of time planning and setting up the structure of the data base before you can
    actually begin to use it.
    II. Objectives
    1. Explain how create a Database File
    2. Understanding Tables and Creating a Table
    3. Creating a Primary Key
    4. Editing Records
    5. Modifying Table Appearance
    III. Discuss/Course Content

     The first step to use Access is to create a file folder where the database and its object will
    be saved. Then create and save a blank database file.
     While in Backstage view, you can create,open, and save database.
     Tables are considered as the most important component of an Access database because
    these tables are where all your information is stored. Tables in an Access database are
    similar in many ways to table in Excel.
     Most Access databases consist of more than one related table. Each table is made up of
    columns referred to as Fields and rows referred to as Records.
     A field is a way of organization information by the type of data. Each piece of information
    within a field is of the same type. Every record in a rows is a unit of information which
    corresponds to the Field Name.
     Each field in a table can be one several available field types.
    Numerical Data Types- These are numbers which have two fundamental two types:
    integers (positive or negative) and float. Integers are whole numbers while floats are numbers
    with decimal places.
    Auto Number- It is a unique number that is automatically created for each item added to
    a table.
    Currency- A currency field is text saved as a link to another document using the currency
    signs, commas, and decimal points.

    Saint John Bosco College of Northern Luzon, Inc.Page 1


    Hyperlink- A hyperlink data Date and Time Types- A date/time data type contains the
    date and time values for the years 100 through 9999. It can be formatted in different ways
    including general, long, and medium date/time.
    BinaryData Type- This is arbitrary data which can be an image, a program, or anything
    else.
    Lookup Wizard- The Lookup Wizard allows the usage of a value from another table or
    list by using a list-box or combo-box.
    Memo- A memo data type allows a large amount of text and numbers, such as notes or
    descriptions, to be used in field.
    OLE object- An OLE object is an object from another program (such as an Excel
    spreadsheet, a Word document, graphics, or sounds) that is linked or embedded in an Access
    table.
    Text- A text data type is a character field that can contain at most 255 characters.

    Saint John Bosco College of Northern Luzon, Inc.Page 2

    You might also like