MICROSOFT ACCESS TRAINING

COURSE OVERVIEW

WE OFFER

 

  • Instructor Led classroom based training
  • Hands on Training
  • Free study material
  • Lab Exercises
  • Unlimited lab access
  • 100 % passing guarantee
    or Free Re-training

COURSE INFORMATION

 

  • Fast Track
    Days: Monday-Friday
    Duration: 8 days
  • Slow Track
    Days: Saturday/Sunday Only
    Duration: 8 Weeks
Study Modes:
  • Classroom
  • Live Virtual

MICROSOFT ACCESS

For More information call us on

0208 123 7574

COURSE INSIGHT

Microsoft Access is a software for relational databases. This is the ideal tool when you start to expand your Excel server. By designing user-friendly forms with rules to protect your data integrity, you can achieve good collection results with Access. You can create queries and reports that can be regenerated whenever you require to evaluate and filter your data. The workshop themes will be database definitions, database preparation and a practical guide to tables, inquiries, forms and documents.

Microsoft Access is a database program that is “relational.” Relational means that we can tie data sets together, we can connect the data together. Consumers can keep track of patients, nurses, and the last time patients saw their physicians, what happened at each visit, and so on. Connection helps us to connect our information without the duplication that can take place elsewhere.

We deliver one of the best SAP professional training programs in the industry. Specialists with extensive experience in the field conduct the lessons on this subject. The curriculum fits perfectly with professional standards with the latest industry changes.

SAP MICROSOFT ACCESS COURSE OUTLINE

MODULE

  • Basic Window Elements
  • Exploring Office Backstage
  • Working with the Ribbon
  • Customizing the Quick Access Toolbar
  • Working with KeyTips
  • Using the Status Bar
  • Getting Help
  • What is an Access Database?
  • Opening a Database File
  • Exploring Database Objects
  • Creating a Database
  • Changing Views
  • Printing Database Objects
  • Saving and Closing a Database File
  • What is a Table
  • Working with Datasheets
  • Moving Among Records
  • Updating Records
  • Adding Records to a Table
  • Selecting Rows and Columns
  • Finding Records
  • Sorting Records
  • Filtering Records
  • Adding a Table to a Database
  • Adding Fields to a Table
  • Adding a Lookup Field
  • Setting a Primary Key
  • Using the Input Mask Wizard
  • Saving Design Changes
  • Importing Data
  • Exporting Data
  • Performing Database Maintenance
  • What is a Query?
  • Creating a Query
  • Working with Queries
  • Saving and Running a Query
  • Creating Calculated Fields
  • Using Agregate Functions
  • Understanding Query Properties
  • Creating Multi-Table Select Queries
  • Joining Tables
  • Enforcing Referential Integrity
  • What is a Form?
  • Using the Form Tool
  • Creating a Form with the Form Wizard
  • Working in Design View
  • Changing the Form Layout
  • Using Calculated Controls
  • Working with Records on a Form
  • What is a Report?
  • What is a Report Tool?
  • Previewing and Printing a Report
  • Saving a Report
  • Designing a Report
  • Changing a Report Layout
  • Understanding Controls
  • Using a Calculated Control
  • Analyzing Dependencies
  • Creating Mailing Labels
  • What is the Cloud?
  • What is Office 365?
  • Choosing the Right Plan
  • Signing in with Microsoft Accounts
  • Exploring the Interface
  • Understanding OneDrive
  • Office Online Overview
  • Opening Files
  • Saving Files

LOOKING FOR A
2-12 MONTHS
TRAINING?

CHOOSE

SAP MICROSOFT ACCESS

SKILLS GAINED

  • Entering Record
  • Rearrange and Add Fields
  • Customizing a Query
  • Create and Modify Grouped Report
  • Create Schedule Query with Multiple Tables

Dates And Prices

Start Date TimingDaysDuration Mode Of Training Price Reserve Now
15/09/2019
Places available
10:00 – 18:00Sunday Only 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Saturday Only 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850
15/09/2019
Places available
10:00 – 18:00Monday-Friday 5 WeeksClassroom Based£850

RELATED COURSES

SAP HCM

Company that offers design and build services for you from initial sketches to the final production.

read more

SAP Training

Our aim is exclusively focused on high quality training that are tailored to corporate needs. The training delivered by professional trainers.

read more

SAP FCO

Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.

read more

SAP FCO

Our internship programme is designed to help students who have successfully completed the training and give experience in real time projects.

read more