Microsoft Access 2013; Tutorial and Lab Manual MGS351Outline made by ChelseyProfessor: David MurrayDate: February 2, 2015Chapter 1: Overview of Microsoft Access DatabasesI. Introduction:a. Chapter one is a broad interview of Microsoft Access and anintroduction to some database terminologyb. Each chapter includes:i. Overview of materialii. Guided exercisesiii. Applied exercisesII. Have You Ever Used a Database?a. Basic characteristics of databasesi. Store all kinds of dataii. Can be either low or high techiii. Highly organized and structurediv. Somewhat analogous to multiple spreadsheets that are linkedtogetherv. Designed to allow easy extraction of stored datab. If you think about it you would be familiar with databases if you haveever used a phone book, online search engine, or e-commerce website(in other terms buying/selling products online)III. What will I find in a Microsoft Access Database?a. Five main components that make up a database are: tables, queries,forms, reports, and macros. (following definitions are word for wordfrom the text)i. Tables: store the data in the database and are analogous to thefoundation of the database. It is critically important that tablesbe designed properly; they provide the foundation for buildingthe remainder of the database.ii. Queries: enable you to extract data form your database tablesand allow us to answer questions we have about the data.Queries may combine data from multiple tables and manipulatedata output through the use of expressions, formulas, andfunctions.iii. Forms: are based on tables or queries, and they are used forentering data into the database in a user-friendly manner. Theyare also used for displaying data to the end user and can beused to create a menu system for the database.iv. Reports: use data from a table or query and format the output ina professional-looking manner. Reports provide you with theability to summarize, sort, group, and display data in manydifferent ways suited to the needs of the end user. Often, thepurpose of a report is to provide a printed output of some datain your database.v. Macros: are small programs that you build into Microsoft access;they perform some advanced operations, making the databasemore user-friendly and/or functional.IV. Where Can I Get Help?Microsoft Access 2013; Tutorial and Lab Manual MGS352a. Using the “F1” key brings you to the built in help tab, and you thenfollow the prompt for help.Chapter 1 outline complete. There is a very useful Guided exercise following thischapter in the book. If you happen to reach a point you don’t understand re-do thelast couple steps
View Full Document