Scribd
Upload
5 views2 pages

MS Access Practical Guide

This document is a practical guide for creating a Sales Management Database using Microsoft Access. It outlines the structures for Customer and Orders tables, including field names, data types, and descriptions. Additionally, it provides an example of a Student table with sample data.

Uploaded by

Alexander Michael
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views2 pages

MS Access Practical Guide

This document is a practical guide for creating a Sales Management Database using Microsoft Access. It outlines the structures for Customer and Orders tables, including field names, data types, and descriptions. Additionally, it provides an example of a Student table with sample data.

Uploaded by

Alexander Michael
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

MS Access Practical

Management Guide: Sales


Database
This document provides step-by-step instructions for creating a Sales Management Database using
Microsoft Access.

Customer Table Structure


Field Name Data Type Description

CustomerID AutoNumber Primary Key

FirstName Short Text First Name

LastName Short Text Last Name

Age Number Age

Gender Short Text Gender

Address Short Text Address

Tel Short Text Telephone

Email Short Text Email

Orders Table Structure


Field Name Data Type

OrderID AutoNumber (Primary Key)

OrderType Short Text

ItemName Short Text

Quantity Number

DeliveryAddress Short Text

DeliveryDate Date/Time

Amount Currency

TransportCost Currency
CustomerID Number (Foreign Key)

Student Table Example


StudentI FirstNa LastNam Age Gender Address Tel Email
D me e

12345 PAUL MIKE 20 MALE DOUALA 6745756 paul@g


20 [Link]

12346 MIKE BERNT 30 MALE BUEA 5745638 mike@g


29 [Link]

12347 JOY FLOUR 25 FEMALE TIKO 9876543 joy@yah


23 [Link]

[Link]

You might also like