ecomed services is a fictional lighting company located in kansas city, missouri it provides...
TRANSCRIPT
![Page 1: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/1.jpg)
1
EcoMed Services EcoMed Services is a fictional lighting
company located in Kansas City, Missouri
It provides environmental friendly lighting to medical facilities in the United States
EcoMed opened for business in 1972 and has grown to partner with more than 150 medical facilities
Company stocks over 300 standard and specialized light bulbs
Ms. Ivon Gonzalez, company president You have been hired as an intern to help
manage and update the Access database
![Page 2: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/2.jpg)
Microsoft® Access 2013
Lesson 01
Getting Startedwith a Database
![Page 3: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/3.jpg)
Objectives
• Identify basic database structure1
• Work with a Microsoft Access database2
• Identify components of Access3
• Navigate Access recordsets4• Modify a datasheet’s
appearance5• Save and print a recordset6
3
![Page 4: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/4.jpg)
4
What is a Database? A database is a logically organized
collection of data Example: School database is used to track
courses, where you live, when you graduate, contact information, and other important academic information, etc…
Types of databases: Relational – Access is a relational database;
It’s the most common type of database; eliminates duplication of records
Flat – Excel – each database is represented as a single table
Hierarchical – data is organized into a tree-like structure
Network – each record type can have multiple owners
Dimensional – is a relational database that uses a dimensional data model to organize data
![Page 5: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/5.jpg)
5
Relational Database Access databases are organized by
major objects All data is stored in TABLES
A table is the major database object that stores all data in a subject-based list of rows and columns
Looks similar to an Excel spreadsheet with rows and columns
![Page 6: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/6.jpg)
Objective 1
Identifying Basic Database Structure
6
![Page 7: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/7.jpg)
Data Organization Table: major database
object that stores all data in a subject-based list of rows and columns
Record: complete set of related data about one entity or activity Records = rows
Field: smallest storage element that contains an individual data element within a record Fields = columns
7Figure 1-1
![Page 8: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/8.jpg)
Data Organization
A group of fields make up a record A group of records make up a table A group of tables make up a
database
8Figure 2-1
![Page 9: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/9.jpg)
9
Recordset A recordset is a Microsoft object—
oriented data structure consisting of grouped records
A recordset can be as small as a single field or as large as two or more combined tables
A recordset is most often displayed as either a form or a report
![Page 10: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/10.jpg)
Major Objects in an Access Database
Major Object Purpose
TablesTables store data about people, activities, items, and events
Queries
Queries display and organize data depending on the question being queried
FormsForms display data on a screen in user-friendly formats
Reports
Reports organize and format data to be used as printable documents
10
![Page 11: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/11.jpg)
Major Object Orientation
11Figure 1-3
![Page 12: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/12.jpg)
Objective 2
Working with a Microsoft Access Database
12
![Page 13: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/13.jpg)
Properties Dialog Box
Files are located on-line
Files are in folders matching the lesson number
EcoMed-01 is located in folder Lesson 01
Copy files to your desktop
13
Exercise 1-1
Figure 1-4
![Page 14: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/14.jpg)
Access Backstage
14
Exercise 1-2
Figure 1-5
![Page 15: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/15.jpg)
Objective 3
Identifying Components of Access
15
![Page 16: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/16.jpg)
Getting Started Window
16
Exercise 1-3
Figure 1-6
![Page 17: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/17.jpg)
Navigation Pane
17
Exercise 1-4
Figure 1-7
![Page 18: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/18.jpg)
Navigation Pane Options
18
Exercise 1-4
Figure 1-8
![Page 19: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/19.jpg)
Navigation Pane Options
19
Exercise 1-5
Figure 1-9
![Page 20: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/20.jpg)
Leszynski Naming Convention for Major Objects
Prefi
x
Object Type
Example
tbl Table tblBulbType qry Query qryInvShort frm Form frmInventory rpt Report
rptInvByVender20
Table 1-1
![Page 21: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/21.jpg)
Open a Table
21
Exercise 1-6
Figure 1-10
![Page 22: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/22.jpg)
22
Switching Views• Each database object has multiple
views• Datasheet View – records are
organized like an Excel Spreadsheet with yourrecords displayed in rows and columns
• Design View is used to modify the structure of the object; Records are NOT displayed
![Page 23: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/23.jpg)
Objective 4
Navigating Access Recordsets
23
![Page 24: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/24.jpg)
24
Navigation Buttons A Record Navigation Button is an icon
that moves the pointer within the recordset to the next, previous, first, last record, or a specified record
The Navigation Buttons are located at the bottom left of a table
![Page 25: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/25.jpg)
Table 1-2
Keyboard Shortcuts
25
Action Shortcut
Ctrl + HomeMove to the first field in the first record
Ctrl + EndMove to the last field in the last record
Tab or Move to the next fieldShift + Tab or
Move to the previous field
![Page 26: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/26.jpg)
Objective 5
Modifying a Datasheet’s Appearance
26
![Page 27: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/27.jpg)
Hide/Unhide Columns
27
Exercise 1-10
Figure 1-13
You can hide and unhide columns reduce thenumber of fields displayed
![Page 28: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/28.jpg)
Resizing a Column
28
Exercise 1-11
Figure 1-14
You can resize columns to enhance thedata being viewed
Changing row height is a GLOBAL setting and affects all of the rows in the entire table
![Page 29: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/29.jpg)
29
Font Commands Font commands, such as bold, italics,
and underline affect the ENTIRE datasheet
Other commands such as align left, center, right, can be applied to selected fields
You can alternate row color to improve readability
![Page 30: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/30.jpg)
Objective 6
Saving and Printing a Recordset
30
![Page 31: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/31.jpg)
Print Dialog Box
31
Exercise 1-14
Figure 1-17
![Page 32: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/32.jpg)
Print Dialog Box
32
Exercise 1-15
Figure 1-18
![Page 33: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/33.jpg)
33
Save a Table to an External File
Rather than printing directly on paper you can create an XPS or PDF file XPS is the file extension used by XML
Paper Specification PDF is the file extension used by Portable
Document Format You can save the electronic file, print or
email it1. Click the File tab2. Click on the Save & Publish tab3. In the File Types Section, Click Save
Object As, and choose PDF or XPS
![Page 34: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/34.jpg)
Objective 7
Managing Access Files
34
![Page 35: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/35.jpg)
Compact and Repair
35
Exercise 1-16
Figure 1-19
You can use the Compact and Repair command to reclaim unused space and improve database efficiency File, Info, Compact and Repair
![Page 36: EcoMed Services is a fictional lighting company located in Kansas City, Missouri It provides environmental friendly lighting to medical facilities](https://reader030.vdocuments.us/reader030/viewer/2022032803/56649e225503460f94b0f895/html5/thumbnails/36.jpg)
36
Back-Up a Database You should back-up your database to
prevent data loss The backup file is saved to the same
location as the original file The default name of your backup file is
the current date and time appended to the end of the original file File, Save Database As Backup Database
Example: EcoMed-01_2014-04-25