تفاصيل الدورة
A successful database is efficient quick accurate and easy to use. This course covers how to create such a database with MS Access.
COURSE CONTENT
Module 1: Get Acquainted with Access
- What is access
- Introduction to Database
- Relational Database management system
- Introduction to Database objects
- Components of Access User interface
- Ribbon, Navigation pane, Back stage view
Module 2: Access startup screen
- Creating new blank Database
- Closing Database
- Creating Database from Template
- Opening an existing Database
- Backing up Database
Module 3: Using Navigation Pane
- Viewing object, Copying object
- Renaming Object, Deleting object
Module 4: Access Tables
- Planning Tables
- Planning fields
- Creating tables in Design view
- Modifying Tables in Design view
- Selecting a primary key
- Importing data from excel into new table
- Importing data as a linked table
Module 5: Table Relationship
- Relationship types
- Creating relationship in database
- Creating look up field
- Viewing related data
Module 6: Creating Queries
- Creating Query in design view
- Creating Query with Query Wizard
- Modifying Queries
- Adjusting Query field
- Sorting Query field
- Hiding Query field
- Adding Query criteria
- Adding calculated field to Query
- Creating crosstab Query
Module 7: Using Forms
- Form views
- Creating form with form Wizard
- Working with forms in design view
- Working with forms in Layout view
- Working with padding, Margins and Anchoring
Module 8: Creating Reports
- Report sections
- Designing a report
- Report views, print view, and layout view
- Using the report tool
- Working with reports in layout view
- Working with reports in design view
- Creating blank report
- The field list pane
- Grouping and sorting report
- Previewing and printing reports
نبذة عن معهد G TEC Computer Education
- JavaScript Full stack web developer virtual internship Virtual Bootcamp + Internship at Laimoonدرهم 1,449مدة الدورة التدريبية: Upto 30 Hours
- Advanced Microsoft Access 2016 Global Edulink50 SGDمدة الدورة التدريبية: Upto 15 Hours
- Advanced Microsoft Office 2016 Study 36541 SGDمدة الدورة التدريبية: Upto 40 Hours