Scribd Logo
Upload

Welcome to Scribd!

  • 427 views

    Microsoft Access - Module 1 - Intro

    Uploaded by

    infocom
    This document provides an introduction to Microsoft Access 2003, including how to start Access, create and name a database file, open an existing database, and exit the program. The key objectives are for students to learn the basic functions and features of a database, how to open, name, and save an Access file, and how to close the database application. Exercises include creating and saving a database called "Teachers Profile" and listing examples of common database applications.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd

    Microsoft Access - Module 1 - Intro

    Uploaded by

    infocom
    427 views7 pages
    This document provides an introduction to Microsoft Access 2003, including how to start Access, create and name a database file, open an existing database, and exit the program. The key objectives are for students to learn the basic functions and features of a database, how to open, name, and save an Access file, and how to close the database application. Exercises include creating and saving a database called "Teachers Profile" and listing examples of common database applications.

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides an introduction to Microsoft Access 2003, including how to start Access, create and name a database file, open an existing database, and exit the program. The key objectives are for students to learn the basic functions and features of a database, how to open, name, and save an Access file, and how to close the database application. Exercises include creating and saving a database called "Teachers Profile" and listing examples of common database applications.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    427 views7 pages

    Microsoft Access - Module 1 - Intro

    Uploaded by

    infocom
    This document provides an introduction to Microsoft Access 2003, including how to start Access, create and name a database file, open an existing database, and exit the program. The key objectives are for students to learn the basic functions and features of a database, how to open, name, and save an Access file, and how to close the database application. Exercises include creating and saving a database called "Teachers Profile" and listing examples of common database applications.

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 7

    ICTL for Secondary School - Microsoft Access Module

    MODULE I

    INTRODUCTION TO MICROSOFT ACCESS 2003

    Curriculum Development Centre Ministry of Education

    ICTL for Secondary School - Microsoft Access Module

    Name of Module: Learning Outcomes: a. b. c. d. Knowledge and Skills: a. b. c. d. e. Module Summary:

    Introduction to Microsoft Access 2003 Students should be able to: state the usage of application list example which application of database is used state the function of the features in database create a new database

    Students known the meaning and usage of database Start Microsoft Access 2003 Create, Name and Save database file Open existing database Exit database application

    At the end of the module, students should be able to open, name, save file and close database. Activity Summary: Activities in this module involved: a. Starting Microsoft Access 2003 b. Naming and saving file database c. Opening existing database d. Exercises Meaning of database

    A database is the computer equivalent of an organized list of information. Typically, this information has a common subject or purpose, such as the list of employees, phonebook guide or a classmates address book. Microsoft Access 2003 (Access 2003) is a database system management (database programs). It can store, manage, manipulate, analyze, retrieve, display or publish information from database.

    ICTL for Secondary School - Microsoft Access Module

    Activity 1: Starting Microsoft Access 2003 There are two methods to start / launch your Mircosoft Access 2003. Method 1: 1. Double click on the Mircrosoft Office Access 2003 shortcut on the Windows desktop (see below).
    Shortcut icon MS Access 2003

    Method 2: 1. Click-on the Start button, then click-on Programs, then click-on Microsoft Access 2003 (Figure 1)

    Figure 1

    Figure 2

    2. The following Access 2003 Getting Started Task Pane will appear on the right side of your Access 2003 screen. (refer figure 2) 3. In the Open area of the Access 2003 Getting Started Task Pane, click the left mouse button on Create a new file.

    ICTL for Secondary School - Microsoft Access Module

    Activity 2: To Name and Save Database File 1. The New File menu screen on the top will appear when you click the left mouse button on Create a new file. 2. Clickon Blank database. (Figure 3)
    Click here

    Figure 3

    A File New Database menu screen, similar to the one below, will be on your screen. Well have to do several things to set-up this screen to save your database. ( Figure 4 )

    Step 1

    Step 2

    Step 3

    Figure 4

    3. Click-on the small down arrow on the right. Choose My Documents to save by double clicking on the folder. Your selection should now appear in the Save in : area. (Step 1) 4. Next click-in the area to the right of File Name. Type-in the word students profile as shown at the bottom of the above image. (Step 2)

    ICTL for Secondary School - Microsoft Access Module

    5. Now click-on the Create button. (Step 3) The following Students Profile: Database menu screen will appear. ( Figure 5 )

    Figure 5

    6. Click File and click Exit to end this session and to close Ms Access 2003. Activity 3: Open Existing Access Database There are two methods to open existing database. Method 1: 1. Repeat Activity 1 to open Ms Access 2003. Once you have created a database, you will see your database in the Open portion of the Task Pane. 2. Click students profile. (refer Figure 6)
    Click students profile

    ICTL for Secondary School - Microsoft Access Module

    Method 2:

    Figure 6

    1. Click File in the Menu Bar, then click Open. (refer figure 7)

    Figure 7

    2. When the Open menu screen appears, click the small down arrow to the right of the Look in area and select My Documents.

    Select My Documents

    Click students profile

    3. Then click the name of your database (e.g. students profile.mdb) and then click Open. Note: You will notice in the Students Profile: Database menu screen, in the left border consist of objects bar: Tables, Queries, Forms, Report, Pages, Macros and Modules.
    Access window title bar Database window menu bar Database toolbar Database window toolbar bar

    Database window title bar Objects bar

    Database window

    Groups bar

    ICTL for Secondary School - Microsoft Access Module

    There are 4 important objects as stated in the table below. Objects Bar Function A collection of records that identify a category of data, such as Customers, Orders, or Inventory. Data inside a table is arrange by column name field and row named Record. Field A single characteristic or attribute of a person, place, object, event, or idea. Record A set of related field values. Use to enter new information, to edit or remove existing information or to locate information. Used to locate information, to view, change or analyze it in various ways. A select query retrieves data from one or more tables and displays the result in datasheet. A select query can be used to group record and calculate sums, counts, averages and other types of totals. Typically used to summarize, organize and analyze information in order to express a particular point of view to specific audience.

    Table

    Form

    Query

    Report

    4. Click File and Exit to stop this session. At the end of this activities, you had learned how to: i. ii. iii. Create a database Close a database Open an existing database

    In the next module you will learn how to design table and insert data. Exercises Question 1 Give two examples of database that you know. Question 2 Create a database named Teachers Profile. Save this file in My Document directory.

    You might also like