A relational database application such as Microsoft® Office Access® can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
See specific content information below in the "Attend and You Will Learn" section.
Why You Should Attend
This course is designed for students who wish to learn the basic operations of the Microsoft Access database program to perform their day-to-day responsibilities and who want to use the application to be more productive in their work.
Attend and You Will ReceiveParticipants who successfully complete this course will receive a certificate of completion from NC State University
It is best if you have prior experience with Windows operating systems and basic knowledge of Microsoft Word and/or Excel.
Attend and You Will Learn / Expected Outcome
Attend and You Will Learn
Getting Started with Access
- Orientation to Microsoft Access
- Creating a simple Access database
- Getting help in Microsoft Access
Working with Table Data
- Working with table data
- Modifying table data
- Sorting and filter records
- Creating lookups
Querying a Database
- Joining data from different tables in a query
- Sorting and filter data in a query
- Performing calculations in a query
Creating Advanced Queries
- Creating parameter queries
- Creating action queries
- Creating unmatched and duplicate queries
- Summarizing data
- Creating a report
- Adding controls to a report
- Enhancing the appearance of a report
- Preparing a report for print
Customizing the Access Environment
- The Access options dialog box