Introduction to Microsoft Access: A Database Management Tool
Discover how to create and manage tables, queries, forms, and reports. Analyze and visualize your data
Description
The main goals for an Access beginners course are to introduce the basic concepts and features of Microsoft Access, to teach the skills needed to create and manage a database, and to provide practical examples and exercises that demonstrate how to use Access effectively. By the end of the course, you should be able to:
- Understand the purpose and benefits of using a relational database system
- Navigate the Access interface and use common tools and commands
- Create a new database and design tables with appropriate fields and data types
- Establish relationships between tables and enforce referential integrity
- Enter, edit, and delete data in tables and forms
- Use queries to filter, sort, and summarize data
- Create and customize reports to present data in a professional format
- Apply basic formatting and design principles to enhance the appearance and usability of your database.
The course content is as follows:
Understand The Database Window
Database Objects - Tables - Queries - Forms - Report - Macro
Database Terminology -fields - records - data set
Creating a Database
Basic Tables and Table design, data types, data formatting and field rules
Using Queries and design your own. Select queries
Using the Auto Form Feature
Form Design -starting from a blank form. Add a table to a form and manipulate the fields
Using the Auto Report Feature
Report Design, create your own report, move and resize fields and labels.
Copying Data
Freezing Columns
Printing Tables
Printing Reports
Sorting Records
Using the Filter Sorts and advanced filters
Renaming Columns
Using the Chart Wizard
Importing data from Excel
Linking to Excel Data
After this course you will a good understanding of the basic concepts used in a Microsoft Access database.
What You Will Learn!
- Create a new database and design tables with appropriate fields and data types
- Use select queries to interogate table data by selection or date range. Add basic calculations
- Create a data input form to manage large data sets
- Produce dynamic reports to generate management information automatically
- Understand the purpose and benefits of using a relational database system
- Create and customize reports to present data in a professional format
- Apply basic formatting and design principles to enhance the appearance and usability of your database
Who Should Attend!
- Beginner in Microsoft Access