Microsoft Office Access 2013: Level 1 Training
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
This course is designed for students who wish to establish a
foundational understanding of Microsoft Office Access 2013, including
the skills necessary to create a new database, construct data tables,
design forms and reports, and create queries.
Course Length: 1 Days
Course Tuition: $250 (US) |
Prerequisites |
|
To be successful in this course, you should be familiar with using personal computers and you should have used the mouse and keyboard. You should be comfortable in the Windows environment and be able to use Windows to manage information on the computer. Specifically, you should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders. |
Course Outline |
Course Content
Lesson 1: Getting Started with Access
Topic A: Orientation to Microsoft Access
Topic B: Create a Simple Access Database
Topic C: Get Help in Microsoft Access
Lesson 2: Working with Table Data
Topic A: Modify Table Data
Topic B: Sort and Filter Records
Topic C: Create Lookups
Lesson 3: Querying a Database
Topic A: Join Data from Different Tables in a Query
Topic B: Sort and Filter Data in a Query
Topic C: Perform Calculations in a Query
Lesson 4: Creating Advanced Queries
Topic A: Create Parameter Queries
Topic B: Create Action Queries
Topic C: Create Unmatched and Duplicate Queries
Topic D: Summarize Data
Lesson 5: Generating Reports
Topic A: Create a Report
Topic B: Add Controls to a Report
Topic C: Enhance the Appearance of a Report
Topic D: Prepare a Report for Print
Lesson 6: Customizing the Access Environment
Topic A: The Access Options Dialog Box
Appendix A: Microsoft Office Access 2013 Exam 77-424
Appendix B: Microsoft Access 2013 Common Keyboard Shortcuts |
Course Directory [training on all levels]
Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.
- C++ Programming
19 April, 2021 - 23 April, 2021 - 20483: Programming in C#
1 February, 2021 - 5 February, 2021 - Administering the WildFly 14 and JBoss EAP 7.2 Application Servers
22 March, 2021 - 26 March, 2021 - VMware vSphere 6.7 Boot Camp
25 January, 2021 - 29 January, 2021 - Java Modules and New Features (Java 11+)
15 February, 2021 - 16 February, 2021 - See our complete public course listing