1. Home
  2. MS Office
We are reader supported and may earn a commission when you buy through links on our site. Learn more

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.

25 Comments

  1. 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

  2. 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

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

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.