- Pre-Requisite:
Basic Computer & Excel Knowledge - Objective:
Participants will use Access 2016 to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data. - Take Away:
After completing this course, you will be able to manage huge database and make informed business decisions.
Access 2016
Course Details
1
Lesson 1: Exploring the Microsoft Office Access 2016 Environment
- Examine Database Concepts
- Explore the User Interface
- Explore the Ribbon
- Customize the Access Environment
- Obtain Help
- Use an Existing Access Database
2
Lesson 2: Designing a Database
- Describe the Relational Database Design Process
- Define Database Purpose
- Review Existing Data
- Determine Fields
- Group Fields into Tables
- Normalize Data
- Designate Primary and Foreign Keys
- Determine Table Relationships
3
Lesson 3: Building a Database
- Create a New Database
- Create a Table
- Manage Tables
- Create a Table Relationship
- Save a Database as a Previous Version
4
Lesson 4: Managing Data in a Table
- Modify Table Data
- Sort Records
- Work with Subdatasheets
5
Lesson 5: Querying a Database
- Filter Records
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
6
Lesson 6: Designing Forms
- View Data Using an Access Form
- Create a Form
- Modify the Design of a Form
7
Lesson 7: Generating Reports
- View an Access Report
- Create a Report
- Add a Custom Calculated Field to a Report
- Format the Controls in a Report
- Apply an AutoFormat to a Report
- Prepare a Report for Print
8
Lesson 8: Controlling Data Entry
- Restrict Data Entry Using Field Properties
- Establish a Pattern for Entering Field Values
- Create a List of Values for a Field
9
Lesson 9: Joining Tables
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
10
Lesson 10: Creating Flexible Queries
- Set Select Query Properties
- Create Parameter Queries
- Create Action Queries
11
Lesson 11: Improving Forms
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
12
Lesson 12: Customizing Reports
- Organize Report Information
- Format the Report
- Set Report Control Properties
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
13
Lesson 13: Sharing Data Across Applications
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Data to a Text File
- Merge Access Data with a Word Document
Onetime payment at the time of admission
Be the first to add a review.
Please, login to leave a review