Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

MS Access 2007/2010

No Reviews Yet

DLF City Phase 3, Gurgaon

Course ID: 26687

DLF City Phase 3, Gurgaon

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

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

Date and Time

Not decided yet.

About the Trainer

Mrinal Bhattacharya picture

Avg Rating

Reviews

Students

Courses

5+ Year's of experience in the relative field.

Reviews

No reviews currently

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for MS Access Training Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more