Skip to main content

Posts

Microsoft Access MS Access Basics Tips and Trick-7

Adding Data An Access database is not a file in the same sense as a Microsoft Office Word document or a Microsoft Office PowerPoint are. Instead, an Access database is a collection of objects like tables, forms, reports, queries etc. that must work together for a database to function properly. We have now created two tables with all of the fields and field properties necessary in our database. To view, change, insert, or delete data in a table within Access, you can use the table’s Datasheet View. A datasheet is a simple way to look at your data in rows and columns without any special formatting. Whenever you create a new web table, Access automatically creates two views that you can start using immediately for data entry. A table open in Datasheet View resembles an Excel worksheet, and you can type or paste data into one or more fields. You do not need to explicitly save your data. Access commits your changes to the table when you move the cursor to a new field in the same row, or whe
Recent posts

Microsoft Access MS Access Basics Tips and Trick-6B

Table Design View As we have already created one table using  Datasheet View . We will now create another table using the  Table Design View . We will be creating the following fields in this table. These tables will store some of the information for various book projects. Field Name Data Type Project ID AutoNumber ProjectName Short Text ManagingEditor Short Text Author Short Text PStatus Short Text Contracts Attachment ProjectStart Date/Time ProjectEnd Date/Time Budget Currency ProjectNotes Long Text Let us now go to the Create tab. In the tables group, click on Table and you can see this looks completely different from the Datasheet View. In this view, you can see the  field name  and  data type  side by side. We now need to make  ProjectID  a primary key for this table, so let us select  ProjectID  and click on  Primary Key  option in the ribbon. You can now see a little key icon that will show up next to that field. This shows that the field is part of the table’s primary key. Let

Microsoft Access MS Access Basics Tips and Trick-6A

Create Tables When you create a database, you store your data in tables. Because other database objects depend so heavily on tables, you should always start your design of a database by creating all of its tables and then creating any other object. Before you create tables, carefully consider your requirements and determine all the tables that you need. Let us try and create the first table that will store the basic contact information concerning the employees as shown in the following table − Field Name Data Type EmployeelD AutoNumber FirstName Short Text LastName Short Text Address1 Short Text Address2 Short Text City Short Text State Short Text Zip Short Text Phone Short Text Phone Type Short Text Let us now have short text as the data type for all these fields and open a blank database in Access. This is where we left things off. We created the database and then Access automatically opened up this table-one-datasheet view for a table. Let us now go to the Field tab and you will see

Microsoft Access MS Access Basics Tips and Trick-5

Data Types Every field in a table has properties and these properties define the field's characteristics and behavior. The most important property for a field is its data type. A field's data type determines what kind of data it can store. MS Access supports different types of data, each with a specific purpose. The data type determines the kind of the values that users can store in any given field. Each field can store data consisting of only a single data type. Here are some of the most common data types you will find used in a typical Microsoft Access database. Type of DataDescriptionSize Short Text Text or combinations of text and numbers, including numbers that do not require calculating (e.g. phone numbers). Up to 255 characters. Long Text Lengthy text or combinations of text and numbers. Up to 63, 999 characters. Number Numeric data used in mathematical calculations. 1, 2, 4, or 8 bytes (16 bytes if set to Replication ID). Date/Time Date and time values for the years 100

Microsoft Access MS Access Basics Tips and Trick-4

Create Database In this chapter, we will be covering the basic process of starting Access and creating a database. This chapter will also explain how to create a desktop database by using a template and how to build a database from scratch. To create a database from a template, we first need to open MS Access and you will see the following screen in which different Access database templates are displayed. To view the all the possible databases, you can scroll down or you can also use the search box. Let us enter project in the search box and press Enter. You will see the database templates related to project management. Select the first template. You will see more information related to this template. After selecting a template related to your requirements, enter a name in the  File name  field and you can also specify another location for your file if you want. Now, press the Create option. Access will download that database template and open a new blank database as shown in the follo

Microsoft Access MS Access Basics Tips and Trick-3

Objects MS Access uses “objects" to help the user list and organize information, as well as prepare specially designed reports. When you create a database, Access offers you Tables, Queries, Forms, Reports, Macros, and Modules. Databases in Access are composed of many objects but the following are the major objects:- Tables Queries Forms Reports Together, these objects allow you to enter, store, analyze, and compile your data. Here is a summary of the major objects in an Access database; Table Table is an object that is used to define and store data. When you create a new table, Access asks you to define fields which is also known as column headings. Each field must have a unique name, and data type. Tables contain fields or columns that store different kinds of data, such as a name or an address, and records or rows that collect all the information about a particular instance of the subject, such as all the information about a customer or employee etc. You can define a primary ke

Microsoft Access MS Access Basics Tips and Trick-2

RDBMS Microsoft Access has the look and feel of other Microsoft Office products as far as its layout and navigational aspects are concerned, but MS Access is a database and, more specifically, a relational database. Before MS Access 2007, the file extension was  *.mdb , but in MS Access 2007 the extension has been changed to  *.accdb  extension. Early versions of Access cannot read accdb extensions but MS Access 2007 and later versions can read and change earlier versions of Access. An Access desktop database (.accdb or .mdb) is a fully functional RDBMS. It provides all the data definition, data manipulation, and data control features that you need to manage large volumes of data. You can use an Access desktop database (.accdb or .mdb) either as a standalone RDBMS on a single workstation or in a shared client/server mode across a network. A desktop database can also act as the data source for data displayed on webpages on your company intranet. When you build an application with an Acc

Microsoft Access MS Access Basics Tips and Trick-1

MS Access Basics in Powerpoint 2010 Overview Microsoft Access is a Database Management System (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and softwaredevelopment tools. It is a member of the Microsoft Office suite of applications, included in the professional and higher editions. Microsoft Access is just one part of Microsoft’s overall data management product strategy. It stores data in its own format based on the Access Jet Database Engine. Like relational databases, Microsoft Access also allows you to link related information easily. For example, customer and order data. However, Access 2013 also complements other database products because it has several powerful connectivity features. It can also import or link directly to data stored in other applications and databases. As its name implies, Access can work directly with data from other sources, including many popular PC database programs, with many SQL (Structured