Professional Course
5.0 (1 Reviews)

Designing and Creating Databases with Microsoft® Access

Length
2 days
Price
695 USD
Next course start
Contact provider for more information. See details
Delivery
Classroom
Length
2 days
Price
695 USD
Next course start
Contact provider for more information. See details
Delivery
Classroom
This provider usually responds within 48 hours 👍

Course description

Most organizations maintain and manage large amounts of information. One of the most efficient and powerful ways of managing data is by using relational database tools. Information can be stored, linked, and managed using a single relational database application and its associated tools. In this course, you will examine the basic database concepts, and create and modify databases and their associated objects using the Microsoft Office Access relational database application. In addition, you will also consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.

Upcoming start dates

1 start date available

Contact provider for more information.

  • Classroom
  • Ottawa

Who should attend?

Beginning to Intermediate-Level Database and Microsoft Excel Users, General Managers, Database Managers, and Presentation Speakers.This course requires the following prerequisites:User Knowledge of Microsoft WindowsKnowledge of Microsoft Word and/or Microsoft Excel helpful, but not necessary.

Training content

Section 1: Getting Started

  • Starting Out
  • Interface Basics
  • Database Security
  • Getting Help

Section 2: The New Interface

  • The Quick Access Toolbar
  • Basics of Tabs
  • The Home Tab
  • The Create Tab
  • The External Data Tab
  • The Database Tools Tab

Section 3: Creating a Database

  • First Steps
  • About Records
  • Creating a Table
  • Formatting Text

Section 4: Doing More with your Database

  • Creating and Using Forms
  • Creating and Using Queries
  • Creating and Using Reports
  • Sorting and Filtering Data
  • Viewing Data
  • Printing a Database Object

Course delivery details

  • Understand the basic principles and fundamental concepts of Microsoft Office Access databases.
  • Design and create tables in a new Microsoft Access 2010 Database.
  • Enter data into Microsoft Access 2010 database tables.
  • Filter table data and create criteria for basic queries to access, display, and sort the table data.
  • Create basic entry forms for easier table input.
  • Create basic paper-based reports for table/query output.
  • Maintain database consistency and integrity through use of table properties, such as field settings, input masks, and validation methods.
  • Design and utilize advanced multi-table queries, cross-tabulation queries and parameter queries and criteria.
  • Customize Access data forms to provide for more flexible options for data input.
  • Customize Access reports to better control and summarize data on table/query print-outs.

Why choose BBLN?

In operation for over 20 years, Building Blocks takes a consultative approach to customer engagement to deeply asses the needs. We offer a variety of options for consideration.

All of our instructors have a minimum of 20 years of teaching experience using adult learning theory.

We can proudly say that our customers routinely say we exceeded their expectations and in doing so, we offer many benefits that are included in the service and pricing.

Reviews

Average rating 5

Based on 1 reviews.
Write a review!
5/5
Anonymous
12 Apr 2018

Very helpful course! I would recommend to any of my colleagues working in research or with data sets.

Contact this provider

Contact course provider

Fill out your details to find out more about Designing and Creating Databases with Microsoft® Access.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Building Blocks Learning Network
170 Laurier Ave. West, Suite 700
K1P 5V5 Ottawa Ontario

Building Blocks Learning Network

Building Blocks Learning Network (Building Blocks) is a training company with over 20 years of experience in Adult Education. Our specific expertise includes professional development in the areas of Executive Leadership, Management and Leadership, Coaching, Policy Development, How Government Works,...

Read more and show all training delivered by this supplier

Ads