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 Templates. Give it an appropriate name and hit Create.

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.

Access2010designview1createanother Microsoft Access 2010 Tutorial: Basic Help Creating DatabaseGive 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.

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

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