Database and Access Essay

Submitted By malt10
Words: 1899
Pages: 8
Open Document
Access 2010 Handout 1:
Microsoft Access 2010 Environment and Things You Should Know and Follow

Table of Contents:

Section
Topic
Page
1.1
You cannot unzip a zipped file directly on the Blackboard
2
1.2 mdb files vs. accdb files
2
1.3
Naming Database and Database Objects
2
1.4
Security Alert screen in Access 2007 or 2010: Important
2 & 3
1.5
Compacting and Repairing the database: Important
4
1.6
Access 2010/2007 Environment
5
1.6.1 The Access Main Menu Bar:
6
1.6.2 The Navigation Panel’s Dropdown list and the Shutter Bar
6, 7 1.6.3 Database Objects and The User Views:
7
1.6.4 The Create tab
10
1.6.5 The Access 2010/2007 Options Feature: Important 11 1.6.6 Saving a Database
13
1.6.7 Other Sources
13

Some of the concepts described in this handout are also available in Chapter 1 through Chapter 3 of the Tutorial DVD.1.1: You cannot unzip a zipped file directly on the Blackboard: You need to download a zip file onto your disk first before you can unzip it.

1.2: mdb files vs. accdb files:
Older versions of Access database files are usually saved with mdb extension such as Northwind.mdb). Access 2007 and 2010 database files are automatically saved with an accdb extensions (such as Northwind.accdb).

You can open an older version of Access database file (an mdb file) using Access 2007 or 2010. You can convert an mdb file to the newer version’s accdb file using Access 2007 (using the Save as). But, you cannot convert an mdb file to an accdb file using Access 2010. You cannot also save an accdb file as an mdb file using Access 2010.

1.3: Naming Database and Database Objects:

Mandatory: In our class, you must name all disk folders/sub-folders, database names, table names, query names (i.e. the name of almost all database objects and disk folders with a single word (without any space). You must follow these naming conventions even if the textbooks and tutorials and some sample demonstrations show otherwise. For example, a disk folder name should be mua3770Asn1 and not M U A Asn 1. A database name should be SampleBusiness.accdb and not Sample Business.accdb. A table can be OurFavoriteCustomer and not Our Favorite Customers. A column name should be FirstName and not First Name, etc. See the section 7.1 in the syllabus for further details.

1.4: Security Alert screen in Access 2010/2007: Important

When you open an accdb database file, you may observe a Security warning followed by a link captioned Enable Contents (in 2010) or Options (in 2007) (See Figure 1A and 1B). Always be sure to click on the Enable Contents as shown in Figure 1A for 2010.

If you are using Access 2007, click on the “Options…” button to open the Microsoft Office Security Options screen, select the Enable This Content and click on the OK button (See Figure 1B and 1C). If you forget this step, you may not get correct results from your queries, forms or reports.
Figure 1A: The Security Options Feature in Access 2010

Figure 1B: The Security Options Feature in Access 2007

Figure 1C: Enabling the Contents of the Access 2007 Database

1.5: Compacting and repairing the database: Important

Access 2010: When you work on a database (or when you receive or transmit a database file via Internet), often the database gets larger and somewhat corrupted. Thus it is a good practice to compact and repair the database file before you start working on a database. To do this chore in Access 2010, use the File > Compact & Repair.

Access 2007: To do this chore in Access 2007 use the Office Button icon (at the top left corner) > Manage > Compact and Repair Database (as shown below):

1.6: Access 2010 Environment

Microsoft Access is an excellent database management system (DBMS) software for an executive. The most important component of a DBMS is the Database Engine that performs the behind-the-screen (background)
Show More

Related Documents: Database and Access Essay

Database System Concepts Essay example

Chapter 1: Introduction Database System Concepts, 6th Ed. ©Silberschatz, Korth and Sudarshan See www.db­book.com for conditions on re­use Database Management System (DBMS)  DBMS contains information about a particular enterprise  Collection of interrelated data  Set of programs to access the data  An environment that is both convenient and efficient to use  Database Applications:  Banking: transactions  Airlines: reservations, schedules  Universities: registration, grades…

Words 1215 - Pages 5

Essay about INFORMATION SYSTEM AND DATABASE

Information Systems and Databases Information systems are computer systems that support end users, giving them access to the information. For a large number of information systems, the data is held in databases and access is via database management systems. Information systems perform a variety of tasks and these are considered in the following topics in the HSC course. While all of the information processes are represented in information systems, the emphasis in this topic is on the processes…

Words 567 - Pages 3

Summary Of The Steps To Create A Database

Table of Contents Access Summary of the steps to create a database 1. Design the database a. What OUTPUT do you require i. What input will be require to give you the output 2. Create the database 3. Design the tables 4. Create the tables a. Use the Design View b. Remember to name the table and the fields appropriately 5. Create the relationships between the tables – do this BEFORE you add any data to the tables. a. Remember to enforce the referential integrity 6. Create the forms…

Words 1011 - Pages 5

Nt1330 Unit 2 Client Server Computing

Client/Server computing is new technology used to solve management problems that modern organizations face. The main goal of Client-Server Computing is to allow every user to access shared resources placed into a server or multiple servers to increase productivity, flexibility and decrease the cost. 1.2 Client / Server Computing Configuration of client/server computing consists of three main components: client process requesting service, server process response to requested service and middleware…

Words 1598 - Pages 7

Database and Spreadsheet Essay

College of Technology London | DATABASE AND SPREADSHEET | Module Code: SBIT5003, Assignment 1 | Date: 15th April, 2011 – Word Count : 1496Term 3 | SAMIR BHOIR | STUDENT ID: 105065-83 UWL ID: 29002700/1 E-Mail: 105065-83@stu.ctlondon.ac.uk Submitted to: Dr. Jin Wu | Table of Content 1.0 Introduction: 3 2.0 Database Elements 3 2.1 Queries 3 2.2 Reports 4 2.3 Attributes 4 3.0 Standard Approaches of DB Design: 4 3.1 Entity – Relationship Diagram: 4 1) Entity 4…

Words 1717 - Pages 7

Essay about Review Questions Chapter 1 and 2

following terms: data, database, DBMS, database system, database catalog, program-data independence, user view, DBA, end user, canned transaction, deductive database system, persistent object, meta-data, and transaction-processing application. a) Data: Known facts that can be recorded and that have implicit meaning. b) Database: Collection of related data. c) DBMS: Is a collection of programs that enables users to maintain a database. d) Database system: Is a compilation of the database and complete definition…

Words 3545 - Pages 15

Database Technology Essay

to be “private”. Additionally, we should measure how many groups/people have access to these data records, and how many of these groups/people share or access the information without the individual’s consent. Other important factors to measure are: the average lifetime of a particular record, and the amount of time required to access a particular record. For example, in 1860, before the advent of computer databases, governments and organizations kept data records about individuals, usually in…

Words 487 - Pages 2

Systems: Sql and Database Management Systems Essay

making it a huge problem. Also it takes up tons of space which means money. 2. A database typically stores data values in tables. Databases offer a greater range of complexity in terms of data manipulation. With database management systems, several people can access the same data set. 3. Database management system is a software that manages database on a computer. Eg. Microsoft access, MySQL, oracle. Database are classified according to their organizational approach. 4. To help with problems…

Words 400 - Pages 2

Database: Database and Microsoft Excel Essay

Database Database A database system is defined as a integrated computer structure which stores collections of end user or meta data. In any organization, a database system is very important. Databases can be used to store any information you to collect and store. This information could be a company storing information on all of its employees or a company collecting monthly sales data. The size of the organization or company will determine how you will store this data. Microsoft Access is a great…

Words 412 - Pages 2

Database: Database and Database Management Systems Essay

A database is a table consisting ofcolumns (fields) and rows (records) where each column contains a specific attribute and each row features a certain value for the corresponding attribute. The number of columns within a single table depends on how many different types/categories of information we need to store within a database, while the number of rows is defined by the quantity of the objects that have to be introduced categorized records for. This kind of simple organization of the data in database…

Words 1052 - Pages 5