$399.00 per person
$349.00 for 4 or more
Call us: 1-800-873-7545
In Discovering the Secrets of Microsoft® Access®, you'll learn...
- How to build your own custom database solutions
- How to connect to a variety of external data sources and generate professional-looking reports
- Streamlined methods for sorting data into tables, queries and forms
- Access’s dozens of built-in functions for calculating totals and for numbering and counting records
- And much more
Jump into the exciting world of Microsoft Access in this two-day, hands-on workshop and find out how simple building a database can be! Here you’ll gain a thorough understanding of what makes Access tick as you master the basics of tables, queries, forms and reports and delve into custom features for solving your most complex information challenges.
WORKSHOP AGENDA
Program hours: 9:00 am – 4:00 pm
DAY 1
Click on a session title to view details
Session 1: Getting started+
- What a database is and how it can make information management a whole lot easier
- Should you use a database or a spreadsheet? Here’s what to consider
- 3 great reasons to use a relational database—like Access—rather than a flat database file
- How to plan your database correctly so you don’t have to build it over again later
- A step-by-step guide to using Access’s user-friendly ribbons
Session 2: Creating tables—laying the groundwork of your database+
- The in’s and out’s of working in Design View to change the structure or design of your table without changing the data
- How to create a table from scratch to house your data
- How to define a Primary Key to help retrieve your data more quickly
- How to enter new data into your table
- How to use the powerful Filter tool to view a subset of records without needing to create a query
Session 3: Using queries to enter and retrieve data+
- What a query is and when to use it
- How to open, save, copy, rename and delete queries
- How to run a Select Query—it will become your best friend!
- Valuable sorting techniques for organizing the records you’ve retrieved
- How to run a Crosstab Query to see calculated totals in a spreadsheet-like format
- How to create and run an Update Query to modify data in multiple records quickly and easily
Session 4: Creating forms to simplify data entry+
- Understanding the basics of forms
- How to create forms that format data in a special way or automate how data is used and updated
- Adding graphics—from many sources—to enhance your forms
- Do you want to show data from several tables and update data in more than one table? Create a subform
- Discover Access’s Expression Builder and create your own calculations … with the click of a few buttons
DAY 2
Click on a session title to view details
Session 1: Presenting organized information with reports+
- Need to modify a report? Go to Design View and follow these simple steps
- How to use the Sort and Group window to organize information in a neat, easy-to-read display
- Exploring Access’s dozens of built-in functions for calculating totals and for numbering and counting records
- An easy-to-implement tool that enables you to print names and addresses to labels
- Advanced report techniques: How to make a report from a variety of different data sources
Session 2: Automating complex tasks using macros and modules+
- Macros … explained in plain English
- How to create a macro so that you can perform a series of commands at the push of a button
- Need to modify a macro? These tips will bolster your confidence
- When your macro acts up … debugging and troubleshooting techniques that’ll get you up and running
- For the advanced user … understanding modules and their unique role in solving unusual or difficult programming problems
- Quick-result troubleshooting tips
Session 3: Mastering external data sources+
- Understanding the difference between linking and embedding
- Importing data from other sources to a new table in Access®
- How to link to a table in another database
- How to export PDFs and XPSs to share data and collaborate
- How to use ODBC drivers to connect to virtually any data source such as SQL servers, mainframe database systems and more
Session 4: Using the right tools for the right job—the Database Tools tab+
- Understanding why it’s important to secure your database and the tools that can help you do it
- How to use the Performance Analyzer to analyze the performance of all your database objects
- A step-by-step guide to using the Upsizing Wizard—upsizing an Access database to an SQL Server® database
- How to create and edit a Switchboard to help end users locate the reports they use the most
- Do you want to improve performance and reduce the chance of corruption to your database? Learn how to split a database
- What’s important to know about replication options
- How to use the Database Documenter
- CPE Credits: 12
- Field of Study: Computer Science
- NASBA #: 107719
