a. state the usage of application
b. list example which application of database is used
c. state the function of the features in database
d. create a new database
Knowledge and Skills:
a. Students known the meaning and usage of database
b. Start Microsoft Access 2003
c. Create, Name and Save database file
d. Open existing database
e. Exit database application
Module Summary:
At the end of the module, students should be able to open, name, save file and close database.
Activity Summary: Activities involved:
a. Starting Microsoft Access 2003
b. Naming and saving file database
c. Opening existing database
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).
Method 2:
1. Click-on the Start button, then click-on Programs, then click-on Microsoft Access
2003 (Figure 1)
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.
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. Click–on Blank database. (Figure 3)
Introduction to Microsoft Access 2003
A File New Database menu screen, similar to the one below, will be on your screen. We’ll have to do several “things” to set-up this screen to save your database. ( 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)
5. Now click-on the Create button. (Step 3)
The following Students Profile: Database menu screen will appear.
( 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)
Method 2:
1. Click File in the Menu Bar, then click Open. (refer 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.
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.
There are 4 important objects as stated in the table below.
Objects Bar Function
Table 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.
Form Use to enter new information, to edit or remove existing information or to locate information.
Query 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.
Report Typically used to summarize, organize and analyze information in order to express a particular point of view to specific audience.
4. Click File and Exit to stop this session.
At the end of this activities, you had learned how to:
i. Create a database
ii. Close a database
iii. Open an existing database
No comments:
Post a Comment