Microsoft Access 2013 Overview of Microsoft Access DatabasesChapter OverviewWe Remember….Learning ObjectivesDatabase ConceptsPowerPoint PresentationCommercial SystemsMicrosoft AccessDatabase ObjectsTablesQueriesFormsReportsMacrosForm and Report WizardsSlide 16Relational DatabasesSlide 18Quick ReviewSlide 20Slide 21Slide 22Homework 1Microsoft Access 2013Overview of Microsoft Access DatabasesChapter 1Chapter OverviewIntroductionDatabase HierarchyDatabase Objects–Tables, Queries, Forms, Reports, Macros and ModulesRelational DatabasesWe Remember….10% of what we read20% of what we hear30% of what we see and hear50% of what we see someone do while explaining it90% of what we do ourselvesLearning ObjectivesMicrosoft AccessGeneral Database ConceptsRelational Database DesignApplication DevelopmentDatabase ConceptsData versus InformationDatabase hierarchy–Database (DBMS)–Table–Records (Rows)–Fields (Columns)Commercial SystemsOracleIngresInformix (Unix)DB2, SQL/DS (IBM)Access (Microsoft)SQL Server (Microsoft +)Many older (Focus, IMS, ...)Many limited PC (dBASE, Paradox, …)Microsoft AccessAccess 2007, 2010 and 2013 databases end with .accdb file extension – for example, sales.accdbDatabases made in older versions of Access have the file extension .mdbNEVER remove a disk or flash drive until Access is completely shut down.Database ObjectsTables – Ch. 2Forms – Ch. 3Queries – Ch. 4Reports – Ch. 5Macros – Ch. 7Modules (VBA) – Not coveredTablesStore the data in a database – similar to a spreadsheet, but more organized. Contains records (rows) and fields (columns).Datasheet View versus Design View Field Properties – input mask, validation rule, data type, format, primary key, etc.QueriesAllow you to ask questions (queries) about data in the database to extract information.When have customers placed orders?What products in inventory haven’t sold well?FormsForms are used for entering data, displaying data or for building a menu system.Basic Forms, Split Forms, Multiple Item Forms, SubformsForm, Layout and Design ViewReportsUsed to format and present the data in a professional, logical and useful manner. Often intended for printing and distribution. Can be built from tables or queries.Reports (output) in a system dictate what data must be stored in the database.Report, Layout and Design view and Print PreviewMacrosSmall programs that can perform advanced operations, making the database more powerful and user-friendly.Often used to open forms and reports or to automate portions of the database.Special macro named Autoexe c will run automatically when the database is opened.Form and Report WizardsUseful as a starting point for building reports and forms. Provides a framework that you can customize and build upon.Evolution of DatabasesRelational DatabasesThe real power of Access is derived from multiple tables and the relationships between those tables.Quick ReviewWhat view is used to add, edit, and delete records in a table?a. the Design viewb. the Datasheet viewc. Either (a) or (b)d. Neither (a) or (b)Quick ReviewWhich represents the hierarchy of terms from smallest to largest?a. Database, table, record, fieldb. Field, record, table, databasec. Record, field, table, databased. Field, record, database, tableQuick ReviewA __________ provides a convenient and attractive way to enter, display, and/or print the data in a table.Quick ReviewWhich form and report view allows you to immediately see the design changes you’re making?a. Datasheetb. Designc. Print Previewd. LayoutHomework 1Chapter 1 Guided ExerciseChapter 2 Guided ExerciseChapter 2 Applied
View Full Document