Access 2003 Intermediate Class
AcademyX provides exceptional Microsoft Access classes to help you delve beyond basic functionality and to learn how to easily design and manage more complex databases, create multiple related tables and enable advanced report generation. These skills are easily integrated into any work environment.
Microsoft Access is one of the most popular database applications in the world. It is used to manage, track, report and share data such as sales metrics, inventory and customer details. To expedite data management tasks, MS Access relies on multiple tables and objects within a single file.
Advanced Techniques of Database Design
Effective database organization and design ensures administrators gather the information they need and nothing more. In our comprehensive Intermediate Access training course, you’ll learn popular development techniques and practices that promote efficient administration and use saving both time and money.
This engaging and interactive seminar shows you how to easily add and create normalized databases. A normalized database eliminates redundant information, while ensuring all information conforms to normal forms rules. It also guarantees proper table linking. Our instructors walk you step-by-step through the process for adding and creating permanent relationships, removing duplicate information from your database for normalization and eliminating unmatched data for reference integrity.
Attendees then learn various types of joins including left, right, equi and self joins. You’ll find out why they’re important, what they’re used for and when to use which. Students receive hands-on experience in using the Access Table Analyzer Wizard to normalize data structure on imported data and identify repeated information. Students also learn how to employ another helpful tool, the Lookup Wizard, to enter a list of values or find a value from another query or table. Then, we explain the steps in creating an AutoLookup Form to, for example, automatically complete customer data after their CustomerID is entered.
Learn how to use Access to:
Enhancing Select Queries in Access
Queries simplify data retrieval based on certain criteria. When you use queries, you can sort, filter, or perform calculations on database records. Queries also help combine data across multiple tables within a database. In this part of the Access training class we show students how to use the database's built-in visual tools that simplify and expedite the entire data retrieval process. You’ll learn how to create queries using the Query Design window, how to specify data sources and fields, add criteria expressions and designate a sort order.
Students also learn how to use the Expression Builder to establish criteria from scratch or use built-in expressions to display page number, time and date. The Access Intermediate class then explores parameter and crosstab query creation, both in Design View and with the Wizard, simplifying presentation of extensive amounts of data. Finally, instructors show you how to incorporate math and date functions into your queries.
Lean how to:
Running Action Queries in Access
Database administrators use queries to modify vast amounts of records. These modifications range from updating values, copying or moving records, to appending and deleting them altogether.
In this section, participants gain practical skills in appending, removing and updating records using the Append, Delete and Update Query. Students also learn how to use the Make Table Query to move records into a new table.
Learn how to:
Creating Advanced Reports with Access
The Change Chart Types feature in Access automatically summarizes table information including text and charts, professionally formatting everything for presentation. Students learn how to use this feature and regenerate their report at any time using up-to-date information.
This part of the training shows you how to design a summary report. It also explores the steps needed to modify a report by altering its properties. Students then create a running sum showing the cumulative total of any given field or report value.
Instructors bring each lesson into a practical context, discussing ways Parameter Queries are used in reports to, for example, let the user type in a month to see a data report for that month. They also show students how to add charts to reports or change chart types for more appealing presentations.
Learn how to:
Access: Multi-Table Forms
While standard forms display single table records, multi-table forms also show related records in embedded sub-forms. This is extremely useful, for example, with retailers when a company displays customer orders. In this case, a shop can open a main form showing customer information and an embedded sub-form displaying all of the customer’s past orders.
Those who attend our popular Intermediate Access training course learn how to design forms with embedded sub-forms and change sub-form properties. They also learn how to use Wizards to create a new sub-form.
Students learn how to customize forms to suit user preferences by specifying tab-order of form objects. They also learn how to modify the Record Source Property, or the source data it displays in queries.
Learn how to:
Access 2003 classes offered at four locations::