Microsoft Access Introduction PDF

Microsoft Access PREPARED BY: MS. LEILA B. VILLANEDA Microsoft Access A Database Management System It is developed by Microsoft Corporation DATABASE It is a collection of organized data or information stored in a computer It allows you to enter, access, analyze, and...

Microsoft Access PREPARED BY: MS. LEILA B. VILLANEDA Microsoft Access A Database Management System It is developed by Microsoft Corporation DATABASE It is a collection of organized data or information stored in a computer It allows you to enter, access, analyze, and use the data or information  Microsoft Access Name Age Gender Uses tables to list Hannah 12 Female data or Kevin 14 Male information Sarah 15 Female  PARTS OF THE MICROSOFT ACCESS  Title bar Located at the top of the window and displays the name of the current database  QUICK ACCESS TOOLBAR It contains the most frequently used commands It displays the Save, Undo, and Redo buttons you can customize it to display commands or buttons you want  RIBBON It contains various tabs, each with several groups of relevant commands  navigation pane This pane is present on the left side of the access window It displays the names of the objects used in the database such as Table, Queries, Forms, Reports, etc.  navigation buttons As the name suggests, It helps in navigating through the records. Navigation buttons display the current record number in an object  object tabs The objects that you have opened in a database appear right above the work are in a tabbed form. Clicking on any tab displays the content in the work area.  WORK AREA This is the working area where we input data or information  status bar This bar is located at the buttom of the window It displays the options inviewing your date, whether in Datasheet view or in Design view  shorturl.at/PTqZF TEAM EMAIL TEAM CHANNEL [email protected] #reallygreatsite  1. QUERIES 2. DATABASE 3. FIELD 4. MODIFY 5. RECORD 6. ROW 7. COLUMN 8. INFORMATION 9. TABLE 10. ENTITY  Microsoft Access TABLES A grid of rows and columns thats allows you t view data or information QUIRIES FORMS REPORTS DATA TYPE indicates the type of data that can be stored in a field FIELD is a single characteristic of data that appears in a table as a column RECORD is a collection of fields that appear as a row in a database or table SORT to arrange a list of words or numbers in ascending or descending order Your paragraph text