Access 2007: Part II

Free Access 2007: Part 2 E-Book Reference Manual: Advanced Functionality in Access 2007

Microsoft Office Access is a database management program which allows users to import and export their data, as well as work with XML data files. The Access 2007 version also adds new functionality and tools which improve upon previous versions: tracking applications which can be customized from templates, easy database conversion, and enhanced information sharing with Windows SharePoint. This e-book reference manual was designed for Access 2007 users who have experience using the software, but need additional support when completing day-to-day database management tasks. It is available for free download here.

Although Microsoft Access 2007 is a complex program, it is designed for ease-of-use even for users who do not have advanced database knowledge. The second in a series of three e-book user guides, Access 2007: Part 2 provides detailed explanations of useful topics and tools including: saving data in Access, working with records, customizing tables, data entry, field properties, table relationships, sorting and filtering data, creating basic queries, and filtering queries. All explanations are accompanied by screenshots and full-color diagrams.

For further instruction in Access 2007, users should refer to Access 2007: Part 1 and Access 2007: Part 3, both available for free download on bookboon.com.

On installation of Access, the installation of sample databases like Northwind is an option.

Content

1. Section 4 Saving in Access
   1. Saving in Access
2. Section 5 Tables
   1. Working with records
   2. Creating a Table
   3. Entering Data
   4. Managing Table Data Entry
   5. Controlling Table Data Entry (field Properties)
   6. Relationships
   7. Customizing Tables
   8. Sorting and Filtering Data
   9. Formatting Tables
3. Section 6 Queries
   1. Creating Queries
   2. Basic Queries
   3. Filtering a Query
   4. Formatting Text