Scribd Logo
Upload

Welcome to Scribd!

  • 18 views

    Access 2010 Tutorial Setup

    Uploaded by

    Abhisek Mukherjee
    This tutorial provides an introduction to creating and using a Microsoft Access 2010 database. The database being constructed is for a basic sales system and contains 4 tables - Customer, Inventory, Employee, and Sale - with various attributes of different data types and sizes. Sample data is added to the tables to demonstrate how information can then be queried and reported on from the database.

    Copyright:

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

    Access 2010 Tutorial Setup

    Uploaded by

    Abhisek Mukherjee
    18 views2 pages
    This tutorial provides an introduction to creating and using a Microsoft Access 2010 database. The database being constructed is for a basic sales system and contains 4 tables - Customer, Inventory, Employee, and Sale - with various attributes of different data types and sizes. Sample data is added to the tables to demonstrate how information can then be queried and reported on from the database.

    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 tutorial provides an introduction to creating and using a Microsoft Access 2010 database. The database being constructed is for a basic sales system and contains 4 tables - Customer, Inventory, Employee, and Sale - with various attributes of different data types and sizes. Sample data is added to the tables to demonstrate how information can then be queried and reported on from the database.

    Copyright:

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

    Access 2010 Tutorial Setup

    Uploaded by

    Abhisek Mukherjee
    This tutorial provides an introduction to creating and using a Microsoft Access 2010 database. The database being constructed is for a basic sales system and contains 4 tables - Customer, Inventory, Employee, and Sale - with various attributes of different data types and sizes. Sample data is added to the tables to demonstrate how information can then be queried and reported on from the database.

    Copyright:

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

    Access 2010 Tutorial Setup

    This tutorial is an introduction to using Microsoft Access 2010. In this tutorial a database with 4 tables will be created, data added to these tables, queries created to obtain information from the database, and reports to display information from the database. The database being constructed is for a basic sales system and contains the following tables and attributes with the stated data types and sizes: Table Customer Attribute CustomerID CustomerFirstName CustomerLastName CustomerAddress CustomerSuburb CustomerCity CustomerPostCode CustomerPhoneNumber InventoryID InventoryName InventoryDescription EmployeeID EmployeeFirstName EmployeeLastName EmployeeExtension SaleID CustomerID InventoryID EmployeeID SaleDate SaleQuantity SaleUnitPrice Data Type AutoNumber Text Text Text Text Text Text Text AutoNumber Text Text AutoNumber Text Text Text AutoNumber Number Number Number DateTime Number Currency Size 50 50 50 50 50 4 15 Required Y Y Y Y N Y N N Y Y N Y Y Y N

    Inventory

    50 255

    Employee

    50 50 4

    Sale

    Y LongInteger Y LongInteger Y LongInteger Y Y Integer Y Y

    Notice that the names of each attribute are typed with no spaces between the words, but each new word starts with a capital. This is called CamelCase. Dont use spaces in field names because different database programmes treat these differently and it can also cause problems with creating queries later. Also notice that each attribute name has the table name in front of it. This is not always done, but is useful when the same field name may be used for different tables. For example, this database also has an Employee table where the employee name is included. By including the table name in front of the field name, it is easier to determine which field is being referred to when using queries and reports.

    Table Customer
    CustomerID

    Attribute
    CustomerFirstName CustomerLastName CustomerAddress CustomerSuburb CustomerCity CustomerPostCode CustomerPhoneNumber

    1 2 3 4 5

    Bill Bob Jane Sue Fred

    Smith Brown Green Cross Brown

    123 Dove Street Hillside 43 Sweet Road Riverside PO Box 780 PO Box 8249 9 Castle Grove

    Nelson Wellington Auckland Nelson Picton

    7055 6986 1436 7073 7125

    03123456 0274567898 04573953 03850345 0277684930

    Inventory
    InventoryID InventoryName InventoryDescription

    1 2 3 4 5 Employee
    EmployeeID

    Hammer Screwdriver Saw Spanner Pliers

    Phillips

    EmployeeFirstName

    EmployeeLastName

    EmployeeExtension

    1 2 3 4 5 Sale
    SaleID

    Joy Jack Gary Gail Lee

    Smith Trigger Wood Smith Drake

    123 124 125 126

    CustomerID

    InventoryID

    EmployeeID

    SaleDate

    SaleQuantity

    SaleUnitPrice

    1 2 3 4 5

    1 1 2 4 3

    1 3 2 4 4

    2 5 1 4 2

    12/1/12 6/2/12 14/2/12 28/2/12 12/3/12

    3 1 4 1 5

    15.99 17.99 6.95 9.99 9.99

    You might also like