Cutubka 2: Microsoft Access 2016, su'aalo iyo jawaabo

Microsoft Access 2016: su'aalo tusaale ah oo jawaabo leh

Waxa cutubka 2 daboolayo

Su'aaluhu waxay raacayaan buugga: Technology, Secondary, Form Four, Student Book.

1. Casharka 1: Introduction to Database Management

   • Overview
   • What is a database?
   • Why do we use a database?
   • The advantages of having a database include:
   • Disadvantages of Database
   • Database Objects:
   • I. Tables
   • Table 2.1: Microsoft Access Data Types
   • II. Forms
   • III. Queries
   • IV. Reports

2. Casharka 2: Managing Databases and Objects

   • Getting Started Microsoft Access 2016
   • To open Microsoft Access 2016:
   • Working with your Access environment
   • The Ribbon
   • To minimize and maximize the Ribbon:
   • The Quick Access Toolbar
   • Backstage view
   • The Navigation pane
   • To minimize and maximize the Navigation pane:
   • Sorting Objects in the Navigation pane
   • Creating a database
   • Creating a Table
   • To open an existing database:
   • To close a database:
   • To open an object:
   • Saving objects
   • To close an object:
   • To rename an object:

3. Casharka 3: Working with Tables

   • Table basics
   • To open an existing table:
   • Navigating within tables
   • Adding records and entering data
   • To save a record:
   • Editing records
   • To delete a record:
   • Resizing fields and rows
   • Hiding fields
   • Alternate row color
   • Creating Primary Keys in a Table
   • To create a Primary Keys

4. Casharka 4: Working with Forms

   • Overview
   • Why use forms?
   • To create a form
   • To open an existing form:
   • To add a new record:
   • To find an existing record to view or edit:
   • To save the current record:
   • To delete the current record;

5. Casharka 5: Designing a Query

   • Overview
   • What are queries?
   • Advantages of query:
   • To create a simple query:
   • To modify a query:
   • Designing a Multi table Query
   • Planning a query
   • Creating a multi table query

6. Casharka 6: Creating Reports

   • Overview
   • To create a report:
   • To save your report:
   • To delete a field in a report:
   • Printing reports in Print Preview