Microsoft Access
Learn to Create Databases and Reports
What you'll learn
- Set up the program interface
- Create tables
- Set field properties
- Create relationships between tables
- Create queries
- Create forms
- Create reports
- Create the main menu
About this course
This course explains how to build databases and prepare reports with Microsoft Access from scratch. It starts with setting up the program interface, then creating tables and setting field properties. After that you create relationships between tables, then build queries and forms, and then create reports. It ends with creating the main menu, which brings the parts of the database together in one easy-to-use interface. The course suits anyone who needs to organize and manage data at work, such as employees, small business owners and people who want to build a simple database for their shop or business activity. You need no previous experience in programming or databases, because the course starts from the interface and explains every step with direct, step by step practice without complications. By the end, you will be able to design tables and the relationships between them, create professional queries, forms and reports, and build a main menu that makes your database easy for anyone else who uses it after you.
Expected outcomes
- Ability to create and manage databases using Access.
- Design professional forms and reports.
- Analyze data using queries and table relationships.
- Create an interactive main menu to facilitate database use.
Learner reviews
- ★★★★★مصطفى م.·منذ 1 شهرشاهد 50٪
شرح ممتاز جدا جدا
- ★★★★★Sarwat H.·منذ 5 شهرشاهد 100٪
دورة ممتازة جدا لكل طالب يريد ان يفهم برنامج اكسيس بشكل بسيط و عميق في نفس الوقت.
- ★★★★★Mustafa A.·منذ 5 شهرشاهد 100٪
دوره مفيده اتعلم اساسيات برنامج اكسيس
تم عرض كل التقييمات (3)
Course content
1Learning Microsoft Access
8 lectures
- Adjusting the Program InterfaceIntroduces the Microsoft Access interface: launching the program, creating and naming a new database first because it saves automatically, the title bar, showing or hiding the ribbon, and the command search box.19:48
- Creating Tables21:13
- Adjusting Field PropertiesExplains how to edit field properties in an Access table from Design view, such as default values and validation rules, and how to link a field to another table so it appears as a lookup list.20:33
- Creating RelationshipsExplains reviewing the database structure before building relationships, then creating relationships between the books, customers and supplies tables from Relationships, and how to edit or delete them.22:01
- Creating QueriesExplains creating queries in Access from the Create tab using the Query Wizard, such as finding duplicate records to identify best-selling books, plus summary queries and adding criteria.30:50
- Creating FormsExplains creating forms in Access for tidy data entry, including automatic forms and subforms, adding record navigation buttons, and building a form that searches for a book by its number.21:55
- Creating ReportsExplains creating reports in Access to print query results in a polished layout, formatting the table header and title, adding a calculated field with a function, and generating a report from each query.12:58
- Creating the Main MenuExplains building a main menu in Access that gathers forms and reports into one navigation form, customizing its title and logo, and setting it to open automatically when the database starts.13:05
Instructor
Ahmed Hassan Khamis
This course is part of the diploma
