Microsoft Access 2010 Tutorial: Basic Help Creating Database

Microsoft Access 2010 introduces numerous features that are not supported in Office Access 2007. The Office 2010 release of Access offers some improvements that make the application more usable, including reliability enhancements. This post will guide you through the basics of creating database and table in Access 2007.

To get started, launch Microsoft Access, on File menu click New, you can either choose Blank database from Available templates or any other form of database from Office.com Templates. Give it an appropriate name and hit Create.

Create database access 2010

Navigate to Create tab, click Table to add another Table. From the left pane right-click Table1 and hit Design View, or you can also click a small button on the bottom-right corner of the window.


Access 2010 design view1 create anotherGive this table an appropriate name and hit OK. In Design view you can name table columns and apply desired constraints over them from Field Properties. Choose Primary key to uniquely identify each record in the table.

access 2010 design view filling1

To start filling tables, switch to table view by clicking the small button on the bottom-right of the window. You will see the columns created in design view and constraints applied.

Access 2010 filling table

Now the basic table has been created and added in the database, you can save it for later use.

Advertisement
  • Pingback: Access 2010: Import Worksheet From Excel 2010

  • Pingback: Access 2010: Building Relationships Among Database Tables

  • Pingback: MS Access 2010: Query With IFF Function

  • Pingback: MS Access 2010: Create Simple Forms

  • Pingback: MS Access 2010 Relationship & Query Interconnect

  • Pingback: Create Access 2010 Reports

  • Pingback: Create Tables In Access 2010 Using SQL Commands

  • Mike Leist

    I have tested the product and I get better performance with this version than the old ones.
    I recomend this access version

  • Sajad Mohammadi

    Thank you for this post
    Good Luck

  • Fahi_8728

    i like this. it hepled me in creating the db
    thanks alot.

  • Mohamed Yacoob

    Very short and crisp. Good.

  • Mohamed Yacoob

    Very short and crisp. Good.

  • Mahi_aim10130

    THANKS FOR HELPING MAHI AIM

  • Student

    Was pretty helpfull starting off my school project, Cheers!

  • QatBelly

    fail.  all your images are of Access 2007.  not good for a first timer.

  • Nahidcomputer2010

    very bad soft
    ido not like it xp 2003 e best soft

     

  • Ifrah

    thanks a lot  I get more advantage
     

  • Caroljack

    It was of much help,tnx much.

  • Shet Sunil

    Thank you,,,,
    ‘how to give this database link to vb 2008 form

  • Shet Sunil

    Thank you,,,,
    ‘how to give this database link to vb 2008 form

  • Shivakrishna

    thanX

  • Milly

    I want to create a query that returns the following

    Item name

    Sales price

    In Quantity

    In Value

    Plan Production

    Actual production

    Performance in%

    Plan Production

    Actual production

    Performance in%

    I have Two Capture tables for plan & actual production per
    day I want the query to return the data
    as per the requested date

  • kiyelo

    am looking to create a user accounts for different users of the database giving different privileges to users and also create user rights anyone how can help out am ready to learn and will be very greatful

  • Rick Generick

    Rename this article to reflect that fact that you are referring to Access 2007.