1.0.0 Microsoft Access Tutorial

This Microsoft Access tutorial is aimed at anyone who wishes to learn how to use Microsoft Access. It assumes a basic understanding of databases and how they work.

Table of Contents

This tutorial consists of the following lessons

1. Opening the Microsoft Access
2. Create A New Blank Database 
3. Create A Table in Design view
4. Create A Table using wizard
5. Create A Table by entering Data
6. Create A Relationship
7. Create A Query In Design View
8. Create A Query By Using Wizard

Explanation:

Week 1 - Data Analysis and Database Design
For Week 1, Miss Ayuni had explained on the topics about the sub topic we should be learning. Apart from that Miss Ayuni also already explain about marking for Data Analysis subject and Database Design (DADD) .
Miss Ayuni had also ordered we to divide a group .
Starting with chapter 1 .
Carry Mark
Report 1 : Table & Relationship
Report 2 : Query
Report 3 : Form
Report 4 : Report
Quiz 1 : 5%
Quiz 2 : 5%
Mid Term : 10%
Project(system) - Presentation : 10%
Final Report : 10%
Final Exam : 100% = 40%

Week 2 - Chapter 2
Enter chapter 2 for Data Analysis subject and Database Design (DADD).
Miss Ayuni have explained in detail on way to take Micosoft Access .
Stage by stage have shown to facilitate our learning process .

1.0.0.1 Definition of Data Type & Field Properties

Data Type

Text
Text, number, or a combination up to 255 characters

Memo
Similar to the text field, can contain text, numbers, or a combination up to 2 GB of data.

Number
Numbers up to 16 bytes of data

Date/Time
Date and Time information

Currency
Currency up to 8 bytes and precise to 4 decimal places

AutoNumber
Access creates a unique number for each new record. This is often the primary key for the table

Yes/No
Yes and No, stored as -1 for yes and 0 for no

OLE Object
Images, documents, graphs up to 2 GB

Hyperlink
Web addresses

Attachment
Attachments such as images, spreadsheets, documents, and charts.

Field Properties


Field Size : The maximum number of character you can enter in the field. The largest maximum you can set is 255. Press F1 to hlp on field size

Caption : The label text that is displayed for this field by default in forms, reports, and queries. If this property is empty, the name of the field is used. Any text string is allowed.

Decimal Places : Specifies the number of decimal places to use when displaying numbers.

Default Value : Automatically assigns the specified value to this field when a new record is added.

Format : Determines the way that the field appears when it is displayed or printed in datasheets or in forms or reports that are bound to the field. You can use any valid number format. In most cases, you should set the Format value to Currency.

Indexed : Specifies whether the field has an index (index: A feature that speeds up searching and sorting in a table based on key values and can enforce uniqueness on the rows in a table. The primary key of a table is automatically indexed. Some fields can't be indexed because of their data type.). There are three available values:

Yes (No duplicates) : Creates a unique index on the field.
Yes (Duplicates OK) : Creates a non-unique index on the field.
No Removes any index on the field.

Input Mask : Displays editing characters to guide data entry. For example, an input mask might display a dollar sign ($) at the beginning of the field.

Required : Requires that data be entered in the field.

Smart Tags : Attaches a smart tag to the field.
Text Align Specifies the default alignment of text within a control.

Validation Rule : Supplies an expression that must be true whenever you add or change the value in this field. Use in conjunction with the Validation Text property.

Validation Text : Enter a message to display when a value that is entered violates the expression in the Validation Rule property.

1.0.1 Opening the Microsoft Access

STEP 1 (Opening the file)

1.0.2 Create a New File

STEP 1  (CREATE A NEW BLANK DATABASE)

 STEP 2 (CREATE A FILE NAME)

1.0.3 Create A Table in Design view

STEP 1 (CREATE TABLE IN DESIGN VIEW)

STEP 2 (INSERT FIELD NAME  & RIGHT CLICK TO ADD...)

(PRIMARY KEY OR...)

(INSERT ROW OR...)

(DELETE ROWS)

STEP 3 (SAVING TABLE NAME)

1.0.4 Create A Table using wizard

STEP 1 (CREATE TABLE BY USING WIZARD)

STEP 2 (SELECTING THE SAMPLE)

STEP 3 (RENAME THE TABLE)

STEP 4 (NEXT)

STEP 5 (TICK IN THE MIDDLE & CLICK FINISH)

STEP 6 (RESULT)

1.0.5 Create A Table by entering Data

STEP 1 (CREATE TABLE BY ENTERING DATA)

STEP 2 (DOUBLE “CLICK” A  FIELD TO CHANGE IT NAME)