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)

₹ 6,000

No Reviews Yet

Date and Time

Not decided yet.

Mrinal Bhattacharya picture
Mrinal Bhattacharya

MCA

7 Years of Experience

About Mrinal Bhattacharya

5+ Year's of experience in the relative field.
No reviews currently Be the First to Review

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

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

₹ 6,000

Post your requirement and let us connect you with best possible matches for MS Access Training Post your requirement now
₹ 6,000 Enquire

Enquire

Submit your enquiry for MS Access 2007/2010

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Mrinal

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer