Rename a Field in a Table in Access – Instructions and Video Lesson

A picture that shows how to rename a field in a table in Access.
Overview of Renaming Table Fields in Access             You can rename a field in a table in Access that you have already created to change the field’s name. You should be extremely careful when you do this! This is because any changes you make to field names are not necessarily updated in all the previously
Read more
No Comments

Add Records to a Table in Datasheet View in Access- Instructions

A picture showing how to add records to a table in datasheet view in Access.
Overview of How to Add Records to a Table in Datasheet View in Access             You can easily add records to a table in datasheet view in Access. In datasheet view in Microsoft Access, there is a blank row at the bottom of the table. This row also contains an
Read more
No Comments

Create Input Masks in Access – Instructions

A picture of the “Input Mask Wizard” in Access you use to create input masks in Access.
Overview of Creating Input Masks in Access             You can create input masks in Access for table fields to dictate a pattern to use for data entry in the fields. You can manually create input masks for most text, date, and number data type fields in Access, except the “Long Text” data type. Access also
Read more
No Comments

Export Data from Access – Instructions

A picture that shows how to export data from Access for Microsoft 365 to Excel.
Overview of Exporting Data from Access             You can easily export data from Access to a wide variety of formats that are available. You can also export other database objects, like forms and reports. However, there are more limitations on the formats to which these types of objects can be exported.             To export data
Read more
No Comments

Create Tables in Access – Instructions

A picture of a user creating a new table in table design view in Access.
Overview of How to Create Tables in Access             This lesson shows you how to create tables in Access. A table is an organized structure that holds information. It consists of fields of information into which you enter the records of the table. A field is a single column within a table, consisting of one
Read more
No Comments

Create Tables in Word – Instructions

Create Tables in Word - Instructions: A picture of a user creating tables in Word by using the grid in the “Table” button’s drop-down menu.
Create Tables in Word: Overview About Creating Tables in Word:             You can create tables in Word for many reasons. It is possible to create tables in Word that manipulate data, like a spreadsheet program. You can also create tables in Word to simply store data. Alternatively, you can use them to help you structure
Read more
No Comments

Insert Table Formulas in Word – Instructions

Insert Table Formulas in Word - Instructions: A picture of the default table formula that Word suggests in the “Formula” dialog box.
Insert Table Formulas in Word: Overview             You can insert table formulas in Word tables to perform simple mathematical functions on data. To insert table formulas in Word that add, subtract, multiply, and divide numbers in the table cells, you insert formulas into cells where you want to show the answers to the mathematical operations
Read more
No Comments

Sort a Table in Word – Instructions and Video Lesson

Sort a Table in Word - Instructions: A picture of a user sorting a table in Word.
Sort a Table in Word: Overview             You can sort a table in Word that is used for storing and organizing data. It is possible to sort a table in Word by one or more columns of data in the table. You can sort a table in Word both alphabetically or numerically. You can also
Read more
No Comments