Learn to use Microsoft Access to manage your data, construct tables, design forms and reports, and more. Microsoft® Office Access® 2016 can help you and your organization collect and manage large amounts of data. You can use it as a personal data management tool, or you can use it to develop applications for a department or an entire organization. In this course, you will use Access to manage your data by creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Prerequisites
To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.
What You'll Learn
In this course, you will learn how to use Access to manage your data by creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.
Course Outline
1. What is Access? What is a Database?
2. What are Related Tables?
3. Database Concept
4. Getting Started Screen
5. Opening a database & Exploring Environment (blank- Template- Existing)
6. Differences from Excel- Similarities with PowerPoint
7. Getting Help
8. How to plan a database?
9. Explore tables in datasheet & design views
10.Creating tables in Datasheet view
11.Creating tables in design View
12.Changing the Design of a Table
13.Effective & Ineffective field names
14.Deleting, inserting & Moving Fields
15.Attachment Data Type
16.Add a Total row.
17.Finding and Editing Records
18.Sorting records
19.Filtering a table
20.Setting Field Properties
21.Working with Input Masks
22.Setting Validation Rules
23.What is a query?
24.Create Queries using a Wizard
25.Creating and Using in Design view
26.Modifying Query Results and Queries
27.Performing Operations in Queries
28.What is a form
29.Form Views
30.Creating Forms by using form Button
31.Creating Forms by using the Wizard
32.Using Design View to create a form
33.Sorting and Filtering Records in a form
34.What is a Report?
35.Different views of a Report
36.Change default view
37.How to create a report by using the wizard
38.Create a Report in Design view
39.7 Sections of a report- Properties
40.Grouping feature in Reports
41.Modifying and printing reports
