Prerequisites
Students should be familiar with Microsoft Windows and Office. No Access knowledge required.
Course Overview
A relational database application such as Microsoft® Office Access® 2013 can help you and your organization collect and manage large amounts of data. Access is a versatile tool, which means 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 2013 to manage your data by creating a new database, constructing tables, designing forms and reports, and creating queries to join, filter, and sort data.
Access Basic Topics
- What is Access? What is a Database?
- What are RelatedTables?
- Database Concept
- Getting Started Screen
- Opening a database & Exploring Environment (blank- Template- Existing)
- Differences from Excel- Similarities with PowerPoint
- Getting Help
- How to plan a database?
- Explore tables in datasheet & design views
- Creating tables in datasheet view
- Creating tables in design View
- Changing the Design of A Table
- Effective & Ineffective field names
- Deleting, inserting & Moving Fields
- Attachment Data Type
- Add a Total row
- Finding and Editing Records
- Sorting records
- Filtering a table
- Setting Field Properties
- Working with Input Masks
- Setting Validation Rules
- What is a query?
- Create Queries using a Wizard
- Creating and Using in Design view
- Modifying Query Results And Queries
- Performing Operations In Queries
- What is a form
- Form Views
- Creating Forms by using form Button
- Creating Forms by using the Wizard
- Using Design View to create a form
- Sorting and Filtering Records in a form
- What is a Report?
- Different views of a Report
- Change default view
- How to create a report by using the wizard
- Create a Report in Design view
- 7 Sections of a report- Properties
- Grouping feature in Reports
- Modifying and printing reports
