Acces

How to Use:

Microsoft Access 2007
Microsoft Office Access is a powerful tool used to create and format databases. Databases allow information to be organized in rows and tables, where queries can be formed to pool data together. Access is a relatively unknown program of the Microsoft Office Suite, but can be one of the most powerful programs, because of its work with other Office programs,especially Word and Excel, as well as servers outside of Microsoft, such as SQL. If you have any questions, check Microsoft’s website for Access help at http://office.microsoft.com/en-

us/access/default.aspx?ofcresset=1

In this tutorial, learn how to:
Query a Database Manipulate Data in a Table and Database Merge Data from Access into Microsoft Word

Updated by Trevor Mahoney (Spring 2009)Quick Tips for Using Microsoft® Access 2007

CONTENTS
Difference Between Access and Excel……………………………………………………………………….3 Getting Started ................................................................................................................3 Definitions .......................................................................................................................3 Ribbon................................................................................ Error! Bookmark not defined. Editing Data .....................................................................................................................4 Copy/Paste ......................................................................................................................4 Insert, Delete & Clear......................................................................................................4 Sort Data....................................................................................................................4 Filter Data ........................................................................................................................4 Controlling Your View of Data........................................................................................5 Import Data...............................................................................................................5 Queries.............................................................................................................................5Reports.............................................................................................................................6 Merge with Microsoft Word.......................................................................................6 Troubleshooting ..............................................................................................................8Printing.............................................................................................................................8 Other Resources ..............................................................................................................9
COPYRIGHTS "Screen shot(s) reprinted by permission from Microsoft Corporation. Microsoft is a registered trademark and Windows is a trademark of Microsoft Corporation". The source of this text comes from Wikibooks; originaldocumentation can be found here: http://en.wikibooks.org/wiki/Access This text is available under the GNU Free Documentation License, which can be read here: http://en.wikibooks.org/wiki/GNU_Free_Documentation_License

2

Quick Tips for Using Microsoft® Access 2007

DIFFERENCES BETWEEN ACCESS AND EXCEL

For the most part, Microsoft Access and Excel are very similar. They are bothdatabases, and have similar functions in terms of inputting data. However, you would typically use Microsoft Access when compiling data that is either categorical in nature or involves more reading. A typical project that would be of use in Microsoft Access is a telephone book or a directory. Microsoft Excel typically uses more numerical data than Microsoft Access, and is used to show functions between...