Klientų aptarnavimas: +370 652 87781

Pagalba | Naujas vartotojas | Prisijungti

El. knyga: Access 2016 in easy steps

4.00/5 (19 ratings by Goodreads)

Mike McGrath

Formatas: 192 pages
Serija: In Easy Steps
Išleidimo metai: 16-Oct-2017
Leidėjas: In Easy Steps Limited
ISBN-13: 9781840788006

Kitos knygos pagal šią temą:

Access

Formatas - EPUB+DRM
Kaina: 15,90 €*
* ši kaina yra galutinė, t.y. papildomos nuolaidos nebus taikomos
Įdėti į krepšelį
Įtraukti į pageidavimų sąrašą
Ši e-knyga skirta tik asmeniniam naudojimui. El. knygos nėra grąžinamos.

Formatas: 192 pages
Serija: In Easy Steps
Išleidimo metai: 16-Oct-2017
Leidėjas: In Easy Steps Limited
ISBN-13: 9781840788006

Kitos knygos pagal šią temą:

Access

DRM apribojimai

Kopijuoti:

neleidžiama
Spausdinti:

neleidžiama
El. knygos naudojimas:

Skaitmeninių teisių valdymas (DRM)
Leidykla pateikė šią knygą šifruota forma, o tai reiškia, kad norint ją atrakinti ir perskaityti reikia įdiegti nemokamą programinę įrangą. Norint skaityti šią el. knygą, turite susikurti Adobe ID . Daugiau informacijos čia. El. knygą galima atsisiųsti į 6 įrenginius (vienas vartotojas su tuo pačiu Adobe ID).

Reikalinga programinė įranga
Norint skaityti šią el. knygą mobiliajame įrenginyje (telefone ar planšetiniame kompiuteryje), turite įdiegti šią nemokamą programėlę: PocketBook Reader (iOS / Android)

Norint skaityti šią el. knygą asmeniniame arba „Mac“ kompiuteryje, Jums reikalinga Adobe Digital Editions “ (tai nemokama programa, specialiai sukurta el. knygoms. Tai nėra tas pats, kas „Adobe Reader“, kurią tikriausiai jau turite savo kompiuteryje.)

Negalite skaityti šios el. knygos naudodami „Amazon Kindle“.

Access 2016 in easy steps neatly demonstrates the important functions of Access 2016 in a clear and concise manner, so you can get going quickly with this popular database application. Areas covered include:

Optimizing database design

Creating Tables to store data in formatted fields

Using handy templates to give you a head start

Defining relationships between data

Importing and exporting of data

Making queries to extract specific data

Producing Forms for data entry

Constructing Reports for data presentation

Sharing your database to impress your colleagues!

Whether you’re upgrading to Access 2016 or new to the database concept, use this guide to learn the key features constructively and get more out of Access 2016 – in easy steps!

1 Getting Started

(20)

Introducing Access 2016

(1)

Launching the Access app

(1)

Exploring the user interface

(2)

Customizing Quick Access

(2)

Managing files Backstage

(3)

Personalizing Access options

(1)

Converting older databases

(2)

Using Access templates

(2)

Searching for templates

(2)

Getting some Help

(2)

Applying Access updates

(1)

2 Designing Databases

(10)

Arranging related data

(2)

Understanding relationships

(2)

Developing database design

(2)

Producing data Tables

(2)

Optimizing database design

(1)

3 Creating Tables

(24)

Exploring the Table window

(2)

Working in Datasheet View

(2)

Formatting Datasheets

(2)

Working in Design View

(2)

Managing rows

(1)

Setting the Primary Key

(1)

Selecting data types

(2)

Attaching objects

(1)

Calculating fields

(1)

Specifying field properties

(1)

Stating Validation Rules

(1)

Creating an Input Mask

(1)

Defining a Default Value

(1)

Referencing Indexes

(2)

Providing a Lookup Column

(3)

4 Defining Relationships

(10)

The Relationships window

(2)

Specifying relationships

(2)

Enforcing integrity

(2)

Specifying Join properties

(2)

Directing Joins

(1)

5 Handling Data

(30)

Entering data

(2)

Using the Clipboard

(2)

Copying data to/from Excel

(2)

Importing data from Excel

(5)

Importing data from Access

(4)

Managing import tasks

(1)

Exporting data from Access

(6)

Filtering data

(2)

Totaling fields

(1)

Checking spelling

(1)

Formatting Tables

(3)

6 Making Queries

101

(16)

Introducing Queries

102

(1)

Employing the Query Wizard

103

(3)

Working with Query Design

106

(2)

Adding criteria to a Query

108

(1)

Querying multiple Tables

109

(1)

Stating criteria for numbers

110

(1)

Specifying criteria for text

111

(1)

Creating a Make Table Query

112

(2)

Creating an Append Query

114

(1)

Creating an Update Query

115

(1)

Creating a Delete Query

116

(1)

7 Coding Queries

117

(8)

Introducing SQL

118

(2)

Exploring the SQL window

120

(1)

Using the SELECT clause

121

(1)

Using the WHERE clause

122

(1)

Employing SQL functions

123

(1)

Combining UNION Queries

124

(1)

8 Producing Forms

125

(16)

Designing a Form

126

(2)

Entering data via a Form

128

(2)

Filtering Form data

130

(2)

Employing the Form Wizard

132

(3)

Providing a Simple Form

135

(1)

Offering a Split Form

136

(3)

Presenting Multiple Items

139

(1)

Finding a record

140

(1)

9 Enhancing Forms

141

(20)

Working with Design View

142

(1)

Employing the Field List

143

(1)

Working with Layout View

144

(1)

Adding Headers and Footers

145

(1)

Adding controls to a Form

146

(1)

Fine-tuning Form controls

147

(1)

Changing control properties

148

(1)

Creating Calculated controls

149

(1)

Adjusting the Tab Order

150

(1)

Producing a Tabbed Form

151

(3)

Using Command Buttons

154

(2)

Displaying a Modal Dialog

156

(4)

Executing Macros

160

(1)

10 Supplying Reports

161

(18)

Exploring the Report Wizard

162

(4)

Providing a Simple Report

166

(1)

Working with Design View

167

(1)

Adding fields to a Report

168

(1)

Adding controls to a Report

169

(1)

Adding Headers and Footers

170

(1)

Sorting and grouping data

171

(1)

Printing labels

172

(3)

Setting custom label sizes

175

(1)

Using Print Preview

176

(1)

Printing Reports

177

(1)

Sending Reports via email

178

(1)

11 Sharing Access

179

(8)

Protecting with passwords

180

(2)

Preventing alteration

182

(1)

Securing with backups

183

(1)

Splitting databases

184

(2)

Interacting with SharePoint

186

(1)

Index

187

Mike McGrath gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world. Mike is an established In Easy Steps author with several guides to his credit including: C++; Javascript, Java, Linux, PHP, SQL and Visual Basic Express.

Daugiau apie elektronines knygas