Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data. A relational database application such as Microsoft Office Access® can help you and your organization with this task. This course covers the introductory skills needed to perform basic database design and development in Access.
Learning Objectives »
- Navigate within the Access application environment, create a simple database, and customize Access configuration options
- Organize and manage data stored within tables
- Join, sort, and filter data from different tables
- Use forms to view, access, and input data
- Create and format custom reports
Course Agenda
Promoting Quality Data Input
- Launch Access and Open a Database
- Use Tables to Store Data
- Use Queries to Combine, Find, Filter, and Sort Data
- Use Forms to View, Add, and Update Data
- Use Reports to Present Data
- Get Help and Configure Options in Microsoft Access
Creating Tables
- Plan an Access Database
- Start a New Access Database
- Create a New Table
- Establish Table Relationships
Creating Queries
- Create Basic Queries
- Perform Calculations in a Query
- Sort and Filter Data in a Query
Creating Forms
- Start a New Form
- Enhance a Form
Creating Reports
- Start a New Report
- Enhance Report Layout
