Log On/Register  

855.838.5028

Access 2010

Duration: 4 Days, 8 Modules
Module Price: $130
Try Our Access 2010 E-Learning Video Description

Access provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy to learn for new users interested in storing and accessing large amounts of data. This is often the next step in data management after Excel has maximized its potential to connect information. While the entire first day of Access focuses on tables, or how the data is stored, the introductory course also offers participants the opportunity to explore what a Database can do, how it may be applied and best practices to ensure the database scales up. During the second half of the class, many issues common to new database developers, such as relationships, are identified and resolved. This course is recommended for anyone new to Microsoft Access.

 

Day 1:

MODULE 1: Introduction to Access & Creating Tables

Introduction to database design concepts & terminology
Become familiar with the Access 2010 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips
Open and examine and existing Access database
Working with tables and data records
Find, sort and filter records in a table
Introduction to table creation options
Create tables using the design view
Using the Data Type Gallery
Introduction to table field properties

 

MODULE 2: Working with Relationships & Tables

Relational database design concepts
Create table relationships
Explore relationship types
Define referential integrity
Display object dependencies
How to “Normalize” databases
Additional table field properties
Create a lookup list

 

Day 2:

Once information is organized properly in Access, as discussed in the first day of this course, it becomes necessary to then get pertinent information back out again. This second day of Access focuses on Queries, or the process of asking specific questions of your database to extract only the records you care about in a given instance. During the morning session, participants will learn the many ways to phrase a question, and how that influences the results. In the afternoon portion, we explore ways to use those questions to maintain the relevance of your data, as well as how to connect this information to other programs. All participants looking to effectively use the data stored in Access will benefit from this course.

 

MODULE 3: Queries

Create select queries
Use criteria to refine query results
Create multi-table queries
Create query joins
Implement query parameters
Performing calculations in a query

 

MODULE 4: Additional Queries, & Importing/Exporting Objects & Data

Create a totals queries
Create crosstab queries
Create Action Queries
Import/export data
Linking tables from one database to another
Overview of importing data from Microsoft Outlook
Overview of the collecting data via email feature

 

Day 3:

While days one and two are all about setting up the structure of your database, day 3 is about making life easier for people who work with the data, focusing on Forms and Reports. During the morning session, students will create various forms to lookup data (usually seeing many records at once) or enter data (usually one record at a time.) Create text boxes, lookup lists, calculated fields, adding images and titles where useful. In the afternoon students learn to create reports to printout the data in specially-designed formats. Reports can be sorted, grouped, and give summary totals. Since the whole point of a database is to be able to record and use information, the Day 3 tools make those jobs easier.

 

MODULE 5: Creating Forms

Creating an AutoForm
Using the Form Wizard to design new forms
Add and modify form controls
Using Office Themes
Adding images and titles
Create calculated controls
Work with control properties
Create forms in design view
Creating Forms with Sub-forms
Create tabbed forms


MODULE 6: Creating Reports

Using the Report Wizard to create new Reports
Modify report's page setup settings
Modify report design and layout
Work with report sections
Create summary functions
Create reports in design view
Use the Mailing Labels Wizard

 

Day 4:

After your database is up and running, you may wish to automate certain processes: control placement of windows, control how a form operates once it opens, streamline the data entry process, and more. Students learn how to create Macros in two different macro editors, using modified versions of Visual Basic for Applications. In the afternoon, students learn to use hyperlinks in tables and forms, and create “switchboard” forms with clickable buttons to guide users who are not “Access savvy” through data retrieval and processing. Learn to control certain user- and group-level permissions to control who can use which tools, and control what users see when they open your database. Day 4 is icing on the cake for database deployment in a multi-user environment.

 

MODULE 7: Automating Access Databases

Create macros
Implement and run macros
Creating table macros
Event driven macros
Setting database startup options
Introduction to VBA concepts and terminology

 

MODULE 8: DB Maintenance and Deployment

Create switchboards
Discuss deploying Access databases in a multi-user environment
Explore Microsoft Access security features
Compact and repair databases
Using hyperlinks in an Access database

Access provides a powerful set of tools that are sophisticated enough for professional data managers, yet easy to learn for new users interested in storing and accessing large amounts of data. This is often the next step in data management after Excel has maximized its potential to connect information. While the entire first day of Access focuses on tables, or how the data is stored, the introductory course also offers participants the opportunity to explore what a Database can do, how it may be applied and best practices to ensure the database scales up. During the second half of the class, many issues common to new database developers, such as relationships, are identified and resolved. This course is recommended for anyone new to Microsoft Access.

 

Day 1:

MODULE 1: Introduction to Access & Creating Tables

Introduction to database design concepts & terminology
Become familiar with the Access 2010 interface: the Welcome Screen, Ribbon, Tabs & Tool-tips
Open and examine and existing Access database
Working with tables and data records
Find, sort and filter records in a table
Introduction to table creation options
Create tables using the design view
Using the Data Type Gallery
Introduction to table field properties

 

MODULE 2: Working with Relationships & Tables

Relational database design concepts
Create table relationships
Explore relationship types
Define referential integrity
Display object dependencies
How to “Normalize” databases
Additional table field properties
Create a lookup list

 

Day 2:

Once information is organized properly in Access, as discussed in the first day of this course, it becomes necessary to then get pertinent information back out again. This second day of Access focuses on Queries, or the process of asking specific questions of your database to extract only the records you care about in a given instance. During the morning session, participants will learn the many ways to phrase a question, and how that influences the results. In the afternoon portion, we explore ways to use those questions to maintain the relevance of your data, as well as how to connect this information to other programs. All participants looking to effectively use the data stored in Access will benefit from this course.

 

MODULE 3: Queries

Create select queries
Use criteria to refine query results
Create multi-table queries
Create query joins
Implement query parameters
Performing calculations in a query

 

MODULE 4: Additional Queries, & Importing/Exporting Objects & Data

Create a totals queries
Create crosstab queries
Create Action Queries
Import/export data
Linking tables from one database to another
Overview of importing data from Microsoft Outlook
Overview of the collecting data via email feature

 

Day 3:

While days one and two are all about setting up the structure of your database, day 3 is about making life easier for people who work with the data, focusing on Forms and Reports. During the morning session, students will create various forms to lookup data (usually seeing many records at once) or enter data (usually one record at a time.) Create text boxes, lookup lists, calculated fields, adding images and titles where useful. In the afternoon students learn to create reports to printout the data in specially-designed formats. Reports can be sorted, grouped, and give summary totals. Since the whole point of a database is to be able to record and use information, the Day 3 tools make those jobs easier.

 

MODULE 5: Creating Forms

Creating an AutoForm
Using the Form Wizard to design new forms
Add and modify form controls
Using Office Themes
Adding images and titles
Create calculated controls
Work with control properties
Create forms in design view
Creating Forms with Sub-forms
Create tabbed forms


MODULE 6: Creating Reports

Using the Report Wizard to create new Reports
Modify report's page setup settings
Modify report design and layout
Work with report sections
Create summary functions
Create reports in design view
Use the Mailing Labels Wizard

 

Day 4:

After your database is up and running, you may wish to automate certain processes: control placement of windows, control how a form operates once it opens, streamline the data entry process, and more. Students learn how to create Macros in two different macro editors, using modified versions of Visual Basic for Applications. In the afternoon, students learn to use hyperlinks in tables and forms, and create “switchboard” forms with clickable buttons to guide users who are not “Access savvy” through data retrieval and processing. Learn to control certain user- and group-level permissions to control who can use which tools, and control what users see when they open your database. Day 4 is icing on the cake for database deployment in a multi-user environment.

 

MODULE 7: Automating Access Databases

Create macros
Implement and run macros
Creating table macros
Event driven macros
Setting database startup options
Introduction to VBA concepts and terminology

 

MODULE 8: DB Maintenance and Deployment

Create switchboards
Discuss deploying Access databases in a multi-user environment
Explore Microsoft Access security features
Compact and repair databases
Using hyperlinks in an Access database

Prerequisites: No prerequisites for this course

Learn More
Please type the letters below so we know you are not a robot (upper or lower case):