News

Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Five Benefits of Live Instructor Led Training

Five Benefits of Live Instructor Led Training

Experts still agree that there are no viable replacements for having a live professional in the room during training sessions.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.


CONTACT US
Training partners

Spindustry Training

spindustrytraining.com - (515) 334-9556

Bookmark and Share

Microsoft Office Access 2013: Level 3

Course Code: FC3-AC2013
Length: 1 Day
Tuition: $179.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

You've covered many of the basic functions of Microsoft® Office Access® and now you're ready to learn advanced Access features such as, database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today's training added to that which you've gained from the previous two days round out your Access education and provide you with marketable job skills.

You can also use the course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

Target Student:

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2013 and need to learn advanced skills.

This course is also for students who seek the Microsoft Office Specialist (MOS) certification and who want to prepare for Exam 77-885, Microsoft Office 2013.

Prerequisites

To ensure your success in your course you should have experience working with Microsoft Access 2013, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following courses:

  • Microsoft® Office Access® 2013: Level 1
  • Microsoft® Office Access® 2013: Level 2

Course Outline:

ACCESS 2013 LESSON 1: CUSTOMIZING REPORTS

  • Importing a Report into a Database
    • Identifying Report Record Sources
    • Using Smart Tags
  • Adding a Subreport to a Main Report
    • Examining Database Objects
    • Adding a Subreport
  • Creating a Report from a Subreport
  • Numbering Items in a Report
    • Setting Properties to Number Items
    • Numbering Subreports Separately
  • Creating Calculated Controls on a Subreport
    • Positioning Calculated Controls
    • Growing a Subreport
  • Setting Page Breaks and Customizing Controls
    • Positioning the Page Break Control

ACCESS 2013 LESSON 2: CUSTOMIZING THE DATABASE INTERFACE AND STARTUP OPTIONS

  • Setting Access Options
    • Displaying Access Options
    • Exploring Datasheet Effects
    • Setting Personal Information
    • Customizing the Navigation Pane
    • Setting Database Properties
    • Setting Up Current Database Format
  • Splitting a Database
    • Record Locking
    • Reasons for Splitting Databases
    • Using the Database Splitter
    • Split Database Terminology
    • Backing Up a Database Prior to Splitting
  • Customizing the Database Interface
    • Exploring a Database Switchboard
    • Creating a Navigation Form
    • Navigation Form Layouts
    • Adding Custom Command Buttons
    • Setting Startup Options to Open a Form

ACCESS 2013 LESSON 3: IMPORTING AND EXPORTING DATA USING  WORD AND EXCEL

  • Converting Access 2013 Databases to Earlier Formats
    • Identifying the Format of an Access Database
  • Attaching Files to Database Records Using the Attachment Data Type
  • Integrating Access with Word
    • Copying Data from Access to Word
    • Publishing Data to Word
    • Merging Access Data with Word Documents
  • Integrating Access with Excel
    • Importing Data from Excel Files
    • Linking an Excel Worksheet to an Access Database Exporting Access Data to Excel

ACCESS 2013 LESSON 4: MAINTAINING A DATABASE

  • Using Command Buttons to Improve Navigation
  • Creating Macros to Improve Efficiency
    • Using Macros to Display Adaptable Reports
  • Managing Database Objects
    • General Cleanup and Maintenance
  • Backing Up a Database

back to top