Microsoft Access is a desktop database application, packaged with Microsoft Office Professional. Unlike Excel, Access is able to work with millions of records, allowing large databases to be created, updated, searched and reported on by multiple users. From simple data capture to complex automation and user interfaces, Access brings all the powerful functionality of a complete database, without the need for expensive servers and administration.

Topics Covered

Course Contents Session 1 Getting Started with Access Creating & Opening a Database Converting an Existing Database Saving a Database with Different Formats Touring Access Databases Opening a Sample Database Touring Table, Form, Query, Report Switching Views Changing Database Display Options Planning and Creating a Custom Database Creating Tables in a Database Importing Data into Tables Linking to Data in Tables Working with Table Records, Design View Specifying a Primary Key in Design View Planning & Defining Table Relationships Ensuring Referential Integrity Identifying & Modifying Object Dependencies Session 2 Working with Fields Specifying Data Types and Field Properties Viewing, Changing & Updating Field Properties Formatting Text Values, Memo Text with Rich Text, Date and Time Values, Number and Currency Values Performing a Total Calculation Creating Input Masks & Indexed Fields Specifying Required Fields and Default Values Adding a Caption to a Field Validating Field Values Creating a Lookup Field & Properties Working with Tables Working with Tables Managing Linked Tables Formatting a Datasheet Sorting Records & Filtering Out Records Creating Complex Filters Using Forms Session 3 Locating Specific Information Using a Query Understanding Types of Queries Creating a Query in Design View & Wizard Getting Information with a Query Modifying a Query in Design View Specifying Criteria for a Single Field & Multiple Fields Creating Queries with Comparison and Logical Operators Performing Calculations in Queries Creating a Parameter Query Adding, Deleting & Updating Records with a Query Summarizing Values with Crosstab Query Simplifying Data Entry with Forms Creating Forms Working with Form Controls Creating a Form Using the Form Wizard Working with a Form in Layout View & Design View Creating Reports to Convey Information Exploring Different Ways to Create a Report Creating a Report & Mailing Labels Using Sections in Design View Working with Controls Creating and Modifying a Report in Design View Using Buttons and Controls Performing Calculations in Reports Grouping and Sorting in Reports Inserting a Header or Footer Session 4 Improving the Appearance of Forms and Reports Auto Formatting a Form or Report Formatting a Form or Report Applying Special Effects to Controls Applying Conditional Formatting Creating a Tabular or Stacked Layout Inserting a New Object, an Object from a File, a Picture, Excel Charts and Worksheets & a Graph Chart Importing and Exporting Information Importing and Linking Data Saving Import and Export Settings Importing or Linking Data from an Access Database, an Excel & a Mail Program.

Who should attend

The course is intended for new users of Microsoft Access 2007 who want to become productive in the shortest possible time.

Pre-requisites

Delegates should be proficient in using a PC with the Microsoft Windows operating system, but no prior experience with Access is required.

What you need to bring

Laptop

Key Takeaways

After this training the participants are able to Manage Database Creating Access Tables Designing Bulletproof Databases Selecting Data with Queries Using Operators and Expressions Working with Datasheet View Creating Basic Access Forms Working with Data on Access Forms Presenting Data with Access Reports Course Contents