|
|
Access Mid Term Review Mid Term Topics/Concepts
to Know:
Principles
of Databases. Flat File Databases,
Relational Databases, Types of Data, Sorts vs Indexes, and Keys; Master Keys,
Uniqueness of Keys. Arranging Data,
Tables vs Databases. Chapter 3: Database ConceptsTerms: Database in Access, a container holding data and associated objects. Database objects include tables, forms, queries, reports, macros and modules. Access can only work with one Database at a time, but you can have many tables, and other modules in one database. A table is a container for raw data or records. Know what the following are: Records, Fields, Values, Objects, Views, Datasheet (can be part of a table), Queries, Dynasets (dynamic set of data), Data Entry and Display Forms, Reports Chapter 4: Tour of Access Know How to Use the mouse and keyboard in Access Know these terms and concepts: Access Window, Object Windows, Title Bar Control-menu button (also right clicking menu bar), How to Move, size minimize, or close Menu Bar, Toolbar Status Bar.. left side shows status. Right side gives key status Database Window: object buttons, toolbar buttons, object list View Choice: Large Icons, Small Icons, List, Details. Design Windows: Toolbox, Color, Special Effect and Border Windows for Forms Field List Window, Property Window How to Use the CD in the Book and Installing Examples from the book: Stick CD #1 in, Find Samples Folder, do setup from this folder only Note folder name where samples are put! Then load each table in access as directed in the book. Be able to Open the Mountain Animal Hospital Database, then Pets Table See Pets Datasheet, Moving through… Know how to: Go to Design View.. Displaying a Form Click on Forms, Pets, view form then click on design view. Do a simple Query: Click on Queries Button, select new, add, pets table, Double Click Pet Name to add to query. Add breed and Type of animal to the query. Go to the Criteria Row for type of animal, type DOG in the cell. Click on the ! cell to run the query. Display a Report: Click reports button, select Pet Directory, Select Preview Button Show the zoom with the mouse on the report. Chapter 5: Database Design 7 Step Method of Designing a Database: Catch 22… Which comes first the chicken (report) or the egg (tables) Finding out what the client wants and needs, and what type of data is available. Overall System Design Report Design (Output) Data Design (Fields) Table Design (Relationships) Field Design (Validation) Form Design (Input) Menu Design (Automation) Table Design and Relationships Terms to Understand: Combo Boxes Scroll Boxes and Lookup Tables Test Data Data Entry Screens Menus and Automation Chapter 6:
Creating Database Tables: Creating a Database What is an Access Database? Using the New Database Window Blank Database vs a Template What are Data Access Pages? Live data forms that you publish to a corporate intranet. Object Types: Tables, Queries, Forms, Reports, Pages, Macros, Modules Groups Data Access Window Toolbar Starting a Table: Using Wizards Table Design Naming Fields Data Types: Text, Memo, Number, Date/Time, Autonumber Yes/No, Ole Object, Hyperlink, LookupWizard Problems in Converting Data Types… Lab and Lecture Related Items: Queries:
Forms:
Reports:
Data Access Pages 1. Creating a Data Access Page 2. Finding and Opening the Page |
|
|