Microsoft Access

Microsoft Access The Complete Guide provides training on all the essential functions of Access. This course covers introductory through advanced topics. In Unit 1 introduce students to the concept of a database and the four database objects: tables, forms, queries, and reports. Students design a database, use forms, build queries and create reports. In Unit 2 cover advanced topics related to the four objects, maintaining a database, and integrating Access with Word, Excel, and Outlook. In Unit 3, students are introduced to complex forms, calculated controls, complex reports, sub-reports, database customization, splitting databases, customizing the user interface, and more.

The Microsoft Office Complete Guide series has been designed from the ground up for Global eTraining’s world-leading, online, on-demand GeT Interactive eTraining platform. With text from internationally recognized content matter experts, professional narration, video demonstrations by leading instructors, and Let Me Try exercises for users to get practical experience with the software, using downloadable datasets aligned with the presentation content.

User’s prerequisites

You don’t need any previous experience with Microsoft Access to take this course.

GeT Started Today

GeT Everything for $499 / Year
(Limited Time Pricing)

Book a Demo Meeting

And receive a custom quote

Course Outline

Exploring Access
Defining Access Databases
Exploring the Access Environment
Introducing Objects & Exiting

Designing a Database and Creating Tables
Designing & Normalizing
Linking Tables
Creating Tables
Retrieving Data

Working with Forms
Form Design & Creation
Modifying Form Controls
Modifying Form Layout
Printing & Using Help

Querying a Database
Creating Select Queries
Setting Query Criteria
Sorting & Performing Calculations
Creating Special Types of Queries

Using Reports to Display Information
Designing Reports
Modifying Reports
Exploring Other Report Tools
Printing Reports

Refining Table Design
Creating and Modifying Relationships
Modifying Table Structures
Formatting A Table Datasheet Layout
Setting Field Properties
Setting Lookup Fields with the Lookup Wizard

Customizing Input Forms
Creating a Main Form with a Subform
Adding Calculations to Forms
Setting Properties to Assist and Control Data Entry

Creating Complex Queries
Creating and Running Action Queries
Identifying Advanced Query Features
Creating and Running Parameter Queries
Creating a Calculated Field in a Query

Customizing Reports
Customizing Reports
Adding a Subreport to a Main Report
Creating a Report from a Subreport
Numbering Items in a Report
Creating Calculated Controls on a Subreport
Setting Page Breaks and Customizing Controls
Analyzing Report Performance

Customizing The Database Interface and Startup Options
Set Access Options
Splitting a Database
Customizing the Database Interface

Importing and Exporting Data Using Word, Excel and HTML
Convert Access 2013 files to previous Access formats
Attaching Files to Database Records
Integrating Access with Word
Integrating Access with Excel
Displaying Access Data on the Web

Maintaining a Database
Improving and Maintaining a Database
Creating Macros to Improve Efficiency
Managing Database Objects
Analyzing and Documenting Databases
Compacting and Repairing a Database
Setting Database Security
Exploring Microsoft Cloud Storage