...

Microsoft Access – Level 1 / Basic (Code:44344)

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

Choose Another Popular Course

Choose Another Course
Share This Post
Have your say!
2 0

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Request a Quote

Request Quote Form

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Thanks for Downloading Your Gift

We have sent your quick reference guide for creating Dashboard.

Please check your inbox to receive Your Gift.

Happy Learning !!

Subscribe to our Newsletter

Receive 7 Instant Gifts when you Subscribe to my monthly Newsletter below.

Seraphinite AcceleratorOptimized by Seraphinite Accelerator
Turns on site high speed to be attractive for people and search engines.