Microsoft Access: Introduction for Beginners

Course Overview

Businesses rely on data being easily accessible and quick to find. By using Access to create well designed databases, data can be retrieved and reported on in an instant.

Some Microsoft courses can also be delivered in-house or at a venue of your choice, please click here to send an enquiry and find out more

Related Courses

• Microsoft Access: Advanced (1 day)
• Microsoft Access: Introduction for Beginners (2 day)
• Microsoft Access: Queries (1 day)
• Microsoft Access: Advanced
• Microsoft Access: Intermediate
• Microsoft Access: Introduction, Advanced and VBA Programming in 5 days
• Microsoft Access Consultancy

Audience

This course is suitable for you if you require being able to understand the basic concepts of how a database is structured.

Skills Gained

By the end of this course you will be able to...

• Design and create a database using course handouts
• Produce professional reports from data input using review questions
• Explore transferring data from other sources

Course Outline

• Introduction to Databases
• Database Terminology
• Introduction to the Access Environment
• Table Design
• Indexing Fields
• Adding & Editing Data
• Changing the Table Layout
• Importing & Linking Data
• Find & Replace
• Filters
• Forms
• Types of Forms
• The Form Wizard
• Designing Forms
• Pivot Table Forms
• Calculations on Forms
• Queries
• Simple Query Wizard
• Designing new queries
• Formula and Criteria Creation
• Calculations in Queries
• Reports
• Using the Report Wizard
• Calculated and statistical fields
• Label Generation